What problem does it solve? Database design flaws and drift between schema definitions, migrations, and actual query usage often go unnoticed until they cause production incidents. This Skill runs a comprehensive parallel audit of 25 known database antipatterns plus a current-schema consistency check, so teams can inventory structural DB risks before release. ## Core Features & Use Cases - Parallel Multi-Agent Audit: Launches six specialized sub-agents (logical design, physical design, query, application integration, migration guard, current schema reviewer) simultaneously for fast, full-coverage review. - 25-Antipattern Coverage: Checks classic antipatterns such as EAV, Polymorphic Associations, SQL Injection, Index Shotgun, Ambiguous Groups, and Readable Passwords across four categories. - Schema Consistency Verification: Confirms alignment between schema, migrations, migration journal, foreign keys, indexes, enums, nullability, and validation rules, including safety measures for destructive changes. - Use Case: Before a production release, run this Skill to receive a severity-ranked issue list, a coverage verification report (25/25 patterns checked), and a Current Schema Check Sheet with prioritized remediation actions. ## Quick Start Ask the agent to run a full parallel database antipattern audit on the project and report coverage, severity-ranked findings, and schema consistency results.
