db-review

Community

Validate database schemas and migrations safely

Authortranhieutt
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill ensures database definitions, migrations, and queries are reviewed for correctness, performance, and integrity before deployment, eliminating risky schema changes and unnoticed data issues.

Core Features & Use Cases

  • Schema sanity checks: Ensure every table has appropriate keys, timestamps, constraints, and column types that reflect the business model.
  • Indexing and migration review: Verify index coverage, unique constraints, rollback paths, and zero-downtime migration strategies ahead of release.
  • Query quality and data integrity: Flag SELECT * patterns, N+1 query risks, missing pagination, and absent constraints that could lead to orphaned records.
  • Use Case: Before shipping a product launch, run the skill against the new schema and migration scripts to confirm operational safety and performance.

Quick Start

Ask db-review to audit the schema and migration files before merging the branch into production.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: db-review
Download link: https://github.com/tranhieutt/software_development_department/archive/main.zip#db-review

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.