MCP MySQL 本地数据库服务

Name: MCP MySQL 本地数据库服务
Author: TristanLib

@TristanLib

代码仓库

关于 MCP MySQL 本地数据库服务

暂无概览

#mcp #mysql #local-database #api-service

基本信息

分类

数据库

运行时

node

传输方式

stdio

发布者

TristanLib

配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mcp_server_mysql_windows": {
      "name": "MySQL数据库服务",
      "url": "http://localhost:3000/api/sse",
      "type": "sse"
    }
  }
}

工具

未检测到工具

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

概览

What is MCP MySQL 本地数据库服务?

MCP MySQL 本地数据库服务 is a lightweight personal use service for connecting and operating local MySQL databases. It integrates with Cursor as an MCP service, enabling Cursor to execute various database operations via RESTful API and SSE (Server-Sent Events).

How to use MCP MySQL 本地数据库服务?

Install Node.js v14+ and a MySQL server, clone the repository, run npm install, configure a .env file with database credentials and API key, then start with npm start. In Cursor, add it as an MCP service using either SSE (via the /api/sse endpoint) or Command mode.

Key features of MCP MySQL 本地数据库服务

Connects to local MySQL databases.
Provides RESTful API for database operations.
Supports parameterized queries to prevent SQL injection.
Supports SSE (Server-Sent Events) push capability.
Integrates as a Cursor MCP service.

Use cases of MCP MySQL 本地数据库服务

Allowing Cursor to query a local MySQL database during development.
Executing safe parameterized SQL queries via API.
Listing databases, tables, and table structures.
Receiving real‑time database updates through SSE.

FAQ from MCP MySQL 本地数据库服务

Is this service safe to expose to the internet?

No. The README explicitly states this service is for local use only and is not recommended to be exposed to the public network. It uses an API key for protection and defaults to allowing only SELECT queries.

What runtime dependencies are required?

Node.js v14+ and a running MySQL server are required.

How do I configure the database connection?

Create a .env file in the project root with fields for DB_HOST, DB_PORT, DB_USER, DB_PASSWORD, and DB_NAME. Also set an API_KEY for authentication.

What transport does the server use for MCP integration?

The server supports both SSE (via the /api/sse endpoint) and Command mode (running the Node script directly).

Can I execute write queries (INSERT, UPDATE, DELETE)?

By default the server only permits SELECT queries for safety, as noted in the README's security section.

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

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412