How do I use mysql-mcp?

1. Click on "Deploy Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@mysql-mcp list all tables in the current database" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

mysql-mcp

by MaxLMGC

Overview Schema Source Related Servers Discussions Admin

JavaScript

Remote

@maxlmgc/mysql-mcp

MySQL MCP Server — a secure, read-only-by-default MySQL integration for AI clients via the Model Context Protocol.

中文文档

Tools

Tool	Description	Read-only mode
`sql_query`	Execute SELECT / SHOW / DESCRIBE / EXPLAIN queries	Allowed
`sql_list_tables`	List all tables in the current database	Allowed
`sql_table_schema`	Get column structure and comments of a table	Allowed
`sql_execute`	Execute INSERT / UPDATE / DELETE (auto-rolled back)	Blocked

Related MCP server: MCP MySQL Server

Environment Variables

Database Connection (required)

Variable	Description	Default
`MYSQL_HOST`	Database host	-
`MYSQL_PORT`	Database port	`3306`
`MYSQL_USER`	Database user	-
`MYSQL_PASS`	Database password	(empty)
`MYSQL_DB`	Database name	-

Read-only Mode

Variable	Description	Default
`MYSQL_READONLY`	Set to `false` to disable read-only mode	`true` (enabled)
`MYSQL_READONLY_PREFIXES`	Custom SQL keyword whitelist (comma-separated, overrides defaults)	`SELECT,SHOW,DESCRIBE,DESC,EXPLAIN,WITH`

Connection Pool

Variable	Description	Default
`MYSQL_CONNECTION_LIMIT`	Max connections in pool	`10`
`MYSQL_MULTIPLE_STATEMENTS`	Set to `false` to disable multi-statement execution	`true`

Installation

npm install @maxlmgc/mysql-mcp

Usage

MCP Client Configuration

Add to your MCP client configuration:

{
  "mcpServers": {
    "mysql-mcp": {
      "command": "npx",
      "args": ["-y", "@maxlmgc/mysql-mcp"],
      "env": {
        "MYSQL_HOST": "localhost",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "your_password",
        "MYSQL_DB": "your_database"
      }
    }
  }
}

Read-only Mode (default)

By default only query operations are allowed; sql_execute is not exposed.

Disable Read-only Mode

"env": {
  "MYSQL_HOST": "localhost",
  "MYSQL_USER": "root",
  "MYSQL_DB": "your_database",
  "MYSQL_READONLY": "false"
}

Custom Whitelist

Only allow SELECT and SHOW:

"env": {
  "MYSQL_HOST": "localhost",
  "MYSQL_USER": "root",
  "MYSQL_DB": "your_database",
  "MYSQL_READONLY_PREFIXES": "SELECT,SHOW"
}

Security

Read-only by default: sql_execute is not registered in read-only mode
SQL injection prevention: Table names validated with regex; parameterized queries used
Startup validation: Missing required env vars cause immediate failure
Transaction rollback: sql_execute runs in a transaction that is always rolled back
Dual-layer protection: SQL validation at both tool layer and connection pool layer

License

MIT

This server cannot be deployed

Shareable, User-Owned Context BackendPeople, applications, and agents read, write, and coordinate together in one context lake. Reach it over MCP, a CLI, a Python SDK, or REST.fulcradynamics.comAd

Maintenance

ActivityInactive

ResponsivenessNo issues

Resources

Need Help?

Related Servers

Related MCP Connectors

SaturnSQL
com.saturnsql
Query Postgres, MySQL, SQL Server, Oracle, BigQuery, ClickHouse and Redshift from your AI client.
Databases
81
dataOAuth
co.thinair
PostgreSQL, MySQL, and SQL Server in one session. 26 read-only MCP tools for AI agents.
Databases Developer Tools
2
QueryBearOAuth
io.github.spencerpauly
Safe, read-only Postgres and MySQL access for AI agents. Audit log + column-level controls.
Databases RAG Systems
2
nuzur-mcp-serverOAuth
io.github.mklfarha
AI agents propose database changes as reviewable requests — no direct write access.
Databases Developer Tools Autonomous Agents
2

Related MCP Servers

MySQL MCP Server
Databases Security Developer Tools
amornpan
F
license
Not graded
quality
D
maintenance
Enables secure interaction with MySQL databases, allowing AI assistants to list tables, read data, and execute SQL queries through a controlled interface.
Updated 2 years ago (2025-03-07 07:21 UTC)
-
MCP MySQL Server
Databases Developer Tools
Iceeeeec
A
license
Not graded
quality
D
maintenance
Enables AI assistants to safely query MySQL databases with read-only access by default, supporting table listing, structure inspection, and SQL queries with optional write operation control.
Updated a year ago (2025-11-06 03:02 UTC)
11 npm
MIT
MySQL MCP Server
Databases Developer Tools
za2keep
A
license
Not graded
quality
Not graded
maintenance
Enables AI assistants to securely interact with MySQL databases through tools for query execution, schema inspection, and transaction management. It features built-in safety controls like row limits and query validation to ensure safe and standardized database access.
Updated 9 months ago (2026-01-28 03:58 UTC)
730 npm
-
easy-mysql-mcp
Databases Developer Tools
chenkumi
A
license
A
quality
C
maintenance
Enables AI assistants to inspect and query a MySQL database through safe, structured tools, including schema discovery and read-only queries.
Updated a month ago (2026-09-08 17:46 UTC)
9
39 npm
MIT