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
- none to install. Pure guidance; a MySQL or MariaDB project helps.
- Level
- Beginner
- 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:
Quick answer
MySQL & MariaDB Patterns is a free Muse skill and 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. Schema defaults are spelled out, with indexing, slow-query triage, transactions, replication, connection pools, and MySQL-versus-MariaDB gotchas.
Install
Copy the install package below, then paste it into Muse🧪 Install ran in our test sandbox · Nov 11, 2026📌 Pinned version: commit 4eb71d9Pinned version: install the code at commit 4eb71d92a39cab44ad40ac9d8a6a5ccb4029d6c2 exactly (Skill Harbor tested this version). Do not substitute a newer version. If this commit is unreachable, stop and tell me. Use "MySQL & MariaDB Patterns" with your Muse. Prerequisites: none to install. Pure guidance; a MySQL or MariaDB project helps. 1. Open the skill: https://raw.githubusercontent.com/affaan-m/ECC/4eb71d92a39cab44ad40ac9d8a6a5ccb4029d6c2/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.
🔒 Security, provenance and what this touches
The install prompt below already includes the vetting steps: your agent follows the community checklist before installing anything with executable code. Want more?
Verification certificate
Dated facts about what was checked for this listing, and how. This is not a safety certification.
- Pinned version
- 4eb71d9 · 2026-10-13
- Sandbox install test
- Install ran in our test sandbox · Nov 11, 2026
- Creator identity
- Not verified
- Fingerprint watch
- Last checked · Nov 21, 2026 : no change detected in the files linked by this install prompt
- Install prompt analysis
- 2026-10-13 : No commands, network calls, packages, file writes or API keys detected.
Skill Harbor never reviews the code of a listed skill. These are dated facts about the install prompt and our install test, not a safety certification. Review a skill yourself before you install it. How we verify
Questions
How do I install a skill?
Every product page includes a copy-paste install prompt. Paste it into your Muse and it sets the skill 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 skill before installing it.