Enforces standardized MySQL 8.0+ development patterns for schema design, indexing, and data integrity.
This skill provides a comprehensive framework for MySQL database development, ensuring optimal performance, scalability, and maintainability across modern environments. It guides Claude to automatically apply best practices such as InnoDB storage engines, utf8mb4 character sets, and consistent snake_case naming conventions. By codifying decisions around primary key strategies, timezone handling, and exact numeric types for financial data, it helps developers avoid common pitfalls in database architecture and SQL implementation.
Key Features
010 GitHub stars
02Ensures financial data integrity by mandating DECIMAL over floating-point types
03Differentiates between TIMESTAMP and DATETIME for accurate temporal data
04Standardizes on InnoDB engines and utf8mb4 character sets for maximum reliability
05Enforces consistent snake_case naming conventions for all database identifiers
06Provides expert guidance on primary key selection (BIGINT vs. Binary UUIDs)
Use Cases
01Architecting new relational database schemas for high-performance applications
02Standardizing legacy database configurations during a migration to MySQL 8.0+
03Reviewing existing SQL migration scripts for performance and compatibility issues
