skills.rest
foutoucour
foutoucourCOMMUNITY
Explore all skills by this author →
𝕏@jordiriera_cgGitHub

database-review

Audit database schemas, indexes, queries, and migrations for correctness and safety.

Updated Mar 24, 2026
Search Tags:#performance#indexing#schema#migration#data-integrity#database-review
One-click install
npx skills add https://github.com/foutoucour/guitar-match --skill database-review-foutoucour
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-review
Source: https://github.com/foutoucour/guitar-match/tree/main/.claude/skills/database-review
Command: npx skills add https://github.com/foutoucour/guitar-match --skill database-review-foutoucour

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Review and validate database schemas, indexing strategies, queries, and migration plans to prevent defects, performance bottlenecks, and data loss.

Core Features & Use Cases

  • Schema validation: Check normalization levels, data types, NOT NULL constraints, and foreign keys.
  • Indexing & performance: Identify missing or redundant indexes, and suggest optimizations for read/write workloads; analyze query patterns and propose improvements.
  • Migration safety & governance: Review backward-compatibility, rollback strategies, and risk of destructive migrations.

Quick Start

Audit a provided migration file or schema file to identify risks and suggest safe, production-ready changes.

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 missing constraints and data types?▼

A database schema review checks normalization levels, verifies appropriate data types, validates NOT NULL constraints, and audits foreign keys to ensure data integrity and prevent structural defects.

What is the best way to identify missing or redundant indexes during a database review?▼

A database index review identifies missing or redundant indexes by analyzing query patterns and read/write workloads, providing recommendations to optimize indexing strategies and improve overall query performance.

How do I check if a database migration is backward-compatible and safe for production?▼

To check database migration safety, review backward-compatibility, validate rollback strategies, assess backfill considerations, and identify risks of destructive changes to ensure safe, production-ready deployments.

Can I use a database review process for both relational and NoSQL databases?▼

Yes, the database review process is applicable to both relational and NoSQL databases, allowing you to audit schemas, indexing strategies, queries, and migrations for correctness, safety, and performance across different database types.

Why do I need to audit database queries and indexing strategies together?▼

Auditing database queries and indexing strategies together reveals how query patterns interact with read/write workloads, exposing missing or redundant indexes and enabling targeted performance tuning optimizations.

Related Skills

Explore More Software Engineering Skills→
luisgustavooliveiraluisgustavooliveira

reversa-data-master

Analyze DDL, migrations, and ORM models to generate ERDs and database documentation.

Community
Advanced
Rune-kitRune-kit
82

db

Generate and validate database schema migrations for ORMs and raw SQL.

Official
Advanced
cyperx84cyperx84
2

Query Optimization

Analyze EXPLAIN plans and recommend indexing strategies for SQL queries.

Community
Advanced
mahg-esmahg-es
3

cicd-pipeline

Generate CI/CD pipelines with lint, build, test, and deploy stages.

Official
Advanced