skills.rest
westonwrz
westonwrzCOMMUNITY
Explore all skills by this author →
GitHub

mysql

Guide MySQL 8.0+ schema design, query optimization, and security hardening.

Updated Aug 27, 2026
Search Tags:#performance#security#database#optimization#sql#operations#mysql
One-click install
npx skills add https://github.com/westonwrz/codex-skills-by-codex --skill mysql-westonwrz
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mysql
Source: https://github.com/westonwrz/codex-skills-by-codex/tree/main/mysql
Command: npx skills add https://github.com/westonwrz/codex-skills-by-codex --skill mysql-westonwrz

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and agents (resource) components.

What problem does it solve?

This Skill helps you design robust MySQL schemas, write efficient queries, optimize performance, and implement strong security and operational practices for MySQL databases.

Core Features & Use Cases

  • Schema Design: Create normalized and performant table structures.
  • Query Optimization: Analyze and improve slow-running SQL queries using EXPLAIN.
  • Security Hardening: Implement best practices for user management, network access, and data encryption.
  • Operational Safety: Guide on backups, replication, and low-downtime migrations.
  • Use Case: Troubleshoot a slow API endpoint by analyzing its MySQL queries, identifying missing indexes, and proposing optimized SQL statements and schema adjustments.

Quick Start

Use the mysql skill to analyze the provided MySQL schema and suggest index improvements for better query performance.

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?▼

To optimize slow MySQL queries, use EXPLAIN to analyze execution plans and identify missing indexes. This Skill guides you through interpreting EXPLAIN output to adjust schemas and rewrite SQL for better performance.

What is the best way to design a normalized and performant MySQL schema?▼

Designing a performant MySQL schema involves creating normalized table structures and implementing a strategic index plan. This Skill provides comprehensive guidance on building robust schemas optimized for your specific query patterns.

How do I secure a MySQL 8.0 database against unauthorized access?▼

Securing a MySQL 8.0 database requires implementing user management best practices, restricting network access, and enabling data encryption. This Skill offers production security hardening techniques to protect your data.

Can I execute low-downtime database migrations and manage transactions in MySQL?▼

Yes, you can execute safe migrations and manage transactions in MySQL. This Skill covers transaction management and operational safety procedures to ensure low-downtime schema changes without data loss.

How do I set up MySQL replication, high availability, and point-in-time backups?▼

Setting up MySQL replication, high availability, and point-in-time recovery (PITR) requires specific operational configurations. This Skill guides you through backup strategies and HA architecture for production environments.

Why is my API endpoint slow and how do I troubleshoot MySQL connection pooling?▼

A slow API endpoint often stems from unoptimized MySQL queries or poor connection pooling. This Skill helps troubleshoot latency by analyzing SQL, proposing indexes, and tuning connection configurations.

Related Skills

Explore More Software Engineering Skills→
mrlynnmrlynn
8

mongodb-nextjs-scaffold

Initialize a Next.js application with MongoDB connection and validation schemas.

Community
Intermediate
JeffallanJeffallan
10.9k

postgres-pro

Guide PostgreSQL EXPLAIN analysis, indexing, replication, and maintenance workflows.

Community
Advanced
forgivesam168forgivesam168
2

copilot-sdk

Embed Copilot's runtime into Node.js, Python, Go, or .NET applications.

Community
Advanced
rnavarychrnavarych
14

role-database:newsql-distributed

Compare 12 NewSQL and distributed SQL databases for consistency and sharding.

Community
Advanced