x-review-database

Analyze database changes against a 20-item checklist for schema, migrations, queries, and integrity.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/edercnj/ia-dev-environment --skill x-review-database
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: x-review-database
Source: https://github.com/edercnj/ia-dev-environment/tree/main/src/main/resources/claude/skills/x-review-database
Command: npx skills add https://github.com/edercnj/ia-dev-environment --skill x-review-database

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Review database changes for design, migrations, queries, and integrity to prevent regressions and downtime.

Core Features & Use Cases

  • End-to-end database review across schema design, migration safety, query optimization, and transaction boundaries.
  • Pre-PR validation and migration script analysis to catch issues before merging.
  • Structured output aligned with a formal 20-item checklist and knowledge-pack references for consistent quality.

Quick Start

Invoke the review by issuing /x-review-database in your Claude Code session.

Frequently Asked Questions about x-review-database

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

FAQPage Schema
How do I review database schema changes before merging a pull request?

Database schema review validates design quality and migration safety by applying a 20-item checklist to pre-PR changes. It analyzes schema design, migration scripts, and transaction boundaries to prevent regressions and downtime before code is merged.

What is the best way to check migration scripts for data integrity and safety?

Checking migration scripts for data integrity involves analyzing transaction boundaries and query efficiency against a formal checklist. This review process catches unsafe migrations and data integrity issues by referencing database-patterns knowledge during evaluation.

How do I optimize database queries during a code review?

Database query optimization during review evaluates query efficiency and schema design against a 20-item checklist. It identifies performance regressions and ensures strong data integrity by analyzing transaction boundaries within the proposed database changes.

Does this database review process work for general projects or specific platforms?

This database review process works across typical projects to validate schema quality, safe migrations, and efficient queries. It applies a comprehensive 20-item checklist to pre-PR validation and migration script analysis without requiring specific platform dependencies.

What does a database code review checklist cover for transaction boundaries?

A database code review checklist covers schema design, migration safety, query optimization, and transaction boundaries. It enforces a 20-item evaluation referencing database-patterns knowledge to ensure strong data integrity and prevent downtime.

Why do I need a formal checklist for database migration reviews?

A formal checklist for database migration reviews ensures consistent quality by evaluating schema design, migration safety, and transaction boundaries. It prevents regressions and downtime by applying structured, repeatable criteria to every pre-PR validation.