mysql-patterns
MySQL and MariaDB schema, query, indexing, transaction, replication
by affaan-mFree
Description
mysql-patterns is an agent skill from the ECC collection by affaan-m, listed on skills.sh. It covers MySQL and MariaDB work for production backends: schema design, queries, indexing, transactions, replication and connection-pool configuration. The skill tells the agent to identify the engine and its exact version before applying any feature-specific pattern, because MySQL and MariaDB have diverged in several SQL details. It applies when designing tables, indexes and constraints, reviewing migrations before they run against large production tables, debugging slow queries, lock waits, deadlocks or connection exhaustion, adding keyset pagination, upserts, full-text search, JSON columns or queues built on tables, and configuring application connection pools, read replicas, TLS or slow logs. A skill is a SKILL.md file of instructions that an AI agent loads when a task calls for it. It is free and open source, and the skills.sh listing shows all three security audits passing.…
Highlights
- Schema, index and constraint design
- Migration review for large tables
- Slow query, lock and deadlock debugging
- Connection pools, replicas and TLS
Ratings & Reviews
No ratings yet
Be the first to rate mysql-patterns.
People also visit
postgres-patterns
PostgreSQL database patterns for query optimization, schema design, indexing
database-migrations
Safe, reversible database migration patterns: forward-only production changes
jpa-patterns
JPA/Hibernate patterns for entity design, relationships, query optimization
mysql-patterns FAQ
What does the mysql-patterns skill do?
It guides an agent in designing, querying, migrating and tuning MySQL and MariaDB databases for production.
Does it treat MySQL and MariaDB the same?
No. The skill tells the agent to check the engine and version first, since the two have diverged in several SQL details.
Can it help with a slow production query?
Yes. Debugging slow queries, lock waits, deadlocks and connection exhaustion is one of its listed uses.
How do I install it?
Run: npx skills add https://github.com/affaan-m/ecc --skill mysql-patterns
Is it free?
Yes. It is free and open source.
Are there security findings?
The skills.sh listing shows Gen Agent Trust Hub, Socket and Snyk all passing.
What are the best mysql-patterns alternatives?
Popular alternatives to mysql-patterns include postgres-patterns, query-writing and schema-exploration. See all mysql-patterns alternatives