MCP Server MySQL Database Explorer

Name: MCP Server MySQL Database Explorer
Author: eth-ts-x

@eth-ts-x

リポジトリ

MCP Server MySQL Database Explorer について

概要はまだありません

#mcp-server #mysql #database-explorer

基本情報

カテゴリ

データベース

ランタイム

python

トランスポート

stdio

公開者

eth-ts-x

設定

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

{
  "mcpServers": {
    "mcp-server-mysql-pool": {
      "command": "uv",
      "args": [
        "run",
        "mcp",
        "dev",
        "main.py"
      ]
    }
  }
}

ツール

ツールは検出されませんでした

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

概要

What is MCP Server MySQL Database Explorer?

This MCP server connects to your MySQL database, providing seamless access to database schemas, tables, and query capabilities through LLMs.

How to use MCP Server MySQL Database Explorer?

Install dependencies with uv add "mcp[cli]" aiomysql, configure environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DB, MYSQL_POOL_SIZE) in a .env file or directly in the environment, then run the server via uv run mcp dev main.py for testing or paste the JSON configuration into your MCP client (e.g., Cline, Cursor).

Key features of MCP Server MySQL Database Explorer

Connect to your MySQL database
Expose table schemas, CREATE statements, and sample data as resources
Run read-only SQL queries with secure validation

Use cases of MCP Server MySQL Database Explorer

—

FAQ from MCP Server MySQL Database Explorer

What dependencies are required?

The project requires uv and the packages mcp[cli] and aiomysql to be installed.

How do I configure the database credentials?

Set environment variables via a .env file at the project root (e.g., MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DB) or define them directly in your environment.

Are write operations supported?

No, the server only runs read-only SQL queries with secure validation.

Which MCP clients can I use?

The server can be installed in MCP clients like Cline and Cursor by pasting the provided JSON configuration.

What is the default connection pool size?

The default MYSQL_POOL_SIZE is 10, configurable via environment variables.

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

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