db-schema-reviewer

Review database schemas and migrations across SQL and ORMs for safety issues.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/sacharavya/b-b-i-crm --skill db-schema-reviewer
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: db-schema-reviewer
Source: https://github.com/sacharavya/b-b-i-crm/tree/main/.claude/skills/db-schema-reviewer
Command: npx skills add https://github.com/sacharavya/b-b-i-crm --skill db-schema-reviewer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This tool helps identify and remediate database schema and migration issues to ensure safety, correctness, and long-term maintainability of data models.

Core Features & Use Cases

  • Review migrations, schemas, and ORM models across SQL and popular ORMs to detect unsafe patterns, missing indexes, and naming inconsistencies.
  • Propose safe remediation patterns and maintainability improvements that minimize downtime and rollback risk.
  • Use cases include validating new tables, column changes, index additions, and FK constraints before deployment.

Quick Start

Provide the migration SQL, Prisma schema, or ORM model you want reviewed, and I will return a structured safety and correctness assessment.

Frequently Asked Questions about db-schema-reviewer

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

FAQPage Schema
How do I review database migrations for lock risks and nullable traps?

You can review database migrations by providing raw SQL, Prisma schema, or ORM models to identify unsafe patterns, missing indexes, and nullable traps to ensure deployment safety and correctness.

Can I check Prisma schema changes for index coverage and relational integrity?

Yes, Prisma schema changes can be checked for index coverage, naming conventions, and foreign-key integrity to ensure long-term maintainability and relational correctness across your data models.

Does the schema reviewer work with TypeORM and Sequelize models?

Yes, the schema reviewer works with TypeORM and Sequelize models, detecting unsafe patterns and proposing safe remediation patterns to minimize downtime and rollback risk across Postgres, MySQL, and SQLite.

What is the best way to validate new tables and foreign-key constraints before deployment?

The best way to validate new tables and foreign-key constraints is to review them for naming inconsistencies, index coverage, and ORM-specific risks, generating a structured safety assessment before deployment.

How do I remediate unsafe ORM-specific risks in Drizzle migrations?

To remediate unsafe ORM-specific risks in Drizzle migrations, review the model changes to detect lock risks and missing indexes, then apply proposed safe remediation patterns to maintain correctness and minimize rollback risk.