Mysql MCP Server Ddz

@fanzhenddz

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

fanzhenddz

提交者

Z DD

关于 Mysql MCP Server Ddz

Mysql_mcp_server_ddz

#mysql #mcp #database #ai #server

Mysql MCP Server Ddz 配置

使用下面的配置,将此服务器添加到你的 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"
      }
    }
  }
}

Mysql MCP Server Ddz 工具

工具列表暂未提供

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

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

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

常见问题

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 服务器

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

Database Gateway

centralmind

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

531

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

Sqlite