db-review — Claude Code skill: database reviews and setup
db-review is a Claude Code skill that reviews database schemas, queries, and migrations. It activates for schema design, index choices, query tuning, and migration safety checks.
AGPL-3.0 ★ 88 updated 2026-11-17
npx skills add alexj11324/Mikka --skill db-review -a claude-codeWhat db-review does
db-review examines table structures, SQL, and migration plans for correctness, performance, and safety. For query analysis, it calls for comparing actual execution through EXPLAIN ANALYZE with the estimates in EXPLAIN. It also covers N+1 query patterns, broad SELECT * reads, and transaction lock scope.
For PostgreSQL migrations, the skill describes approaches such as creating indexes with CREATE INDEX CONCURRENTLY and changing a column name through a staged switch to a replacement field. Changing a column’s type usually rewrites the table. Migration review also covers compatibility with the previous application version and rollback planning.
The skill recommends indexes for foreign keys and columns used by frequent filters, sorts, and joins. A composite index on (a, b, c) does not serve a query that filters on b alone. Migration checks include timing the change against a dataset resembling production.
What it helps with
- design table schemas and choose primary keys
- trace a slow SQL query through its execution plan
- order columns in a composite index
- assess migration locks and compatibility during deployment
- plan a rollback for a schema change
Example prompts for the agent
- Review this database schema and suggest suitable primary keys.
- Analyze the
EXPLAIN ANALYZEoutput and find why the query is slow. - Assess a column-rename migration and outline a rollback plan.
How to install db-review
1Skills CLI (Vercel)
npx skills add alexj11324/Mikka --skill db-review -a claude-code2Manually: put the files in place
~/.claude/skills/db-review/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/db-review/
1Skills CLI (Vercel)
npx skills add alexj11324/Mikka --skill db-review -a codex2Manually: put the files in place
.agents/skills/db-review/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add alexj11324/Mikka --skill db-review -a cursor2Manually: put the files in place
.cursor/skills/db-review/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install alexj11324/Mikka .claude/skills/db-review2Manually: put the files in place
.github/skills/db-review/SKILL.md1Skills CLI (Vercel)
npx skills add alexj11324/Mikka --skill db-review -a gemini-cli2Platform CLI
gemini skills install https://github.com/alexj11324/Mikka --path .claude/skills/db-reviewManually: put the files in place
.devin/skills/db-review/SKILL.mdThe legacy .windsurf/skills/ path still works
Claude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about db-review
How do I install db-review in Claude Code?
Run npx skills add alexj11324/Mikka --skill db-review -a claude-code. The skill file is installed at ~/.claude/skills/db-review/SKILL.md.
What does db-review do?
It reviews schemas, SQL queries, indexes, and migrations. The skill also examines query plans and locking risks during database changes.
Which PostgreSQL migration approaches does db-review cover?
It covers creating indexes with CREATE INDEX CONCURRENTLY and renaming columns in stages, switching reads to the replacement before removing the old column.