MySQL MCP Server by designcomputer: Query MySQL from Claude and Cursor
Lets Claude, Cursor and other assistants explore and query a MySQL database you point them at.
This server connects your assistant to a MySQL database with the user and password you give it. The assistant can look at table structure, sample rows and run SQL. It also offers two guided prompts, explore_database and analyze_table, and lists databases and tables as resources.
It runs on your computer and uses uv. It does not limit what SQL it runs, so the safety comes from the MySQL user you give it. This is a separate project from Ben Borla's MySQL MCP server.
Good for
- Developers who want an assistant to explore a MySQL schema
- Analysts asking questions of MySQL data in plain language
- Teams with a spare read-only MySQL user for AI access
Works in
12 should work
Tap an app to see how to set it up and any known problems.
Supports local MCP servers.
Supports local MCP servers.
Supports local MCP servers.
Supports local MCP servers.
Supports local MCP servers.
Supports local MCP servers.
Supports local MCP servers.
Supports local MCP servers.
Supports local MCP servers.
Supports local MCP servers.
Supports local MCP servers.
Supports local MCP servers.
Client does not support this transport.
Client does not support this transport.
Install MySQL MCP Server (designcomputer)
Claude Code
- 1
Copy this prompt.
Add the MySQL MCP Server (designcomputer) server to Claude Code. Run this command: claude mcp add mysql-designcomputer -e MYSQL_HOST=localhost -e MYSQL_PORT=3306 -e MYSQL_USER=your_username -e MYSQL_PASSWORD=your_password -e MYSQL_DATABASE=your_database -- uvx --from mysql-mcp-server mysql_mcp_server Ask me for MYSQL_USER, MYSQL_PASSWORD and only put the values in that config, nowhere else. Then check that it loaded and tell me if I need to sign in or restart.
- 2
Paste it into Claude Code. It shows the change and asks before running it.
Requires uv (Python), A MySQL user.
Read-only mode: No read-only switch in the server. Connect with a MySQL user that only has SELECT rights.
The package is mysql-mcp-server but its command is mysql_mcp_server with underscores, so the config names the package with --from. Put the MySQL values in the env block, because a .env file is not found when the client starts the server. Our advice: for read-only use, give the MySQL user SELECT rights only.
Built from the package data we hold. Not yet tested by us.
Tools
Runs one SQL statement
Runs a single SQL statement on your MySQL server, such as SELECT, SHOW or DESCRIBE. It also runs INSERT, UPDATE and DELETE, and the code applies no filter, so other statements go through too.
Try: “How many orders were placed last week?”
Delete ·
execute_sqlShows table structure
Returns column names, types, nullability, defaults and comments for one table, or for every table in the configured database when no table is named.
Try: “Show me the columns of the customers table.”
Read ·
get_schema_infoShows a few rows from a table
Fetches a small sample of rows from a table, 5 by default and at most 20, so the assistant can see the data format before writing queries.
Try: “Show me a sample of the orders table.”
Read ·
get_table_sample
Read from the source code
Permissions
high risk · 3 things to watch · 2 advisories
High risk
It can read, change and delete any data the MySQL user can reach, because execute_sql runs whatever SQL the assistant writes. Use a dedicated MySQL user with only SELECT rights.
What it can do
- Read your data
- Create and change things
- Delete things
- Read-only mode
Watch out for
execute_sql can change and delete data
It runs any single statement, including INSERT, UPDATE and DELETE, and the code applies no read-only check. The README advises a dedicated user with minimal permissions. Our advice: for read-only use, give that user SELECT rights only. github.com
The SSE mode has no sign-in and listens on all interfaces
If you set MCP_TRANSPORT=sse, it binds to 0.0.0.0 by default and takes connections without credentials. Set MCP_SSE_HOST=127.0.0.1 and put an authenticating proxy in front, as the README advises. github.com
Your database password sits in the MCP config
The credentials go in the env block of your client config. Use a dedicated user and keep the file private. github.com
Security advisories
2 known advisories, all fixed in a newer version.
- MySQL MCP Server: Missing Origin/Host Validation in SSE Transport Enables Unauthenticated SQL Execution (DNS Rebinding / Direct Exposure)critical · Fixed in 0.4.2 · GHSA-rqfv-2mw9-78g2
- MySQL MCP Server is Vulnerable to SQL Injection Through its mysql URI Handlerlow · Fixed in 0.3.0 · GHSA-mvq4-39wx-6h5g
Technical details
| Talks to | Connects to the MySQL host you set (default localhost), optionally through an SSH tunnel |
|---|---|
| Sign-in and keys | MySQL user and password go in the MCP config env values. MYSQL_USER and MYSQL_PASSWORD are required. |
Questions
Is the designcomputer MySQL MCP server official?
No. It is a community project by Dana K. Williams of designcomputer, not made by the MySQL vendor. It is a different project from Ben Borla's MySQL MCP server.
What does it need to connect?
A MySQL user name and password. The host defaults to localhost and the port to 3306, and the database name is optional.
Can I make it read-only?
Not in the server. The README advises a dedicated user with minimal permissions. Our advice: for read-only use, give it a MySQL user that only has SELECT rights.
Can it query more than one database?
Yes. Leave the database name unset for multi-database mode and use names like mydb.mytable. It runs one statement at a time, so USE is not supported.
Does it work with a remote or SSH-only database?
Yes. It supports SSL settings and an SSH tunnel through your jump host, set with environment variables listed in the README.
Why do I see "Missing required database configuration"?
Claude Code and Claude Desktop start the server from their own folder, so a .env file is not found. Put the MySQL values in the env block of the MCP config instead.
Which clients can use it?
Any client that runs local MCP servers. The README shows Claude Desktop, VS Code and Claude Code.
Information
updated Nov 2, 2026
- Publisher
- Community
- Package
mysql-mcp-server- Registry
- PyPI
- Transport
- stdio, SSE
- Auth
- token in env
- Version
- 0.4.5
- License
- MIT
- Last commit
- Oct 28, 2026
- Open issues
- 3
Sources
Docs, issue trackers and discussions this page is built from. Issues, quotes and findings above link to their own source.
Show all 4Hide
- README.md · github.com
- server.py · github.com
- pyproject.toml · github.com
- pypi.org · pypi.org