Advertise
MCP.so
Sign In

MySQL MCP Server

@designcomputer

RepositoryHomepage

Basic information

Category

Databases

License

MIT

Transports

stdio

Author

designcomputer

About MySQL MCP Server

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

#mysql#database#mcp-server

MySQL MCP Server config

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

{
  "mcpServers": {
    "mysql_mcp_server": {
      "command": "npx",
      "args": [
        "-y",
        "@smithery/cli",
        "install",
        "designcomputer/mysql-mcp-server",
        "--client",
        "claude"
      ]
    }
  }
}

MySQL MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list by running this server in a temporary sandbox using the button above.

Overview

What is MySQL MCP Server?

MySQL MCP Server is a Model Context Protocol implementation that enables secure interaction between AI applications (hosts/clients) and MySQL databases. It facilitates structured database exploration and analysis through a controlled interface.

How to use MySQL MCP Server?

Install via pip install mysql-mcp-server, then configure environment variables (e.g. MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD) and integrate with hosts like Claude Desktop or VS Code by adding the server to their MCP configuration. Supports both STDIO and SSE transport modes. For remote deployments, use SSE with a reverse proxy for authentication.

Key features of MySQL MCP Server

  • List MySQL tables as resources
  • Read table contents and execute SQL queries
  • Multi-database mode when MYSQL_DATABASE is omitted
  • SSE/HTTP transport support with MCP_TRANSPORT=sse
  • SSH tunneling for secure connections
  • Comprehensive schema information via get_schema_info
  • Table data sampling via get_table_sample
  • Secure database access through environment variables

Use cases of MySQL MCP Server

  • AI agents exploring database structure before analysis
  • Running safe, single‑statement SQL queries through a chat interface
  • Sampling data from tables to understand content without large fetches
  • Cross‑database queries using database.table notation
  • Self‑hosted deployments with SSH tunneling or SSL/TLS encryption

Frequently asked questions

1

What transport modes does MySQL MCP Server support?

It supports both STDIO (standard input/output) and Streamable HTTP (SSE) transport modes. SSE is recommended for remote or self‑hosted deployments.

2

How do I enable multi‑database mode?

Omit the `MYSQL_DATABASE` environment variable. The server then returns all user databases for resource listing and allows fully qualified names like `mydb.mytable` in queries.

3

Does SSE transport include built‑in authentication?

No. SSE binds to `0.0.0.0` by default and accepts connections without credentials. If exposed beyond localhost, place it behind a reverse proxy (e.g., nginx with HTTP Basic Auth) and set `MCP_SSE_HOST=127.0.0.1`.

4

What are the limitations on SQL queries?

Only single‑statement queries are supported. Multi‑statement queries (e.g., `USE db; SELECT …`) are not allowed. DML operations (`INSERT`, `UPDATE`, `DELETE`) are marked with a destructive hint.

5

How are table/column identifiers validated?

Identifiers in `get_schema_info` and `get_table_sample` are restricted to alphanumeric characters, underscores, and `$`. A single dot is allowed as a separator between database and table names. Other special characters are rejected to prevent SQL injection.

Comments

More Databases MCP servers

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

1

Lawstronaut

Lawstronaut-FZCO

Access millions of official legal and regulatory source documents from 155+ jurisdictions via MCP. Lawstronaut supports AI agents with structured legal research, legal data, laws, regulations, cases, guidance, official s

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617
Advertise