Developer Tools

MySQL MCP Server

Use Studio chat to drive this server — credentials stay in your workspace.

MySQL MCP server for powerful open-source relational database operations. Execute SQL queries, manage relational data with high throughput, support web applications and data warehousing, and integrate with popular frameworks for scalable database operations. Connect to local databases with: pip install mcpbundles

10 tools
Agent guide included
API Key
Start Chatting

Opens MCPBundles Studio with this server selected. After sign-in, chat and run tools from the same thread.

Browse all tools

AI Skill
SKILL.md

Domain knowledge for MySQL — workflow patterns, data models, and gotchas for your AI agent.

MySQL

MySQL access uses a standard connection URI or discrete host/port/database credentials—mirror the PostgreSQL mental model. Parameterized reads return row payloads plus stable handles for point lookups; mutating work goes through explicit SQL execution paths.

Data Model

  • Tables — discover names before writing migrations or ad hoc queries.
  • Parameterized reads — bound SELECT output includes resource handles when the platform wraps rows.
  • Row handles — typically mysql:row:db.table:pk:value; reuse only from fresh read results.
  • Ad hoc execution — DDL/DML and multi-statement batches when the integration exposes an execute surface.
  • Connectivitymysql:// URIs; loopback hosts need the desktop proxy tunnel.

Gotchas

  • Read vs write: Keep exploratory reads on guarded paths; wrap destructive statements in transactions.
  • TLS: Managed clouds expect SSL modes in the DSN.
  • Identifiers: Thread primary keys from listing responses into follow-up reads—stale keys error out.

Tools in this Server (10)

Execute

Execute SQL statements on MySQL database. Supports all SQL operations including SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER. Use with caution ...

Fetch

Fetch a specific MySQL record by ID. Use format 'mysql:row:table:id' (e.g., 'mysql:row:users:123').

Get Ai Description

Get a token-efficient schema description optimized for AI models to generate SQL queries. Includes table names, column names, types, and relationships...

Get Table Stats

Get detailed statistics and metadata for a MySQL table including row count, size, indexes, and foreign keys.

Inspect Database

Get a full overview of the MySQL database schema including tables, columns, indexes, and relationships.

List Rows

List rows from a MySQL table with pagination, column selection, filtering, and sorting.

List Tables

List all tables in the MySQL database with pagination and optional name pattern filtering.

Profile Column

Profile a MySQL column to get statistics including min/max, distinct count, null count, and top values.

Sample Data

Get sample data from a MySQL table for preview and exploration.

Search

Search MySQL database using SQL queries or structured syntax. Returns ranked results with IDs and titles. Supports SELECT statements and table browsin...

Frequently Asked Questions

What is the MySQL MCP server?

MySQL MCP server for powerful open-source relational database operations. Execute SQL queries, manage relational data with high throughput, support web applications and data warehousing, and integrate with popular frameworks for scalable database operations. Connect to local databases with: pip install mcpbundles It provides 10 tools that AI agents can use through the Model Context Protocol (MCP).

How do I connect MySQL to my AI agent?

Add the MCPBundles server URL to your MCP client configuration (Claude Desktop, Cursor, VS Code, etc.). The URL format is: https://mcp.mcpbundles.com/bundle/mysql. Authentication is handled automatically.

How many tools does MySQL provide?

MySQL provides 10 tools that can be called by AI agents, along with a SKILL.md that gives your AI agent domain knowledge about when and how to use them.

What authentication does MySQL require?

MySQL uses API Key. MySQL requires credentials. Connect via MCPBundles and authentication is handled automatically.

Setup Instructions

Connect MySQL to any MCP client in minutes

https://mcp.mcpbundles.com/bundle/mysql

What is MCP?

Model Context Protocol lets AI tools call external capabilities securely through a single URL. This bundle groups tools behind an MCP endpoint that many clients can use.

Use this bundle in 3 steps

  1. Copy the MCP URL above
  2. Open your AI tool and add a new MCP/connector
  3. Paste the URL and follow any auth prompts

Claude Desktop Users

Skip the manual setup! Use the .mcpb file format for one-click installation. Check the Claude Desktop tab for setup instructions.

Pick your tool tab for exact steps

Select ChatGPT, Cursor, Claude Code, or another tab for copy-paste config.

Ready to chat with MySQL?

Same flow: Studio opens on this server after sign-in. Keep chatting to call tools from the conversation.

MySQL MCP Server & Skill — 10 Tools