MySQL MCP Server

@tqvthu-works

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

tqvthu-works

关于 MySQL MCP Server

暂无概览

MySQL MCP Server 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

MySQL MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

What is MySQL MCP Server?

A Model Context Protocol (MCP) server for interacting with MySQL databases directly within Cursor IDE. It allows users to execute SQL queries (read‑only by default), inspect database schemas, and optionally enable write operations through configuration.

How to use MySQL MCP Server?

Install dependencies with npm install, then create a .env file with your MySQL connection details and write‑permission flags. Add the server configuration to your project’s .cursor/mcp.json, specifying npx ts-node as the command and the required environment variables. The server can then be invoked from Cursor IDE.

Key features of MySQL MCP Server

Execute SQL queries (read-only by default).
Inspect database schemas.
Configurable write permissions for INSERT, UPDATE, DELETE.

Use cases of MySQL MCP Server

Query MySQL databases directly from Cursor IDE during development.
Safely inspect table structures and relationships.
Enable controlled write operations (e.g., INSERT) when explicitly allowed.
Run ad‑hoc SELECT queries without leaving the editor.
Manage database interactions without switching to a separate SQL client.

常见问题

Is the server read‑only by default?

Yes. Write operations (INSERT, UPDATE, DELETE) are disabled by default. They can be enabled by setting the corresponding environment variables to `true`.

How do I enable write permissions?

Set `ALLOW_INSERT_OPERATION`, `ALLOW_UPDATE_OPERATION`, and `ALLOW_DELETE_OPERATION` in your `.env` or MCP configuration to `true`. Each flag controls its respective operation independently.

What dependencies are required?

You need Node.js, the npm packages listed in `package.json` (installed via `npm install`), and `ts-node` to run the TypeScript entry point.

Where should the server be configured?

The server is configured in `.cursor/mcp.json` within your Cursor IDE project. The connection details and permission flags are passed as environment variables in the MCP server entry.

Does the server support authentication?

Connection authentication uses the MySQL credentials provided in the environment variables (`MYSQL_USER`, `MYSQL_PASS`). No additional authentication layer is described.

数据库分类下的更多 MCP 服务器

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi