hoavdc/CodexKit / skills/codexkit-sql-query-builder
codexkit-sql-query-builder
UnverifiedBuild production-ready analytical SQL queries using CTEs, window functions, aggregations, and data transformations. Translates business questions into well-documented, performant queries. Use when writing reporting queries, building data pipelines, or answering ad-hoc business questions with SQL.
| File | Kind | Size |
|---|---|---|
| SKILL.md | skill md | 6.0 KB |
| agents/openai.yaml | config | 168 B |
| examples/common-mistakes.md | markdown | 842 B |
| examples/good-output.md | markdown | 1.2 KB |
| scripts/query-validator.sql | other | 3.6 KB |
| verification/checklist.md | markdown | 1.4 KB |
verification/checklist.md
View on GitHub# 4C Verification Checklist - SQL Query Builder
Use this checklist before treating a generated query as ready to run.
## Correctness - Is it right?
- [ ] Table and column names match the provided schema.
- [ ] Join keys, join types, and grain are explicitly correct.
- [ ] Filters and date ranges match the business question.
- [ ] Aggregations, window functions, and denominators are mathematically sound.
- [ ] The query matches the stated SQL dialect.
## Completeness - Is it done?
- [ ] Expected output columns are documented.
- [ ] Required filters, grouping, sorting, and limits are included.
- [ ] Null handling and divide-by-zero protection are considered.
- [ ] Performance notes or index assumptions are included for large tables.
## Context-fit - Does it match?
- [ ] Query grain matches the requested decision or report.
- [ ] The output is usable by the intended analyst or stakeholder.
- [ ] CTE names and comments explain the transformation path.
- [ ] The query avoids overengineering when a simple query is enough.
## Consequence - Is it safe to use?
- [ ] Could this query double-count revenue, users, or events?
- [ ] Could missing filters expose sensitive or irrelevant data?
- [ ] Could this query be too expensive to run in production?
- [ ] What data quality issue would most distort the result?
Final check: state the expected row grain in one sentence.
Related skills
| Skill | Stars | Updated | Works with | Status | Install |
|---|---|---|---|---|---|
| writing-skillsobra/superpowersUse when creating new skills, editing existing skills, or verifying skills work before deployment | Stars: 318k | Updated | Claude CodeCodex | Unverified | Install |
| xlsxanthropics/skillsUse this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .xltx, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved. | Stars: 196k | Updated | Claude CodeCodex | Verified | Install |
| shipping-and-launchaddyosmani/agent-skillsPrepares production launches. Use when preparing to deploy to production, or when asking what needs to be in place before shipping. Use when you need a pre-launch checklist, when setting up monitoring, when planning a staged rollout, or when you need a rollback strategy. | Stars: 118k | Updated | Claude CodeCodex | Verified | Install |
| childhoodthedotmack/claude-memBabysit a shipped release after merge, publication, or deployment. Verify published packages, production behavior, installed plugins, and late CI or user reports until the observation window is clean; use babysit for PR readiness before release. | Stars: 117k | Updated | Claude CodeCodex | Unverified | Install |