Mysql Patterns

This is your reference when you're past the MySQL tutorial stage and need production-ready patterns for schema design, indexing, transactions, and connection pools. It covers the version divergence between MySQL and MariaDB (like the VALUES() deprecation in upserts), shows you how to build composite indexes that actually get used, and walks through keyset pagination, queue-style job claiming with SKIP LOCKED, and deadlock prevention. The schema defaults table alone will save you from common mistakes like using FLOAT for money or utf8 instead of utf8mb4. If you're debugging slow queries, tuning connection pools, or reviewing a migration before it locks a production table for twenty minutes, this gives you the patterns and EXPLAIN checklist you need.

Install to Claude Code

npx -y skills add affaan-m/ecc --skill mysql-patterns --agent claude-code