db-mysql

What problem does it solve? Working with MySQL in a growing project often leads to missing foreign key indexes, inconsistent charsets, non-reversible migrations, and unverified slow queries. This Skill provides a phase-by-phase checklist so database work is specified, implemented, and reviewed consistently. ## Core Features & Use Cases - Schema Specification: Defines what to document per table in requirements specs, including columns, constraints, foreign keys with ON DELETE/ON UPDATE behavior, and justified indexes. - Migration Conventions: Enforces an implementation order covering UP migrations, separate index migrations for large tables, structure verification with DESCRIBE or SHOW CREATE TABLE, and functional DOWN migrations. - Performance Review: Provides a closing checklist covering EXPLAIN ANALYZE verification, explicit FK indexes, utf8mb4 charset, no SELECT * in production, and environment-based credentials. - Use Case: When adding a new feature that creates tables and relationships in the thyrox project, use this Skill during design to specify the schema, during implementation to write reversible migrations, and during review to confirm query performance. ## Quick Start Ask the AI to design the MySQL schema and migrations for a new feature following the db-mysql phase guidelines.