MySQL & MariaDB Patterns
Production-grade MySQL and MariaDB guidance for Muse: schema defaults, indexing, slow-query triage, transactions, replication, connection pools, and the MySQL-vs-MariaDB gotchas.
- What
- Production-grade MySQL and MariaDB guidance for Muse: schema defaults, indexing, slow-query triage, transactions, replication, connection pools, and the MySQL-vs-MariaDB gotchas.
- Cost
- Free
- Needs
- Use "MySQL & MariaDB Patterns" with your Muse.
- Install
- Copy the installer prompt below into your Muse — your agent does the rest.
Curated by Skill Harbor: a production MySQL and MariaDB playbook that makes Muse start every database question with a version check, because the two engines have diverged in SQL details (VALUES(col) deprecated in MySQL but supported in MariaDB, SKIP LOCKED only for queue-style work). Schema defaults are spelled out: BIGINT UNSIGNED AUTO_INCREMENT keys, BINARY(16) for UUIDs, InnoDB, utf8mb4. Indexing covers composite indexes ordered for real query patterns, covering indexes, and when not to index. The slow-query section walks through EXPLAIN interpretation, lock waits, and deadlocks. Transactions cover isolation levels, queue-style consumption, upserts, and optimistic locking. Replication guidance addresses read replicas, lag detection, and failover. Connection pool tuning covers sizing, timeouts, and TLS. Migrations get a review checklist for large production tables where ALTER can lock everything. Keyset pagination, full-text search, JSON columns, and soft deletes all get concrete SQL. By @affaan-m, listed here with credit to its creator. From the affaan-m/ECC repository (MIT). Honest caveats: always verify the engine version before applying a pattern, what works in MySQL 8 may not exist in MariaDB; pool sizing depends on your workload, start conservative. Skill Harbor never reviews the code, review it yourself before use.
Version:
Install
Copy the install package below, then paste it into MuseThe install prompt below already includes the vetting steps: your agent follows the community checklist before installing anything with executable code. Want more?
Use "MySQL & MariaDB Patterns" with your Muse. Prerequisites: none to install. Pure guidance; a MySQL or MariaDB project helps. 1. Open the skill: https://github.com/affaan-m/ECC/blob/main/skills/mysql-patterns/SKILL.md and copy the full SKILL.md text. 2. Paste it into a chat with Muse and add: "Review my schema design for [table/feature]" or "Help me debug this slow query: [paste EXPLAIN output]." 3. Work with Muse through the relevant patterns. Start with SELECT VERSION() so the right engine guidance applies. Tip: for slow queries, paste the EXPLAIN output first; the skill walks through reading it before changing anything. Safety: a skill is plain-text instructions; it runs nothing by itself. Review generated SQL before running it on production.
Saved to your recent installs. Find it anytime on /connect.
Questions
How do I install a build?
Every product page includes a copy-paste install prompt. Paste it into your Muse and it sets the build up for you — no manual configuration.
Where does my money go?
Straight to the seller. Skill Harbor never processes payments: checkout happens on the seller’s own page, usually Stripe.
What does the ✓ next to a creator’s name mean?
It means we confirmed the identity of the person behind the listing. It says nothing about the code itself — always check a build before installing it.