skills.rest
sitharaj88
sitharaj88COMMUNITY
Explore all skills by this author →
GitHub

db-mysql

Generate MySQL schemas, queries, indexes, and tuning configurations.

1|Updated Mar 2, 2026
Search Tags:#query optimization#database#schema#sql#replication#performance tuning#mysql
One-click install
npx skills add https://github.com/sitharaj88/claude-skills --skill db-mysql
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: db-mysql
Source: https://github.com/sitharaj88/claude-skills/tree/main/skills/db-mysql
Command: npx skills add https://github.com/sitharaj88/claude-skills --skill db-mysql

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill streamlines the entire lifecycle of MySQL database management, from initial schema design and query optimization to advanced performance tuning and replication setup.

Core Features & Use Cases

  • Schema Design & Generation: Create robust, production-ready table schemas with appropriate data types, indexes, and character sets.
  • Query Optimization: Analyze and improve SQL query performance using EXPLAIN and advanced indexing strategies.
  • Performance Tuning: Generate configuration recommendations for my.cnf to maximize database speed and stability.
  • Replication & Backup: Assist in setting up replication topologies and backup strategies.
  • Use Case: You need to design a new schema for a user management system, ensuring efficient lookups and data integrity.

Quick Start

Use the db-mysql skill to generate a schema for a users table with email, name, and timestamps.

Frequently Asked Questions about db-mysql

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

FAQPage Schema
How do I optimize MySQL query performance using EXPLAIN and indexing?▼

To optimize MySQL query performance, you analyze SQL queries using EXPLAIN and apply advanced indexing strategies. This Skill generates index recommendations and tuning configurations to maximize InnoDB database speed and stability.

What is the best way to design a production-ready MySQL schema?▼

The best way to design a MySQL schema is to generate tables with appropriate data types, character sets, and indexes. This Skill creates robust, production-ready schemas ensuring efficient lookups and data integrity.

How do I set up MySQL replication and backup strategies?▼

Setting up MySQL replication involves configuring replication topologies and defining backup strategies. This Skill assists in generating these setups to ensure database availability and reliable data recovery.

Can I use this for MySQL performance tuning on versions 5.7 and 8.0+?▼

Yes, MySQL performance tuning is supported for versions 5.7 and 8.0+. The process generates my.cnf configuration recommendations and utilizes InnoDB engine best practices to maximize database speed.

When do I need stored procedures in an InnoDB database?▼

You need stored procedures in an InnoDB database to encapsulate complex SQL logic for efficient execution. This Skill generates stored procedures alongside schemas and indexes to streamline database management tasks.

Related Skills

Explore More Software Engineering Skills→
samjhechtsamjhecht
4

initialize-governance

Generate Constitution, Roadmap, and process documentation templates for project governance.

Community
Advanced
randoneeringrandoneering

postgresql

Analyze PostgreSQL configurations, queries, and health metrics for optimization.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
taewook486taewook486

moai-domain-database

Guide database management across PostgreSQL, Oracle, MongoDB, and Redis systems.

Community
Advanced