広告掲載
MCP.so
ログイン

MCP MySQL Server

@Carlosfpc

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

Carlosfpc

MCP MySQL Server について

MCP Server para conexión MySQL con túnel SSH

#mcp-mysql#mysql-server#ssh-tunnel

MCP MySQL Server の設定

標準の設定はありません

このサーバーの README には解析可能な MCP 設定ブロックが含まれていません。インストール手順はリポジトリをご確認ください。

リポジトリ

MCP MySQL Server のツール

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

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

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is MCP MySQL Server?

MCP MySQL Server is an MCP server that enables MySQL database access through an SSH tunnel. Designed for use with Cursor IDE, it allows MCP‑compatible clients to run SQL queries on remote databases while controlling operation permissions.

How to use MCP MySQL Server?

Clone the repository, copy mcp-config.env.example to mcp-config.env, set the MySQL and SSH variables inside that file, then run npm install and npm run start-mcp. For Cursor IDE, add the server configuration to mcp.json using the stdio transport type.

Key features of MCP MySQL Server

  • Connects to MySQL databases through an SSH tunnel.
  • Granular control over INSERT, UPDATE, DELETE, and SELECT operations.
  • Environment‑based configuration for credentials and connection mapping.
  • Ready‑to‑use integration with Cursor IDE.

Use cases of MCP MySQL Server

  • Query a remote MySQL database from an MCP‑compatible client securely.
  • Manage sensitive data by restricting write operations to only SELECT.
  • Access databases behind a firewall using an SSH jump host.

よくある質問

1

What are the prerequisites?

Node.js 14 or later, SSH access to the remote server, a MySQL client, and Cursor IDE.

2

Are write operations enabled by default?

No. By default only SELECT is permitted. You must set `ALLOW_INSERT_OPERATION`, `ALLOW_UPDATE_OPERATION`, or `ALLOW_DELETE_OPERATION` to `true` in `mcp-config.env` to enable those operations.

3

Do I need an SSH tunnel for a local database?

No. If your MySQL server runs locally, you can leave the SSH configuration empty and connect directly using the MySQL variables.

4

How is the server configured?

Edit the `mcp-config.env` file with your MySQL host, port, user, password, database, and optionally the SSH tunnel mapping. Do not share this file.

5

What transport protocol does MCP MySQL Server use?

It uses the stdio transport type.

コメント

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

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

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498

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

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K
広告掲載