MCPInstall

mysql

MySQL database administration and development

Installs
506
Last 24h
—
Trending rank
—
Security
Not audited

Install

Works with every agent the skills CLI supports.

npx skills add https://github.com/pluginagentmarketplace/custom-plugin-sql --skill mysql
  1. 01

    Install

    Run the command in your project. The CLI asks which agents to install for.

  2. 02

    Describe the task

    Ask your agent for something this skill covers. It loads mysql automatically when relevant.

  3. 03

    Review the result

    The agent follows the SKILL.md steps, scripts and references bundled with the skill.

SKILL.md

The instructions your agent reads when the skill is triggered.

MySQL Skill

Overview

Master MySQL database administration, optimization, and development for production environments.

Topics Covered

MySQL Basics

  • Installation and configuration
  • User management
  • Database creation
  • Storage engines (InnoDB, MyISAM)
  • Character sets

Query Development

  • SELECT statements
  • JOINs and subqueries
  • INSERT, UPDATE, DELETE
  • Stored procedures
  • Triggers and events

Performance

  • EXPLAIN analysis
  • Index optimization
  • Query cache (8.0+ changes)
  • Slow query log
  • Performance Schema

Administration

  • Backup with mysqldump
  • Binary log management
  • Replication setup
  • User privileges
  • Configuration tuning

High Availability

  • MySQL replication
  • Group replication
  • MySQL Router
  • ProxySQL
  • Failover strategies

Prerequisites

  • SQL fundamentals
  • Linux basics
  • Networking concepts

Learning Outcomes

  • Administer MySQL servers
  • Optimize queries
  • Set up replication
  • Manage backups

FAQ

What does the mysql skill do?

MySQL database administration and development

How do I install mysql?

Run npx skills add https://github.com/pluginagentmarketplace/custom-plugin-sql --skill mysql in your project. The skills CLI detects the agents you use and copies the skill into the right folder. For Claude Code you can also place the skill folder at ~/.claude/skills/mysql/ (personal) or .claude/skills/mysql/ (project).

Which AI agents can use mysql?

Any agent that supports the open Agent Skills format (a folder with a SKILL.md file), including Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, Windsurf, Cline, OpenCode and more.

Is mysql safe to install?

No partner security audit is available yet. Skills can run commands and scripts, so read the SKILL.md and any bundled files before installing.

Who maintains mysql?

It is published by pluginagentmarketplace in pluginagentmarketplace/custom-plugin-sql. It has 506 recorded installs.

More from pluginagentmarketplace/custom-plugin-sql

View all →

data-analysis-sql

pluginagentmarketplace/custom-plugin-sql

SQL for data analysis with exploratory analysis, advanced aggregations, statistical functions, outlier detection, and business insights. 50+ real-world analytics queries.

Data & Databases80 installs

data-warehouse

pluginagentmarketplace/custom-plugin-sql

Data warehouse design mastery with star schema, dimensional modeling, fact/dimension tables, slowly changing dimensions, and enterprise best practices. Complete schema examples included.

Data & Databases76 installs

redis

pluginagentmarketplace/custom-plugin-sql

Open the skill to read its SKILL.md instructions.

Data & Databases55 installs

postgresql

pluginagentmarketplace/custom-plugin-sql

PostgreSQL administration and setup including installation, configuration, backup/recovery, replication, and high-availability. Learn production PostgreSQL operations.

Data & Databases52 installs

bi-fundamentals

pluginagentmarketplace/custom-plugin-sql

Open the skill to read its SKILL.md instructions.

Data & Databases46 installs

Popular data & databases skills

View category →

Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill BEFORE writing or changing anything that lives in a Postgres database: creating or altering tables and columns (including choosing column types), schema design, migrations and declarative schema files, RLS policies and the tests that verify them, indexes, triggers, database functions, queues and scheduled jobs (pgcron, pgmq), vector/semantic search (pgvector), and restoring dumps (pgrestore) or importing data. Also load it when diagnosing slow queries, high CPU, timeouts, EXPLAIN plans, connection exhaustion, locking, bloat, or rows visible to the wrong user or tenant. This is not just a performance guide — schema, migration, security, and SQL authoring tasks need these rules too, even for a one-column change or a single query.

OfficialData & Databases462.2K installs

prisma-client-api

prisma/skills

Prisma Client API reference covering model queries, filters, operators, and client methods. Use when writing database queries, using CRUD operations, filtering data, or configuring Prisma Client. Triggers on "prisma query", "findMany", "create", "update", "delete", "$transaction".

OfficialData & Databases393.5K installs

Deprecated compatibility name for prisma-orm-setup. Use only when a user or existing integration explicitly invokes prisma-database-setup; otherwise select prisma-orm-setup.

OfficialData & Databases392.3K installs

prisma-cli

prisma/skills

Prisma ORM 7 CLI reference for existing Prisma 7 applications or explicitly selected Prisma 7 workflows. Covers prisma init, generate, migrate, db, dev, studio, and mcp. For setup, connection repair, or Prisma 8, use prisma-orm-setup; not the Prisma Platform CLI.

OfficialData & Databases390.8K installs

prisma-postgres

prisma/skills

Deprecated compatibility name for prisma-postgres-setup. Use only when a user or existing integration explicitly invokes prisma-postgres; otherwise select prisma-postgres-setup.

OfficialData & Databases384.4K installs

Required reference for Prisma ORM 7 SQL driver adapter work. Use when implementing or modifying adapters, adding database drivers, or touching SqlDriverAdapter, Transaction, savepoint, result mapping, or DriverAdapterError behavior. Covers current transaction lifecycle, optional savepoint hooks, original database-error preservation, and verification.

OfficialData & Databases378.9K installs