广告合作
MCP.so
登录

MySQL MCP Server

@Wang4XD

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

Wang4XD

关于 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 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

MySQL MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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

常见问题

1

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.

2

Are queries read-only?

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

3

What data is exposed as resources?

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

4

What prerequisites are needed?

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

5

Does it support write operations?

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

评论

数据库 分类下的更多 MCP 服务器

Local YDB MCP

astandrik

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

4

Elasticsearch MCP Server

elastic

685

NPILayer

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

Expired Domains MCP | Karma.Domains

karma-domains

Connect Karma.Domains to ChatGPT, Claude, Cursor, VS Code, or another MCP client — and find a domain in plain language. The same auctions, expired, backorder, and buy-now data you use in the app, plus saved filters, note

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
广告合作