sql-pro - Modern SQL query optimization and database design
Optimize modern SQL queries and database designs for cloud-native, OLTP, OLAP, and hybrid workloads.
Tags
Updated: 2026-09-30Capabilities
Typical Inputs
Typical Outputs
What this skill does
- Define query goals
- Inspect schemas and statistics
- Optimize SQL queries
- Validate with EXPLAIN
- Verify correctness and performance
- Preserve workflow provenance
- Load relevant support files
- Route tasks to related skills
Inputs
- Query goals and constraints
- Expected outputs
- Schema and statistics
- Access paths and query plans
- Workload characteristics
- Repository provenance files
- Copied upstream support files
Outputs
- Optimized SQL queries
- Database schema designs
- EXPLAIN validation results
- Performance verification findings
- Provenance-aware review notes
- Skill handoff recommendations
Requirements
- SQL-capable database environment
- Access to schema details
- Access to query plans
- Ability to run EXPLAIN
- Read access to metadata.json and ORIGIN.md