MCP.so
ログイン

MCP Stdio Server (MySQL/MariaDB)

@zerogon1203

リポジトリ

MCP Stdio Server (MySQL/MariaDB) について

概要はまだありません

基本情報

カテゴリ

データベース

ランタイム

python

トランスポート

stdio

公開者

zerogon1203

設定

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

{
  "mcpServers": {
    "db-mcp-server-zerogon1203": {
      "command": "python",
      "args": [
        "-m",
        "venv",
        "venv"
      ]
    }
  }
}

ツール

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

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

概要

What is MCP Stdio Server (MySQL/MariaDB)?

MCP Stdio Server (MySQL/MariaDB) is a Python-based Model Context Protocol (MCP) server that connects to MySQL or MariaDB databases via stdio transport. It returns table structures, relationships, and provides database analysis, query optimization, and monitoring capabilities, designed for integration with Cursor IDE.

How to use MCP Stdio Server (MySQL/MariaDB)?

Clone the repository, create a Python virtual environment, install dependencies, and set database credentials in a .env file (DB_HOST, DB_USER, DB_PASSWORD, DB_NAME). Run the server by adding a stdio MCP server in Cursor IDE with command python main.py; optionally pass environment variables per project via JSON configuration.

Key features of MCP Stdio Server (MySQL/MariaDB)

  • Built on the official MCP Python SDK
  • Stdio transport for Cursor IDE integration
  • Configurable via .env file or JSON env values
  • Returns schema, columns, and foreign key relationships
  • Provides read‑only query execution and EXPLAIN plans
  • Offers table statistics, column stats, and sample data
  • Includes database monitoring and performance analysis

Use cases of MCP Stdio Server (MySQL/MariaDB)

  • Retrieve and visualize database schema and foreign keys
  • Analyze table statistics and column distributions
  • Execute read‑only queries and get execution plans
  • Monitor database status, table sizes, and index usage
  • Identify performance bottlenecks and receive optimization suggestions

FAQ from MCP Stdio Server (MySQL/MariaDB)

What are the runtime dependencies?

Python 3.8+ and a running MySQL or MariaDB database.

How is the database connection configured?

Credentials are set in a .env file at the project root, or passed as environment variables via Cursor’s MCP server JSON configuration.

Which transport does the server use?

It uses stdio transport, enabling seamless integration with Cursor IDE.

Is query execution read‑only?

Yes, the mysql.execute_query method is safe and read‑only; no write operations are performed.

What database information is returned?

The server returns table lists, column details, foreign key relationships, table statistics, sample data, query execution plans, and performance metrics.

コメント

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

Elasticsearch/OpenSearch MCP Server

cr7258

A Model Context Protocol (MCP) server implementation that provides Elasticsearch and OpenSearch interaction.

295

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531

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

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

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