Agent-Skills.md

Agent Skills: MySQL Best Practices

MySQL database development standards. Triggers when working with MySQL databases, queries, schema design, or optimization.

UncategorizedID: jcastillotx/vibe-skeleton-app/mysql-best-practices

Repository

jcastillotx/vibe-skeleton-app
jcastillotx

Install this agent skill to your local

pnpm dlx add-skill https://github.com/jcastillotx/vibe-skeleton-app/tree/HEAD/setup/skills/mysql-best-practices

Skill Files

Browse the full folder contents for mysql-best-practices.

Download Skill

Loading file tree…

setup/skills/mysql-best-practices/SKILL.md

Skill Metadata

Name
mysql-best-practices
Description
MySQL database development standards. Triggers when working with MySQL databases, queries, schema design, or optimization.

MySQL Best Practices

Comprehensive coding standards for MySQL database development, optimized for AI agents and LLMs.

Overview

This skill provides 24 rules organized across 8 categories:

  1. Query Optimization (query-) - EXPLAIN, N+1 prevention, pagination [CRITICAL]
  2. Security (security-) - Prepared statements, least privilege, encryption [CRITICAL]
  3. Schema Design (schema-) - Data types, normalization, constraints [HIGH]
  4. Indexing Strategy (index-) - Composite indexes, covering indexes [HIGH]
  5. Transaction Management (txn-) - ACID, isolation levels, deadlocks [MEDIUM-HIGH]
  6. Connection Management (conn-) - Pooling, timeouts [MEDIUM]
  7. Backup & Recovery (backup-) - Strategies, point-in-time recovery [MEDIUM]
  8. Replication (repl-) - Master-slave, read replicas [LOW-MEDIUM]

Usage

Reference this skill when:

  • Designing database schemas
  • Writing or optimizing SQL queries
  • Implementing indexes
  • Managing transactions
  • Configuring connections

Build

pnpm build    # Compile rules to AGENTS.md
pnpm validate # Validate rule files