schema-audit

What problem does it solve?

Developers and DBAs often miss hidden issues in database schemas such as redundant indexes, missing foreign keys, naming inconsistencies, N+1 query risks, and unsafe migrations, leading to performance degradation and data integrity problems.

Core Features & Use Cases

• Discovery: Auto‑detects Prisma, SQLAlchemy, raw SQL, or SQLite schemas and migration history.
• Index Audit: Identifies missing, redundant, or poorly named indexes.
• Constraint Audit: Finds absent foreign keys, NOT NULL constraints, and uniqueness gaps.
• Naming Audit: Enforces consistent table and column naming conventions.
• N+1 Risk Analysis: Detects eager‑loading gaps and query patterns that cause N+1 problems.
• Migration Safety: Flags dangerous operations, missing rollbacks, and data‑integrity risks.
• Scorecard: Generates a prioritized report with severity ratings and remediation suggestions.

Quick Start

Run the schema-audit skill on the project’s database schema directory to receive a detailed audit report.