Advertise
MCP.so
Sign In

MCP MySQL 本地数据库服务

@TristanLib

Repository

Basic information

Category

Databases

Transports

stdio

Author

TristanLib

About MCP MySQL 本地数据库服务

No overview available yet

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

MCP MySQL 本地数据库服务 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"
    }
  }
}

MCP MySQL 本地数据库服务 tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list directly from this server's endpoint using the button above.

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.

Frequently asked questions

1

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.

2

What runtime dependencies are required?

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

3

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.

4

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).

5

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

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

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

Sqlite

modelcontextprotocol

Model Context Protocol Servers

88.1K

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

Advertise