skills.rest
KeyValueSoftwareSystems
KeyValueSoftwareSystemsOFFICIAL
Explore all skills by this author →
WebsiteGitHub

mysql-patterns

Standardize MySQL and MariaDB schema design, query optimization, and transaction handling.

3|Updated Jul 1, 2026
Search Tags:#database#optimization#schema#sql#transactions#mysql#mariadb
One-click install
npx skills add https://github.com/KeyValueSoftwareSystems/maestro --skill mysql-patterns-keyvaluesoftwaresystems
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mysql-patterns
Source: https://github.com/KeyValueSoftwareSystems/maestro/tree/main/skills/stacks/db/mysql-patterns
Command: npx skills add https://github.com/KeyValueSoftwareSystems/maestro --skill mysql-patterns-keyvaluesoftwaresystems

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill addresses the complexity of managing MySQL and MariaDB databases by providing standardized, production-ready patterns for schema design, query optimization, and transaction management.

Core Features & Use Cases

  • Schema & Indexing: Provides best practices for surrogate keys, JSON columns, and composite index ordering to ensure high performance.
  • Query Optimization: Offers battle-tested patterns for upserts, keyset pagination, and full-text search while avoiding common anti-patterns like deep offsets.
  • Operational Safety: Includes guidance on transaction handling, connection pooling, and security configurations to prevent deadlocks and unauthorized access.

Quick Start

Use the mysql-patterns skill to review the proposed schema and query performance for the new orders table migration.

Frequently Asked Questions about mysql-patterns

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize MySQL schema design and indexing for production environments?▼

Optimize MySQL schema design by applying standardized patterns for surrogate keys, JSON columns, and composite index ordering to ensure high-performance database operations in production environments.

What is the best way to handle slow query debugging and avoid deep offset anti-patterns in MariaDB?▼

Handle slow query debugging in MariaDB by replacing deep offset anti-patterns with battle-tested patterns for upserts and keyset pagination to improve query performance.

How do I prevent deadlocks during MySQL transaction management?▼

Prevent deadlocks during MySQL transaction management by applying operational safety patterns for transaction handling and connection pooling to secure database infrastructure and prevent unauthorized access.

Does this approach support cross-engine syntax compatibility for database migration reviews?▼

Cross-engine syntax compatibility is supported for database migration reviews, ensuring standardized query optimization and schema design across both MySQL and MariaDB infrastructures.

Can I use full-text search patterns for high-performance query optimization in MySQL?▼

Full-text search patterns are available for high-performance query optimization in MySQL, providing battle-tested approaches alongside keyset pagination and upserts to avoid common anti-patterns.

Related Skills

Explore More Software Engineering Skills→
paultyngpaultyng
9

review-database

Review PostgreSQL and MySQL migrations, queries, and schema designs.

Community
Advanced
george11642george11642
2

db-supabase

Execute SQL, apply migrations, and deploy edge functions via Supabase MCP tools.

Community
Intermediate
ri-ruri-ru

supabase-postgres-best-practices

Provide Postgres performance optimization and schema design guidelines for developers.

Community
Advanced
HouseGarofaloHouseGarofalo
3

database-mode

Guide relational and NoSQL database design, modeling, and query optimization.

Official
Advanced