Skip to main content
skill CX Codex

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

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add alexj11324/Mikka --skill db-review -a claude-code
Open on GitHub

What 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 ANALYZE output 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-code

2Manually: put the files in place

~/.claude/skills/db-review/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/db-review/

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.

Similar skills

All skills for Data and databases →

From the same set47

The whole set →
writing-shape writing-shape is a Claude Code skill that turns raw notes into an article through a step-by-step writing session. The author chooses the opening and builds the piece one block at a time. CX Codex +1 ★ 88repo stars software-factory software-factory is a Claude Code skill that establishes a strict architectural vocabulary for agentic coding factories. Organizes services into slots and breaks workflows into isolated task runs. CX Codex +1 ★ 88repo stars node-ops node-ops is a Claude Code skill for operating Node.js apps in production. It covers deployment questions, process shutdown, health checks, and memory leaks. CX Codex +1 ★ 88repo stars incident incident is a Claude Code skill that guides engineers through production outages. Activates when systems fail, alert thresholds trigger, or during post-mortem reviews. CX Codex +1 ★ 88repo stars perf perf is a Claude Code skill that guides performance troubleshooting across database bottlenecks, CPU spikes, memory leaks, and high latency. Runs during profiling or benchmark analysis. CX Codex +1 ★ 88repo stars update-docs update-docs is a Claude Code skill that finds project docs affected by code or decision changes. It proposes edits first and waits for approval. CX Codex +1 ★ 88repo stars ios-design ios-design is a Claude Code skill that builds and evaluates iPhone UI/UX across SwiftUI, UIKit, and React Native. Runs during layout redesigns, navigation updates, and safe-area audits. CX Codex +1 ★ 88repo stars security security is a Claude Code skill that reviews code, APIs, and system designs for security risks. It activates for vulnerability checks, auth reviews, input handling, and threat modeling. CX Codex +1 ★ 88repo stars

Project sponsors

Companies that keep this analytics open