MCP.so
登录
M

Mysql_mcp_server_ddz

@fanzhenddz

代码仓库

关于 Mysql_mcp_server_ddz

Mysql_mcp_server_ddz

#mysql#mcp#database#ai#server

基本信息

分类

数据库

传输方式

stdio

发布者

fanzhenddz

提交者

Z DD

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mysql": {
      "command": "uvx",
      "args": [
        "mysql-mcp-server-ddz"
      ],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "your_username",
        "MYSQL_PASSWORD": "your_password",
        "MYSQL_DATABASE": "your_database"
      }
    }
  }
}

工具

未检测到工具

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

概览

What is Mysql_mcp_server_ddz?

Mysql_mcp_server_ddz is a Model Context Protocol (MCP) server that wraps MySQL database operations using the FastMCP framework. It is designed for AI applications (e.g., Claude Desktop, MCP-compatible IDEs) to securely access and interact with a MySQL database by exposing actions like listing tables, viewing data, and executing SQL queries.

How to use Mysql_mcp_server_ddz?

Configure the required environment variables (MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE, and optionally MYSQL_PORT) with your database connection details, then run the MCP server. Clients connect via the MCP protocol to invoke its tools.

Key features of Mysql_mcp_server_ddz

  • Wraps MySQL as an MCP tool layer for LLMs
  • Allows listing tables in the database
  • Enables viewing table data directly
  • Supports executing arbitrary SQL statements
  • Secure access through environment-based configuration

Use cases of Mysql_mcp_server_ddz

  • AI assistants querying a MySQL database on demand
  • Automated data analysis via LLM-driven SQL execution
  • Rapid prototyping where language models interact with live data
  • Dynamic report generation from database tables

FAQ from Mysql_mcp_server_ddz

What runtime does Mysql_mcp_server_ddz require?

It is built on the FastMCP framework, which requires Python.

How do I configure the MySQL connection?

All connection parameters are passed as environment variables: MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE.

Where does the data live?

Data remains in the configured MySQL database; the server only connects to it as a client.

What operations are exposed to the LLM?

The server provides tools to list tables, view table data, and execute SQL queries.

Is authentication handled via the MCP protocol?

No, authentication is done through the MySQL credentials supplied in environment variables, not through MCP’s own auth mechanisms.

评论

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

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

MySQL MCP Server

designcomputer

A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases

1.3K

MCP Server for Milvus

zilliztech

Model Context Protocol Servers for Milvus

235

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412