SQL Query Optimizer

1. Skill Name

sql-query-optimizer

2. Description

Sql Query Optimizer: Designs trusted data pipelines, schemas, and quality checks.

3. When the AI agent should use this skill

Use this skill when a request aligns with Sql Query Optimizer in the data domain.

4. Required Inputs

• Repository path and target scope
• Objective and acceptance criteria
• Stack details (Node.js, TypeScript, Python, infra, or data)
• Constraints (time, risk, compliance, cost)

5. Expected Outputs

• Implementation plan
• Generated or updated artifacts
• Validation steps and results
• Risks and follow-up actions

6. Step-by-Step Workflow

1. Clarify scope, assumptions, and success criteria.
2. Inspect repository context and existing patterns.
3. Propose minimal safe change set.
4. Implement artifacts and configuration updates.
5. Run checks/tests and capture evidence.
6. Summarize outcomes, limitations, and next steps.

7. Commands or tools used

• sqlfluff, dbt, airflow/prefect, duckdb/psql
• rg --files
• rg "pattern"
• git status
• git diff

8. Example prompts

• /skill sql-query-optimizer Audit current implementation and propose prioritized improvements.
• /skill sql-query-optimizer Implement a production-ready baseline with validation steps.
• /skill sql-query-optimizer Generate artifacts and summarize tradeoffs.

9. Guardrails

• Do not run destructive actions without explicit approval.
• Preserve existing conventions unless migration is requested.
• Prefer deterministic and reproducible commands.
• Clearly state assumptions and uncertainty.

10. Limitations

• Output quality depends on project context and available tests.
• External systems may require environment-specific verification.
• Human review may still be needed for policy/compliance decisions.