広告掲載
MCP.so
ログイン

MCP MySQL 本地数据库服务

@TristanLib

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

TristanLib

MCP MySQL 本地数据库服务 について

概要はまだありません

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

MCP MySQL 本地数据库服务 の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

MCP MySQL 本地数据库服务 のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

上のボタンでサーバーのエンドポイントに接続し、ツール一覧を取得できます。

概要

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.

よくある質問

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.

コメント

「データベース」の他のコンテンツ

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

PostgreSQL Model Context Protocol (PG-MCP) Server

stuzero

540

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.

1

Multi Database MCP Server

FreePeak

A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.

397
広告掲載