InnerVault

MySQL MCP

Stale Official MCP Registry, io.github.gistrec

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_USER required · MySQL user. Use one with the least privileges the task needs, never root.
  • MYSQL_PASS secret · Password for that user. Treat it as a secret; MYSQL_PASS_FILE reads it from a file instead.
  • MYSQL_DB required · 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

  1. mysql_mcp_server

    MCP servers

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

    Stale GitHub, designcomputer 1,398 ★MITUpdated 3 months ago

    git clone https://github.com/designcomputer/mysql_mcp_server.git
  2. mysql_mcp_server_pro

    MCP servers

    Model Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼!更加好用!不仅止于mysql的增删改查功能; 还包含了数据库异常分析能力;且便于开发者们进行个性化的工具扩展

    Stale GitHub, wenb1n-dev 249 ★MITUpdated 14 months ago

    git clone https://github.com/wenb1n-dev/mysql_mcp_server_pro.git
  3. dbhub

    MCP servers

    Token conscious database MCP server for Postgres, MySQL, SQL Server, Oracle, MariaDB, SQLite.

    Indexed GitHub, bytebase 3,858 ★MITUpdated today

    git clone https://github.com/bytebase/dbhub.git
  4. prest

    MCP servers

    Instant 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

    Indexed GitHub, prest 4,635 ★MITUpdated yesterday

    git clone https://github.com/prest/prest.git
  5. phpMyFAQ

    MCP servers

    phpMyFAQ - Open Source FAQ web application for PHP 8.4+ and MySQL, PostgreSQL and other databases

    Stale GitHub, thorsten 621 ★MPL-2.0Updated 32 days ago

    git clone https://github.com/thorsten/phpMyFAQ.git
  6. whodb

    MCP servers

    Where data access meets operational intelligence

    Indexed GitHub, clidey 5,058 ★Apache-2.0Updated today

    git clone https://github.com/clidey/whodb.git