MySQL

listing.by

Inspect MySQL schemas and run SQL queries from your assistant, with write operations off unless you enable them.

state.local.long (state.local.title)listing.badge.runs_with

listing.install

listing.local.explain

npx -y @benborla29/mcp-server-mysql

listing.local.needs listing.local.note

act.add_to a11y.new_tabact.add_to a11y.new_tab

listing.share.h

listing.share.p_local

mcp.tc/i/mysql

listing.about

Connects an AI assistant to a MySQL database. It can list tables and column metadata, and run SQL through a single query tool. Queries are read-only by default, and inserts, updates and deletes are enabled separately with environment flags.

The server runs locally over stdio with npx and needs Node.js 20 or newer and MySQL 5.7 or newer. Connection details are passed as environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASS, MYSQL_DB). The README also describes SSH tunnels, multi-database mode, per-schema permissions, PII redaction and SSL/TLS.

listing.can

  • Run SQL queries against a MySQL database
  • Read-only by default
  • Enable inserts, updates or deletes with separate flags
  • List tables and column metadata via a resource
  • Connect to remote databases through an SSH tunnel
  • Query across multiple databases in multi-DB mode
  • Mask sensitive data with PII redaction

listing.tools

listing.notools.local

listing.prompts

  • Show me all tables in my MySQL database and their columns

  • Run a query for the 10 most recent orders

  • How many users signed up last month?

  • Describe the schema of the customers table

listing.setup.h

listing.setup.local

Claude Code

  1. Run this in a terminal, in your project folder:
claude mcp add --transport stdio mysql -- npx -y @benborla29/mcp-server-mysql
  1. Start Claude Code and type /mcp. mysql should show as connected.

Add --scope user to make it available in every project.

Claude Desktop

  1. Open Settings → Developer → Edit Config. It opens claude_desktop_config.json. Add:
claude_desktop_config.json
{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ]
    }
  }
}
  1. Save the file and restart Claude Desktop.

Needs Node.js on your computer. The file lives in ~/Library/Application Support/Claude/ on macOS and %APPDATA%\Claude\ on Windows.

Cursor

Add to Cursor a11y.new_tab

Or add it by hand to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project):

mcp.json
{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ]
    }
  }
}

Needs Node.js on your computer.

VS Code

Install in VS Code a11y.new_tab

Or from a terminal:

code --add-mcp '{"name":"mysql","type":"stdio","command":"npx","args":["-y","@benborla29/mcp-server-mysql"]}'

Or commit it to the repo in .vscode/mcp.json:

.vscode/mcp.json
{
  "servers": {
    "mysql": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ]
    }
  }
}

Needs Node.js on your computer.

Devin Desktop

  1. Add it to ~/.config/devin/mcp_config.json (macOS and Linux) or %APPDATA%\devin\mcp_config.json (Windows):
mcp_config.json
{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ]
    }
  }
}
  1. Refresh the MCP server list in Cascade.

Devin Desktop is the new name for Windsurf.

Codex

codex mcp add mysql -- npx -y @benborla29/mcp-server-mysql

Or edit ~/.codex/config.toml directly:

config.toml
[mcp_servers.mysql]
command = "npx"
args = ["-y", "@benborla29/mcp-server-mysql"]

Needs Node.js on your computer.

Gemini CLI

gemini mcp add mysql npx -- -y @benborla29/mcp-server-mysql

This adds it to the current project. Add -s user to use it everywhere.

Any client

Most clients that start local servers accept this shape:

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@benborla29/mcp-server-mysql"
      ]
    }
  }
}

Zed puts servers under context_servers in its settings, with the same command, args and env fields.

Needs Node.js on your computer.

listing.faq

Can I paste mcp.tc/i/mysql into my MCP client?

No. MySQL runs on your own computer, started by your client, so it has no web address to connect to. The quick link is the page to share; the install command is npx -y @benborla29/mcp-server-mysql.

Does MySQL need an API key?

No. It doesn't declare any keys or environment variables. It runs with your user account's permissions, so check what its tools can reach.

Is MySQL a remote or a local server?

Local. Your client starts it as a process on your computer with npx -y @benborla29/mcp-server-mysql, which needs Node.js.

What can MySQL do?

You can run SQL queries against a MySQL database, Read-only by default and enable inserts, updates or deletes with separate flags.

Which clients can use it?

Any client that starts local servers: Claude Code, Claude Desktop, Cursor, VS Code, Devin Desktop, Codex, Gemini CLI, Zed and others. claude.ai and ChatGPT only connect to remote servers.

Who wrote this page?

mcp.tc's robot read MySQL's public metadata (its package and repository pages), and an AI model drafted the text from it. A person reviews anything the checks can't confirm. The text can still be wrong, so if you spot a mistake, use Report this listing on this page.

listing.em.h

listing.em.lead_local listing.em.how

listing.em.badge

em.prev_lightem.prev_dark
Markdown
[![MySQL on mcp.tc](https://mcp.tc/i/mysql/badge.svg)](https://mcp.tc/i/mysql)
HTML
<a href="https://mcp.tc/i/mysql"><img src="https://mcp.tc/i/mysql/badge.svg" alt="MySQL on mcp.tc" height="20"></a>

listing.em.badge_note

listing.em.widget

HTML
<script src="https://mcp.tc/w/mysql.js" async></script>

listing.em.widget_note

iframe

HTML
<iframe src="https://mcp.tc/embed/mysql" title="MySQL on mcp.tc" width="420" height="200" loading="lazy" allow="clipboard-write" style="border:0;border-radius:8px;max-width:100%"></iframe>

listing.em.iframe_note

JSON

listing.em.json_local

https://mcp.tc/i/mysql.json

listing.em.fields

listing.related

listing.more_in

  • DBHub

    Bytebase

    state.local.label (state.local.title)

    Query and explore Postgres, MySQL, MariaDB, SQL Server, Oracle and SQLite databases through one token-efficient MCP server.

    mcp.tc/i/dbhub

  • Redisvf.sr

    Databases & Backend

    state.local.label (state.local.title)

    Read and write Redis data structures, vector search indexes and streams in natural language.

    mcp.tc/i/redis

  • MCP Toolbox for Databasesvf.sr

    Google

    state.local.label (state.local.title)

    Connect your assistant to Postgres, MySQL, BigQuery, Spanner and other databases to explore schemas and run SQL, or define custom tools.

    mcp.tc/i/mcp-toolbox

  • Qdrant

    Databases & Backend

    state.local.label (state.local.title)

    Store and retrieve semantic memories in a Qdrant vector database collection.

    mcp.tc/i/qdrant

  • Pineconevf.sr

    Databases & Backend

    state.local.label (state.local.title)

    Search Pinecone docs and create, upsert into and query Pinecone indexes with integrated inference from your coding assistant.

    mcp.tc/i/pinecone

  • Neo4jvf.sr

    Databases & Backend

    state.local.label (state.local.title)

    Read the schema and run read or write Cypher queries on a Neo4j graph database.

    mcp.tc/i/neo4j

listing.disclaimer_checked