skills.rest
adrien-barret
adrien-barretCOMMUNITY
Explore all skills by this author →
𝕏@AtemisLabGitHub

database-review

Analyze database schemas, indexing strategies, queries, and migrations for performance and integrity.

8|4|Updated Feb 7, 2026
Search Tags:#performance#indexing#database#schema#migration#review
One-click install
npx skills add https://github.com/adrien-barret/claude-kit --skill database-review
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-review
Source: https://github.com/adrien-barret/claude-kit/tree/main/project-template/.claude/skills/database-review
Command: npx skills add https://github.com/adrien-barret/claude-kit --skill database-review

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps engineers identify design flaws by reviewing database schemas, indexing strategies, and migrations.

Core Features & Use Cases

  • Schema health checks: normalization to 3NF, appropriate data types, NOT NULL constraints, and foreign key presence.
  • Indexing evaluations: detect missing, redundant, or composite indexes, and assess partial indexes for filtered queries.
  • Migration safety & query optimization: identify risky migrations, potential downtime factors, and opportunities to avoid full table scans.
  • Use Case: When auditing a relational or NoSQL schema, use this Skill to surface schema issues, indexing gaps, and migration risks that could impact performance and data integrity.

Quick Start

Run the database-review against your schema file, migration script, or sample query to identify issues and improvements.

Frequently Asked Questions about database-review

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I review a database schema for normalization and missing constraints?▼

Schema review checks normalization to 3NF, verifies appropriate data types, and flags missing NOT NULL constraints and foreign keys to improve data integrity.

What is the best way to detect missing or redundant indexes in a database?▼

Indexing evaluation detects missing, redundant, and composite indexes, and assesses partial indexes for filtered queries to optimize database performance and prevent slow table scans.

How do I check if a database migration is safe and won't cause downtime?▼

Migration safety reviews identify risky database migrations and potential downtime factors, highlighting full table scans and operations that could impact availability before deployment.

Can I use this database review tool for both relational and NoSQL schemas?▼

Yes, the database review skill analyzes both relational and NoSQL databases, auditing schema health, indexing strategies, and queries to improve performance and data integrity.

Why does my database query result in a full table scan?▼

Full table scans often occur due to missing or inadequate indexes; query optimization evaluates indexing strategies to detect missing composite or partial indexes for filtered queries.

Related Skills

Explore More Data & Analytics Skills→
DatTran26DatTran26

ck:databases

Translate business requirements into scalable MongoDB and PostgreSQL schema designs.

Community
Advanced
randalmurphalrandalmurphal

database-design-patterns

Identify and resolve database schema design inefficiencies across PostgreSQL, MySQL, and SQL workloads.

Community
Advanced
thehivegroup-aithehivegroup-ai

postgres-standards

Manage PostgreSQL schema design, migrations, and query optimization with psycopg2.

Official
Intermediate
Holo00Holo00
6

database-changes

Generate idempotent SQL migrations for IdeaForge database schema changes.

Community
Intermediate