with one click
sql-optimization
SQL query optimization techniques and best practices
Menu
SQL query optimization techniques and best practices
Generate MetricFlow metrics from natural language business descriptions
Mine shortest atomic facts from (question + gold_sql) pairs into ./knowledge/*.md; either by simulating SQL drafting (lite) or by driving the gen_sql subagent in blind iteration (deep)
Initialize project workspace — generate AGENTS.md with architecture, directory map, services, and artifacts
Generate MetricFlow semantic models from database tables with validation and Knowledge Base publishing
Create database tables from SQL (CTAS) or natural language descriptions
Activate when the gen_job agent detects that the source and target databases differ. Covers cross-database transfer lifecycle - type mapping via adapter Mixin hints, DDL generation, data transfer via transfer_query_result, and lightweight reconciliation.
| name | sql-optimization |
| description | SQL query optimization techniques and best practices |
| tags | ["sql","performance","optimization"] |
| version | 1.0.0 |