skills.rest
MassimilianoPili
MassimilianoPiliCOMMUNITY
Explore all skills by this author →
GitHub

dba-mysql

Design and administer MySQL 8.0/MariaDB 11.x databases with InnoDB schemas and Flyway migrations.

Updated Mar 7, 2026
Search Tags:#schema design#database#optimization#migration#sql#mysql#mariadb
One-click install
npx skills add https://github.com/MassimilianoPili/agent-framework --skill dba-mysql
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dba-mysql
Source: https://github.com/MassimilianoPili/agent-framework/tree/main/.claude/agents/dba-mysql
Command: npx skills add https://github.com/MassimilianoPili/agent-framework --skill dba-mysql

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill addresses the complexities of designing, implementing, and maintaining MySQL 8.0/MariaDB 11.x databases, ensuring efficient schema design, reliable migrations, and optimized query performance.

Core Features & Use Cases

  • Schema Design: Create robust InnoDB schemas with appropriate data types, indexes, and constraints.
  • Migration Scripts: Generate Flyway-compatible SQL scripts for database evolution.
  • Query Optimization: Analyze and optimize SQL queries using EXPLAIN FORMAT=TREE and other tools.
  • Use Case: Design a new products table with utf8mb4 encoding, a composite primary key, and a full-text index on the description column, then generate the corresponding Flyway migration script.

Quick Start

Use the dba-mysql skill to create a Flyway migration script for a new orders table with order_id as the primary key and an order_date timestamp.

Frequently Asked Questions about dba-mysql

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

FAQPage Schema
How do I design an InnoDB schema with a full-text index in MySQL 8.0?▼

To design an InnoDB schema with a full-text index in MySQL 8.0, you create tables using utf8mb4 encoding and add a full-text index to target columns like descriptions. This ensures efficient text search capabilities while maintaining robust database performance.

How do I generate Flyway-compatible migration scripts for a new database table?▼

Generating Flyway-compatible migration scripts for a new database table requires defining the schema with primary keys, data types, and constraints in SQL. This process produces versioned migration files that safely evolve your MySQL or MariaDB database structure.

What is the best way to optimize slow SQL queries using EXPLAIN FORMAT=TREE?▼

Optimizing slow SQL queries using EXPLAIN FORMAT=TREE involves analyzing the execution plan to identify bottlenecks like full table scans or missing indexes. You can then adjust your schema indexes and refine query structures to improve database performance.

Does this approach support both MySQL 8.0 and MariaDB 11.x database administration?▼

Yes, this database administration approach fully supports both MySQL 8.0 and MariaDB 11.x environments. It handles InnoDB schema design, partitioning, replication, and user management while adhering to best practices for both platforms.

How do I implement partitioning and replication for a MariaDB 11.x database?▼

Implementing partitioning and replication for a MariaDB 11.x database involves configuring table partitioning rules and setting up replication topologies. This ensures high availability, efficient data management, and improved query performance across distributed database environments.

Related Skills

Explore More Software Engineering Skills→
KeyValueSoftwareSystemsKeyValueSoftwareSystems
3

mysql-patterns

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

Official
Advanced
jabrenajabrena
423

513-frameworks-micronaut-db-migrations-flyway

Manage Flyway database migrations in Micronaut applications.

Community
Advanced
ananddtyagiananddtyagi
687

API Contract Sync Manager

Validate API contracts against backend implementations and generate TypeScript clients.

Community
Advanced
huidgehuidge
2

database-design-and-caching

Design and optimize relational and NoSQL database schemas, indexes, and Redis caching patterns.

Community
Advanced