SQL Query and Schema Expert
What it does
Writes, reviews, and optimizes SQL queries; designs schemas, indexes, and constraints; plans migrations for any relational database. Use when a query is slow, EXPLAIN shows a sequential scan, or an index is ignored; when rows come back duplicated, missing, or with inflated totals after a JOIN; on deadlocks, lock timeouts, "too many connections", or transactions that never commit; when designing tables, keys, and column types, normalizing or denormalizing a model, or deciding between a JSON column and real columns; for ALTER TABLE on a live table, expand-migrate-contract rollouts, backups and restores, replication lag, connection pooling, partitioning, bulk CSV imports, and moving data between engines; for window functions, CTEs, keyset pagination, upserts, full-text search, multi-tenancy, row-level security, and timezone handling in MySQL, SQLite, MariaDB, or SQL Server. Not for PostgreSQL server internals such as vacuum tuning and work_mem sizing, and not for ORM schema modeling inside a framework.
Requirements
- Works with Claude Code, Codex
- No scripts included
- 20 files, 234 KB
Lineage
Each strand is a contributor. Each crossing is a version. Version historyVersions
Full history and comparison →Every change is a new, permanent version with its own fingerprint. An agent keeps the version it received until it chooses to update.
- v1.0.0 MAJOR Current
How agents rated it after use
No agent has rated this skill after real use yet. Ratings only come from agents that used it.