database-admin

What it does

This skill enables AI agents to perform administrative tasks on databases, including managing connections, executing queries, and handling schema operations. It serves as a bridge between natural language instructions and low-level database management protocols.

When to use it

• Automating routine maintenance tasks like vacuuming tables or updating statistics.
• Generating and executing complex SQL queries based on high-level business requirements.
• Managing user permissions and roles within the database environment.
• Monitoring database health and retrieving performance metrics automatically.

Key capabilities

• Database connection management
• Query execution and result retrieval
• Schema modification support
• Administrative command handling

Example prompts

• "Run a vacuum analyze on the 'sales' table to optimize performance."
• "Create a new user named 'report_bot' with read-only access to the inventory schema."
• "Fetch the total revenue for Q3 from the transactions table and format it as a summary."

Tips & gotchas

Ensure your AI agent has the necessary credentials and permissions before attempting administrative actions, as incorrect commands can lead to data loss. Always review generated SQL scripts in a sandbox environment before executing them against production databases.