MCP.so
Sign In

MCP MySQL 本地数据库服务

@TristanLib

Repository

About MCP MySQL 本地数据库服务

No overview available yet

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

Basic information

Category

Databases

Runtime

node

Transports

stdio

Publisher

TristanLib

Config

Add this server to your MCP-compatible client using the configuration below.

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

Tools

No tools detected

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

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.

Comments

More Databases MCP servers

MCP Server for Milvus

zilliztech

Model Context Protocol Servers for Milvus

235

mcp-server-duckdb

ktanaka101

A Model Context Protocol (MCP) server implementation for DuckDB, providing database interaction capabilities

177

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

mcp_mysql_server

xwb602625136

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

245