Analyzes and optimizes database schemas for normalization, data integrity, and high-performance indexing.
The Schema Reviewer skill provides a comprehensive audit of your database design, ensuring compliance with normalization standards and industry best practices. It automatically identifies structural issues such as normalization violations, missing constraints, and incorrect data types—like using floating-point numbers for currency. By reviewing SQL, Prisma, and migration files, it helps developers build scalable, reliable data models while suggesting optimal indexing strategies to prevent performance bottlenecks before they reach production.
Características Principales
01Comprehensive index strategy and planning recommendations
02Relationship design review for N:M and hierarchical structures
030 GitHub stars
04Normalization analysis (1NF, 2NF, and 3NF validation)
05Constraint and referential integrity auditing
06Data type optimization for storage efficiency and accuracy
Casos de Uso
01Identifying missing indexes and constraints in existing migration files
02Reviewing Prisma or SQL schemas during the architecture phase of a project
03Auditing new database table designs for normalization and best practices
