広告掲載
MCP.so
ログイン

MySQL MCP Server for Smithery (Python)

@aqaranewbiz

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

aqaranewbiz

MySQL MCP Server for Smithery について

概要はまだありません

MySQL MCP Server for Smithery の設定

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

{
  "mcpServers": {
    "mcp-mysql-server-aqaranewbiz": {
      "command": "node",
      "args": [
        "run.js"
      ]
    }
  }
}

MySQL MCP Server for Smithery のツール

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

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

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

概要

What is MySQL MCP Server for Smithery (Python)?

MySQL MCP Server for Smithery (Python) is a connector that lets you connect to a MySQL database directly from Smithery. It is built with Python and provides tools for listing databases, tables, describing schemas, and executing read-only SQL queries.

How to use MySQL MCP Server for Smithery (Python)?

Add the server in Smithery, then enter your MySQL credentials (host, port, user, password, optional database). Alternatively, clone the repository, install dependencies (npm install, pip install -r requirements.txt), and start with node run.js or python mcp_server.py.

Key features of MySQL MCP Server for Smithery (Python)

  • Connect to MySQL databases with configurable credentials
  • List all accessible databases
  • View all tables in a database
  • Get detailed schema information for tables
  • Execute read-only SQL queries (SELECT, SHOW, DESCRIBE, EXPLAIN)
  • Built‑in query validation blocks write operations

Use cases of MySQL MCP Server for Smithery (Python)

  • Explore the structure of a MySQL database from Smithery
  • Run read-only queries to retrieve data without risk of modification
  • Audit database schemas across multiple databases
  • Integrate database inspection into Smithery workflows

よくある質問

1

What SQL statements are allowed?

Only SELECT, SHOW, DESCRIBE, and EXPLAIN queries are permitted. INSERT, UPDATE, DELETE, DROP, and other write commands are rejected.

2

What are the runtime dependencies?

Python 3 with `mysql-connector-python>=8.0.0` and Node.js (for the launcher script). Missing modules are auto‑installed if possible.

3

How do I troubleshoot connection issues?

Verify your database credentials, ensure the MySQL server is running and accessible, and check Smithery’s console log for errors.

4

Can I run multiple SQL statements in one query?

No. Multiple statements separated by semicolons are not allowed for security reasons.

5

Does the server require authentication?

Yes, you must provide a valid MySQL username and password. The server does not implement additional authentication layers.

コメント

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

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

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
広告掲載