MySQL MCP Server

@Wang4XD

Basic information

About MySQL MCP Server

An MCP server that can connect to MySQL databases, which exposes the table structure as a resource, provides SQL query tools, and includes tips for common data analysis tasks.

MySQL MCP Server config

No standard config provided

This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.

Repository

MySQL MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is MySQL-MCP-Server?

MySQL-MCP-Server is a Model Context Protocol (MCP) server that connects to MySQL databases. It exposes the table structure as resources, provides read-only SQL query tools, and includes predefined prompts for common data analysis tasks. It is designed for LLMs to access and interact with database schema and data.

How to use MySQL-MCP-Server?

Configure the server to connect to a MySQL database, then run it as an MCP server. Interact with it via any MCP client to list table schemas, execute read-only SQL queries, and use the included analysis tips.

Key features of MySQL-MCP-Server

Connects to MySQL databases via MCP protocol
Exposes table structure as MCP resources
Provides read-only SQL query tool
Includes predefined prompts for data analysis
Allows LLMs to explore database schema

Use cases of MySQL-MCP-Server

LLMs querying database schema to understand table relationships
Automating data analysis with read-only SQL queries
Enabling AI assistants to inspect database structure
Supporting data exploration tasks in MCP-compatible clients

Frequently asked questions

What is the purpose of MySQL-MCP-Server?

It allows LLMs to access MySQL database structure and perform read-only SQL queries through the MCP protocol.

Are queries read-only?

Yes, only read-only SQL queries are permitted. Write operations are not supported.

What data is exposed as resources?

The table structure (schema) of the connected MySQL database is exposed as MCP resources.

What prerequisites are needed?

A MySQL database instance and an MCP client that can connect to the server.

Does it support write operations?

No, it is limited to read-only SQL queries and schema exploration.

Comments

More Databases MCP servers

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

NPILayer

Healthcare provider data for AI assistants, from the official CMS NPPES dataset (updated weekly). Look up any NPI (active or deactivated), search providers and organizations by name, city, state, ZIP, taxonomy code or pl

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s