Database Admin

What it does

This skill allows an AI agent to perform common database administration tasks. It can execute SQL queries, manage user permissions, and monitor database health. The skill is designed for interacting with relational databases like MySQL or PostgreSQL.

When to use it

• You need to retrieve specific data from a database based on complex criteria.
• A user reports slow query performance, and you want the agent to analyze and optimize queries.
• You require automated backups of your database to ensure data safety and recovery options.
• New users need access granted to a database, and you want to automate the permissioning process.

Key capabilities

• SQL Query Execution: Executes SQL statements against connected databases.
• User Management: Creates, modifies, and deletes user accounts with specific privileges.
• Database Monitoring: Provides insights into database health metrics (e.g., CPU usage, disk space).
• Backup & Restore: Automates the process of backing up and restoring databases.

Example prompts

• "Run a query to find all customers who placed an order in the last month."
• "Create a new user 'data_analyst' with read-only access to the 'sales' table."
• “What is the current disk space usage for the database?”

Tips & gotchas

The agent requires connection details (hostname, username, password) to connect to a specific database. Ensure these credentials are securely managed and accessible to the AI agent.