ccfg-mysql

Scaffold MySQL migration directory or connection configuration for a new or existing project

Run MySQL schema quality gate suite (naming, engine/charset, antipatterns, migration hygiene)

Use this agent for MySQL 8.0+ database administration including schema design, InnoDB engine optimization, character set and collation configuration, JSON column patterns, and database security. Invoke for designing normalized schemas, configuring storage engines, tuning InnoDB buffer pool settings, managing user privileges, optimizing table structures, or troubleshooting database performance issues. Examples: designing a multi-tenant schema, configuring utf8mb4 collation, creating JSON columns with generated column indexes, or auditing database security.

Use this agent for MySQL query performance analysis and optimization including EXPLAIN plan interpretation, index selection strategy, query rewriting for efficiency, optimizer hints, and slow query log analysis. Invoke for diagnosing slow queries, choosing between index strategies, rewriting subqueries as joins, interpreting EXPLAIN output, or profiling query execution. Examples: analyzing a slow report query, optimizing a JOIN-heavy dashboard, choosing composite index column order, or reducing full table scans.

Use this agent for MySQL replication architecture including source-replica topology, Group Replication, InnoDB Cluster, ProxySQL configuration, and GTID-based replication. Invoke for setting up replication, troubleshooting replication lag, configuring read/write splitting, planning failover strategies, or migrating from statement-based to row-based replication. Examples: designing a multi-region replica topology, configuring InnoDB Cluster with MySQL Router, diagnosing replication lag, or implementing ProxySQL query rules.

This skill should be used when writing database migrations, altering tables, adding columns, creating indexes, or planning schema changes for MySQL.

This skill should be used when working on MySQL databases, writing SQL schemas, creating tables, designing database architecture, or reviewing MySQL code.

This skill should be used when analyzing MySQL query performance, running EXPLAIN, tuning indexes, configuring the buffer pool, or optimizing database performance.