schema-reviewer

Normalization analysis evaluates whether your schema follows third normal form (3NF) by examining table structure, column dependencies, and data redundancy. This Skill reviews your schema files to surface violations and recommend decomposition or restructuring to eliminate anomalies and improve data integrity.

Primary keys, foreign keys, unique constraints, and NOT NULL declarations enforce data integrity rules. This Skill validates existing constraints in your schema and provides SQL recommendations to add missing constraints, preventing invalid data and orphaned records.

Data type selection balances storage efficiency, query performance, and semantic correctness. This Skill analyzes your schema's column types and suggests optimizations—such as enum usage, integer ranges, and text encoding—to reduce storage and improve constraint enforcement.

Index strategy covers foreign key indexes, composite indexes on common filter combinations, and partial indexes for filtered queries. This Skill evaluates your schema against query patterns and recommends specific index designs for PostgreSQL and MySQL to accelerate lookups without overhead.

Yes. This Skill analyzes PostgreSQL and MySQL schemas across migration files, entity definitions, and documentation. It applies the same normalization, constraint, data type, and indexing checks to guide design improvements throughout your schema lifecycle.

Normalization restructures tables to eliminate redundancy and improve data integrity; indexing accelerates queries without changing structure. This Skill addresses both: normalization corrections remove anomalies, while index strategies optimize retrieval for normalized schemas.