MySQL MCP
MCP server for one MySQL database: schema, read-only queries and guarded writes.
Open the source (opens github.com) https://github.com/gistrec/mcp-mysql-client
Before you use it
- Runs on your computer with your permissions. Read what it can do before connecting it to an agent.
- Needs credentials: MYSQL_PASS. Use a key with the least access you can.
What it is
MCP servers from io.github.gistrec.
The problem it solves and who it suits haven't been reviewed by InnerVault. The description above is the source's own.
How to get it
npm package (stdio)
mcp-mysql-client@1.1.1
From the server's entry in the official MCP Registry
Settings it asks for
MYSQL_HOST· Database host.MYSQL_PORT· Database port.MYSQL_USERrequired · MySQL user. Use one with the least privileges the task needs, never root.MYSQL_PASSsecret · Password for that user. Treat it as a secret; MYSQL_PASS_FILE reads it from a file instead.MYSQL_DBrequired · The one database this server is bound to. No tool can leave it.MYSQL_SSL· Require a TLS connection to the server.MYSQL_SSL_CA· Path to the CA bundle verifying the server certificate; implies MYSQL_SSL.ALLOW_INSERT_OPERATION· Allow INSERT statements through the execute tool.ALLOW_UPDATE_OPERATION· Allow UPDATE statements through the execute tool.ALLOW_DELETE_OPERATION· Allow DELETE statements through the execute tool.MYSQL_MAX_ROWS· Row cap for one read; the result is marked truncated when it is hit.MYSQL_TIMEOUT_MS· Statement timeout in milliseconds; the connection is dropped on expiry.
Related
-
mysql_mcp_server
MCP serversA Model Context Protocol (MCP) server that enables secure interaction with MySQL databases
git clone https://github.com/designcomputer/mysql_mcp_server.git -
mysql_mcp_server_pro
MCP serversModel Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼!更加好用!不仅止于mysql的增删改查功能; 还包含了数据库异常分析能力;且便于开发者们进行个性化的工具扩展
git clone https://github.com/wenb1n-dev/mysql_mcp_server_pro.git -
dbhub
MCP serversToken conscious database MCP server for Postgres, MySQL, SQL Server, Oracle, MariaDB, SQLite.
git clone https://github.com/bytebase/dbhub.git -
prest
MCP serversInstant REST and MCP APIs for PostgreSQL and MySQL, on existing or new databases. CRUD, custom SQL routes, auth and ACL without writing a backend. Low-code, ⚡ realtime, high-performance. Native MySQL support since v2.5
git clone https://github.com/prest/prest.git -
phpMyFAQ
MCP serversphpMyFAQ - Open Source FAQ web application for PHP 8.4+ and MySQL, PostgreSQL and other databases
git clone https://github.com/thorsten/phpMyFAQ.git -
whodb
MCP serversWhere data access meets operational intelligence
git clone https://github.com/clidey/whodb.git