Sql Expert

What it does

This skill enables AI agents to write, optimize, and execute SQL queries directly within database environments. It handles complex data manipulation tasks including joins, aggregations, and schema interactions across various relational database systems.

When to use it

• Extracting specific customer records based on multiple filtering criteria like date ranges and transaction amounts.
• Generating summary reports that aggregate sales data by region or product category using GROUP BY clauses.
• Modifying existing database schemas by creating new tables, adding columns, or updating foreign key constraints.
• Debugging slow-performing queries by analyzing execution plans and rewriting inefficient logic.

Key capabilities

• Writing standard SQL syntax for SELECT, INSERT, UPDATE, and DELETE operations.
• Executing complex joins across multiple related tables to retrieve unified datasets.
• Performing data aggregation with functions like SUM, AVG, COUNT, and MIN/MAX.
• Interacting with diverse database engines including PostgreSQL, MySQL, and SQLite.

Example prompts

• "Write a query to find all users who have made purchases over $500 in the last 30 days."
• "Create a new table called 'audit_log' with columns for timestamp, user_id, and action_type."
• "Optimize this slow query that joins five tables together to reduce execution time."

Tips & gotchas

Ensure your AI agent has read/write permissions on the target database before attempting schema modifications or data updates. Always validate generated queries against a test environment first to prevent accidental data loss in production systems.