mysql

Name: mysql
Availability: InStock
Author: mangorocketofficial

Plan and review MySQL/InnoDB schemas, indexing, queries, and transactions.

Updated Feb 27, 2026

Search Tags:#performance #indexing #database #optimization #schema #sql #mysql

Ready to run

npx skills add https://github.com/mangorocketofficial/thohago_marketing_aiagent --skill mysql-mangorocketofficial

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: mysql
Source: https://github.com/mangorocketofficial/thohago_marketing_aiagent/tree/main/.agent/skills/mysql
Command: npx skills add https://github.com/mangorocketofficial/thohago_marketing_aiagent --skill mysql-mangorocketofficial

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps you plan and review MySQL/InnoDB schema, indexing, query tuning, transactions, and operations to ensure safe, efficient database performance.

Core Features & Use Cases

Schema Design: Guidance on primary keys, data types, character sets, and normalization.
Indexing Strategies: Best practices for composite indexes, covering indexes, and index maintenance.
Query Optimization: Techniques for analyzing EXPLAIN plans, optimizing queries, and avoiding common pitfalls.
Transaction Management: Advice on isolation levels, locking, and deadlock prevention.
Operations: Best practices for partitioning, online DDL, and connection management.
Use Case: Diagnose and resolve slow-running queries, optimize table structures for better read/write performance, or plan safe database schema migrations.

Quick Start

Use the mysql skill to analyze the EXPLAIN plan for the query 'SELECT * FROM users WHERE status = "active";'.

Frequently Asked Questions about mysql

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

FAQPage Schema

How do I optimize slow MySQL queries using EXPLAIN plans?▼

To optimize slow MySQL queries, analyze the EXPLAIN plan to evaluate index usage and query execution paths. This helps identify full table scans and common pitfalls, allowing you to apply query tuning techniques for better InnoDB performance.

What are the best indexing strategies for MySQL InnoDB tables?▼

The best indexing strategies for MySQL InnoDB involve using composite indexes and covering indexes to minimize disk I/O and improve read performance. Proper index maintenance is also crucial to ensure efficient database operations over time.

How do I prevent deadlocks and manage transaction isolation levels in MySQL?▼

To prevent deadlocks in MySQL, apply transaction management best practices by carefully selecting transaction isolation levels and minimizing locking contention. This ensures safe concurrent operations and reduces deadlock occurrences in InnoDB.

When do I need to use partitioning or online DDL for MySQL database operations?▼

You need partitioning or online DDL for MySQL database operations when managing large datasets or planning safe schema migrations. These operational best practices help maintain database availability during structural changes.

What should I know before planning a MySQL schema design for high performance?▼

Before planning a MySQL schema design, you need an understanding of SQL and database internals to properly define primary keys, data types, and character sets. This foundational knowledge ensures normalization and efficient read/write performance.

Why does my MySQL query ignore the composite index I created?▼

A MySQL query might ignore a composite index if the query conditions do not align with the leftmost prefix of the index columns. Analyzing the EXPLAIN plan helps identify this issue and guides query rewrites to utilize the index effectively.