data-sql - SQL Query Design and Optimization
SQL query design, optimization, EXPLAIN analysis, index strategy for relational databases
Tags
Updated: 2026-06-30Capabilities
Typical Inputs
Typical Outputs
What this skill does
- write SQL queries
- analyze EXPLAIN plans
- design indexes
- scan database schema
- optimize query performance
- prevent N+1 queries
- review existing SQL
- create upsert statements
Inputs
- SQL query
- database schema
- ORM configuration
- migration files
- connection string
- data requirements
Outputs
- SQL query
- index recommendation
- performance analysis
- schema summary
- implementation report
Requirements
- PostgreSQL
- MySQL
- SQL Server
- SQLite
- Oracle
- database access
- EXPLAIN permission