# MySQL MCP Server

> A Python MCP server for listing, reading and querying MySQL tables through a controlled interface.

## Facts
- **Category:** [MCP Servers](https://agentsearchengine.app/category/mcp-servers)
- **Type:** MCP server
- **Pricing:** Open source
- **GitHub stars:** 1,394
- **Language:** Python
- **License:** MIT
- **Last repo activity:** 1 month ago (Aug 2, 2026)
- **Official site:** https://designcomputer.com
- **Source code:** https://github.com/designcomputer/mysql_mcp_server
- **Listing on Agent Search Engine:** https://agentsearchengine.app/agents/mysql-mcp-server
- **Data verified:** September 2026

## Best for
Querying MySQL from an MCP client in a Python environment.

## About MySQL MCP Server
This community MySQL MCP server lists tables as resources, reads table contents and executes SQL with error handling. It supports a multi-database mode, SSH tunnelling and both stdio and streamable HTTP transports, with the HTTP mode suggested for remote or self-hosted deployments.

## Connect to an MCP client
Launch command from the project's README: `MYSQL_HOST=localhost MYSQL_USER=<user> MYSQL_PASSWORD=<password> MYSQL_DATABASE=<database> uvx mysql_mcp_server`

### Claude Code (Run in your terminal)

```shell
claude mcp add mysql-mcp-server -e MYSQL_HOST=localhost -e 'MYSQL_USER=<user>' -e 'MYSQL_PASSWORD=<password>' -e 'MYSQL_DATABASE=<database>' -- uvx mysql_mcp_server
```

### Cursor (~/.cursor/mcp.json or .cursor/mcp.json)

```json
{
  "mcpServers": {
    "mysql-mcp-server": {
      "command": "uvx",
      "args": ["mysql_mcp_server"],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_USER": "<user>",
        "MYSQL_PASSWORD": "<password>",
        "MYSQL_DATABASE": "<database>"
      }
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "mysql-mcp-server": {
      "type": "stdio",
      "command": "uvx",
      "args": ["mysql_mcp_server"],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_USER": "<user>",
        "MYSQL_PASSWORD": "<password>",
        "MYSQL_DATABASE": "<database>"
      }
    }
  }
}
```

### Claude Desktop (claude_desktop_config.json)

```json
{
  "mcpServers": {
    "mysql-mcp-server": {
      "command": "uvx",
      "args": ["mysql_mcp_server"],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_USER": "<user>",
        "MYSQL_PASSWORD": "<password>",
        "MYSQL_DATABASE": "<database>"
      }
    }
  }
}
```

### Codex (~/.codex/config.toml)

```toml
[mcp_servers.mysql-mcp-server]
command = "uvx"
args = ["mysql_mcp_server"]
env = { MYSQL_HOST = "localhost", MYSQL_USER = "<user>", MYSQL_PASSWORD = "<password>", MYSQL_DATABASE = "<database>" }
```

## Alternatives
MySQL MCP Server sits in mcp servers. Related tools indexed here:
- [MCP Reference Servers](https://agentsearchengine.app/agents/mcp-reference-servers) — The MCP steering group's reference servers: Everything, Fetch, Filesystem, Git, Memory, Sequential Thinking and Time. · Open source · MCP server · 91k★ · TypeScript · MIT AND Apache-2.0 · active today
- [context7](https://agentsearchengine.app/agents/context7) — Context7 Platform -- Up-to-date code documentation for LLMs and AI code editors · Open source · MCP server · 62k★ · TypeScript · MIT · active today
- [chrome-devtools-mcp](https://agentsearchengine.app/agents/chrome-devtools-mcp) — Chrome DevTools for coding agents · Open source · MCP server · 53k★ · TypeScript · Apache-2.0 · active today
- [Playwright MCP](https://agentsearchengine.app/agents/playwright-mcp) — Expose Playwright browser tools to MCP clients using accessibility snapshots. · Open source · MCP server · 37k★ · TypeScript · Apache-2.0 · active 4 days ago
- [github-mcp-server](https://agentsearchengine.app/agents/github-mcp-server) — GitHub's official MCP Server · Open source · MCP server · 33k★ · Go · MIT · active today
- [serena](https://agentsearchengine.app/agents/serena) — A powerful MCP toolkit for coding, providing semantic retrieval and editing capabilities - the IDE for your agent · Open source · SDK / library · 30k★ · Python · MIT · active today
- [MCP for Blender (blender-mcp)](https://agentsearchengine.app/agents/blender-mcp) — Connect Blender to Claude or any LLM client for prompt-driven 3D modelling and scene editing. · Open source · MCP server · 29k★ · Python · MIT · active 2 days ago
- [fastmcp](https://agentsearchengine.app/agents/fastmcp) — The fast, Pythonic way to build MCP servers and clients. · Open source · SDK / library · 28k★ · Python · Apache-2.0 · active today

---
Source: [Agent Search Engine](https://agentsearchengine.app) — an independent, hand-curated index of AI agents, MCP servers, and frameworks. Rankings are never sold; sponsored placements are labeled and never numbered. Full directory: https://agentsearchengine.app/llms-full.txt