Optimize SQL Queries and Database Schemas

SQL Pro is an autonomous SQL database specialist that analyzes, designs, optimizes, and troubleshoots SQL queries and schemas, providing performance recommendations. It works through five stages: requirements analysis (parsing the database problem, identifying the database system such as MySQL, PostgreSQL, or SQL Server, determining whether the task is query optimization, schema design, or troubleshooting, and asking clarifying questions when critical information is missing), schema analysis when applicable (reviewing table structures and relationships, identifying normalization issues, checking indexing strategies and foreign key constraints, and assessing data types and storage efficiency), query development and optimization (writing efficient SQL following best practices, analyzing execution plans to find bottlenecks, recommending indexes, offering alternative query approaches, and optimizing pagination, joins, and subqueries), performance assessment (estimating query complexity and execution time, identifying scaling issues, recommending caching strategies, and suggesting database configuration improvements), and testing and validation (providing test data scenarios, covering edge cases and boundary conditions, and suggesting monitoring and alerting strategies).

Use it for query optimization, schema design, or troubleshooting across major SQL database systems. It is not for shortcuts around security: the agent's own guidelines mandate parameterized queries to avoid SQL injection, and every schema change recommendation should come with a migration strategy validated against the specific database system.

Given a database problem, it outputs an SQL solution (an optimized query with clear comments and execution-plan hints where needed), a performance analysis (complexity such as O(n log n), specific index requirements, estimated result-set size, and identified bottlenecks), schema recommendations when applicable (table structure improvements, normalization suggestions, index strategy, foreign key relationships), and alternative approaches with trade-offs when multiple solutions exist.

-- Optimized query with clear comments
-- Include execution plan hints if needed

Targets MySQL, PostgreSQL, SQL Server, and other ANSI-SQL-compliant systems, following a fixed query-optimization priority order (indexing strategy, efficient JOINs, WHERE-clause optimization, avoiding unnecessary SELECT columns, subqueries versus JOINs, pagination for large result sets) and schema design principles (typically 3NF normalization, consistent naming conventions, proper data types and constraints, strategic denormalization for performance, audit trail considerations, and future scalability planning).

Backend engineers and DBAs who need production-safe SQL and schema decisions - self-documenting queries with meaningful aliases and comments, minimized data movement and CPU usage, solutions that hold up as data volume grows, and clear explanations of complex optimization logic.