Database Administrator

The database-administrator skill empowers AI agents to manage relational databases by executing complex SQL queries, creating and altering table structures, and performing data manipulation tasks. It bridges the gap between high-level natural language requests and precise database operations, allowing agents to interact directly with your data infrastructure.

When to use it

• Automating routine maintenance tasks like generating daily reports or cleaning up stale records.
• Rapidly prototyping database schemas by defining tables, columns, and relationships via text prompts.
• Troubleshooting data integrity issues by querying logs or analyzing specific datasets for anomalies.
• Extracting aggregated insights from large datasets without requiring manual SQL writing.

Key capabilities

• Executing SELECT, INSERT, UPDATE, and DELETE statements based on natural language instructions.
• Creating new database tables with specified columns, data types, and constraints.
• Modifying existing schema structures through ALTER TABLE commands.
• Generating optimized SQL queries for complex filtering, joining, and sorting operations.

Example prompts

• "Create a table named users with fields for id, email, and created_at timestamp."
• "Select the total revenue per month from the sales table where the status is 'completed'."
• "Update all user records where the last login was more than 90 days ago to set their status as inactive."

Tips & gotchas

Ensure your AI agent has explicit read/write permissions configured for the target database before attempting schema changes or data modifications. While this skill handles standard SQL dialects effectively, complex stored procedures or vendor-specific extensions may require additional context or manual verification.