We and selected third parties use cookies or similar technologies for technical purposes and, with your consent, to analyze how the site is used.

You can freely give, refuse or withdraw your consent at any time.

MySQL

MCP server by Ben Borla

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

Runs locally (Runs on your machine: its page has the install command)Runs with npx

Install MySQL

Runs on your machine. Your client starts it with this command:

npx -y @benborla29/mcp-server-mysql

Needs Node.js on your computer. The setup steps below show where the command goes in each client.

Share this server

Opens this page, with the install command and setup steps.

mcp.tc/i/mysql

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.

What you can do

  • 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

Tools

Local servers list their tools once they’re running, and this one doesn’t publish its list in advance. Your client shows them after you add it.

Example 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

Set up

Every client starts MySQL on your machine with the same command. Pick yours; the page remembers your choice.

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

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

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.

Embed

Show MySQL in a README or on your site. Each embed links to this page, uses the server’s own install command, and sets no cookies. How embeds work

The card, the iframe and the JSON are in English. Add ?lang=it, fr, de or es to their address for another language.

README badge

Badge preview, lightBadge preview, 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>

It follows the reader’s light or dark mode. Add ?theme=light or ?theme=dark to fix it, or ?style=compact to show the mark without the word.

Website card

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

The card appears where the tag is. Add data-theme="dark" or data-size="compact" to the tag to change it. The file holds everything it needs, so it makes no other requests and sets no cookies.

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>

Use it on pages that don’t allow scripts. Add ?theme=light or ?theme=dark to the address to fix the colors.

JSON

The listing as data for your own pages and tools: name, tagline, install command, tools and the “Add to” links. Any site can read it (CORS is open).

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

What each field means

AI prompt

Paste this into an AI coding assistant, such as Claude Code or Cursor, and it adds the MySQL card to your site.

Markdown
Add the mcp.tc card for MySQL, an MCP server, to my website. It is one static script: no build step, no package to install, no cookies.

Put this tag where the card should appear. The card renders right before it:

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

To show the card somewhere else, put this placeholder there and load the same script once, for example before `</body>`. Keep the link inside: visitors without JavaScript see it.

```html
<div data-mcptc="mysql"><a href="https://mcp.tc/i/mysql">MySQL on mcp.tc</a></div>
```

Options:
- `data-theme="light"` or `"dark"` on the tag or the placeholder fixes the colors. Without it, the card follows the visitor’s light or dark mode.
- `data-size="compact"` gives a smaller card without the tagline.
- The CSS variable `--mcptc-max-width` on the placeholder or a parent sets the width (default `520px`).
- `?lang=` on the script URL sets the card’s language: `en`, `it`, `fr`, `de` or `es`.

If the site has a Content Security Policy, allow `script-src https://mcp.tc` and `img-src data:` (the icon is inline).

For a README or other Markdown docs, use the badge instead:

```markdown
[![MySQL on mcp.tc](https://mcp.tc/i/mysql/badge.svg)](https://mcp.tc/i/mysql)
```

Reference: https://mcp.tc/embed

Change history

This server runs on your computer, so we follow its npm package: each new version shows up here, with edits by its owner.

Follow MySQL and we’ll email you when something changes.

  1. , Automatic check

    Tracking started: version 2.0.9.

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.

Does mcp.tc track changes to MySQL?

Partly. It runs on your computer, so we follow its npm package: its History tab shows each new version and edits by its owner. Follow the listing to get an email when it changes.

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.

mcp.tc isn’t affiliated with Ben Borla. This page was built from MySQL’s public metadata, last checked on 3 Oct 2026, and an AI model wrote the description, so it can be wrong. Names and marks belong to their owners. Something off? Report this listing.