Mysql Patterns
- 1.4k installs
- 238k repo stars
- Updated August 5, 2026
- affaan-m/ecc
This is a copy of mysql-patterns by affaan-m - installs and ranking accrue to the original listing.
mysql-patterns is a Claude Code skill that applies battle-tested MySQL and MariaDB patterns for schema design, query optimization, indexing, transactions, replication, and connection pools for developers who need reliabl
About
mysql-patterns is an ECC-origin agent skill that encodes production MySQL and MariaDB conventions for schema design, query tuning, indexing strategy, transactional safety, replication setup, and connection pool configuration. It activates when developers design tables, write slow queries, plan indexes, or configure pools in MySQL-compatible backends. The skill distills repeatable patterns so agents propose normalized schemas, efficient indexes, and pool settings without rediscovering common pitfalls. Developers reach for mysql-patterns when building or refactoring SaaS APIs, admin dashboards, or services backed by MySQL or MariaDB and need opinionated guidance instead of generic SQL snippets.
- Version-aware patterns that keep MySQL and MariaDB guidance separate when syntax differs
- Activation triggers for schema design, migration review, slow-query debugging, and connection-pool configuration
- Includes keyset pagination, upserts, full-text search, JSON columns, queue-style transactions, and read-replica setups
- Always begins with exact version check using SELECT VERSION() and SHOW VARIABLES
- Production-ready patterns for locks, deadlocks, slow logs, and TLS-secured connections
Mysql Patterns by the numbers
- 1,417 all-time installs (skills.sh)
- +91 installs in the week ending Aug 5, 2026 (Skillselion tracking)
- Data as of Aug 5, 2026 (Skillselion catalog sync)
npx skills add https://github.com/affaan-m/ecc --skill mysql-patternsAdd your badge
Show developers this skill is listed on Skillselion. Paste this into your README.
| Installs | 1.4k |
|---|---|
| repo stars | ★ 238k |
| Last updated | August 5, 2026 |
| Repository | affaan-m/ecc ↗ |
How do you design optimized MySQL schemas?
Apply battle-tested MySQL and MariaDB patterns for schema design, query optimization, indexing, transactions, replication, and connection pools.
Who is it for?
Backend developers implementing or tuning MySQL or MariaDB layers in production SaaS or API services.
Skip if: Developers on PostgreSQL-only stacks or teams that only need one-off SELECT queries without schema or performance design.
When should I use this skill?
The developer is designing MySQL tables, debugging slow queries, adding indexes, or configuring replication or connection pools.
What you get
Normalized table schemas, index plans, transaction boundaries, replication notes, and connection pool configuration recommendations.
- Schema design recommendations
- Index and query optimization guidance
- Connection pool configuration notes
Files
mysql-patterns - 日本語翻訳進行中
このファイルの翻訳は実装中です。英語版は元のスキルファイルを参照してください。
詳細は：D:/tmp/everything-claude-code/skills/mysql-patterns/SKILL.md
Related skills
Lark BaseLet their coding agents read from, write to, and query structured data stored in Lark Base (Feishu) spreadsheets and databases.493k
Azure KustoRun fast KQL queries against Azure Data Explorer for log analytics, telemetry, and time-series data.484k1.3k
Lark SheetsCreate, read, update, and export spreadsheets inside Lark (Feishu) directly from their AI coding agent.389k15.9k
Supabase Postgres Best PracticesAutomatically apply Supabase Postgres performance rules during query writing, schema design, and database optimization.313k2.4k
Firebase Data ConnectGenerate complete, production-ready Firebase Data Connect GraphQL schemas and queries for complex relational data models.112k392Firebase FirestoreAdd Cloud Firestore read/write capabilities to an Android Kotlin app using the official Firebase SDK.77k392How it compares
Pick mysql-patterns over generic SQL skills when the stack is specifically MySQL or MariaDB and you need schema, index, replication, and pool guidance together.
FAQ
What does mysql-patterns cover?
mysql-patterns covers battle-tested MySQL and MariaDB patterns for schema design, query optimization, indexing, transactions, replication, and connection pools. Developers use it when building or tuning relational backends.
When should I invoke mysql-patterns?
Invoke mysql-patterns when designing tables, fixing slow queries, planning indexes, or configuring replication and connection pools in MySQL or MariaDB. The skill applies ECC-origin conventions to backend data-layer work.