M

Mysql_mcp_server_ddz

@fanzhenddz

About Mysql_mcp_server_ddz

Mysql_mcp_server_ddz

#mysql #mcp #database #ai #server

Basic information

Category

Databases

Transports

stdio

Publisher

fanzhenddz

Submitted by

Z DD

Config

Add this server to your MCP-compatible client using the configuration below.

{
  "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"
      }
    }
  }
}

Tools

No tools detected

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_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.

Comments

More Databases MCP servers

Database Gateway

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

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

Sail MCP Server for Spark SQL

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

mcp-server-qdrant: A Qdrant MCP server

An official Qdrant Model Context Protocol (MCP) server implementation

ClickHouse MCP Server

Connect ClickHouse to your AI assistants.