MySQL MCP Server

Name: MySQL MCP Server
Author: kevinwatt

@kevinwatt

MySQL MCP Server について

An MCP server implementation that integrates with MySQL databases, providing secure database access capabilities for LLMs.

基本情報

カテゴリ

データベース

ライセンス

MIT

ランタイム

node

トランスポート

stdio

公開者

kevinwatt

設定

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

{
  "mcpServers": {
    "mysql-mcp": {
      "command": "npx",
      "args": [
        "@kevinwatt/mysql-mcp"
      ]
    }
  }
}

ツール

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

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

概要

What is MySQL MCP Server?

MySQL MCP Server is an MCP server implementation that integrates with MySQL databases, providing secure database access capabilities for LLMs. It enables language models to execute SQL queries, list tables, describe schemas, and perform data modifications with transaction support.

How to use MySQL MCP Server?

Install via npm install -g @kevinwatt/mysql-mcp, then configure environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASS, MYSQL_DB) and run with a compatible MCP host like Dive Desktop. Alternatively, start manually with npx @kevinwatt/mysql-mcp.

Key features of MySQL MCP Server

Execute read-only SELECT queries with safety limits
Perform INSERT/UPDATE/DELETE with automatic transactions
List all tables and describe table structures
Parameterized queries for data safety
Query length (4096 chars) and result row (1000) limits

Use cases of MySQL MCP Server

Natural-language database querying via LLM
Automated schema exploration and documentation
Safe data modification with transaction rollback
Integration with MCP‑compatible AI assistants

FAQ from MySQL MCP Server

What limits are enforced on queries?

Maximum query length is 4096 characters, maximum result rows are 1000, and query timeout is 30 seconds.

What are the system requirements?

Node.js 18+ and a running MySQL Server are required. The server must be used with an MCP‑compatible LLM service.

How are write transactions handled?

mysql_execute automatically wraps INSERT/UPDATE/DELETE in transactions, returning affected rows count and last insert ID.

Is the server read‑only for SELECT queries?

Yes, the mysql_query tool enforces a read‑only transaction mode for all SELECT statements.

What authentication or transport configuration is needed?

Connection is configured via environment variables for host, port, user, password, and database. No separate auth mechanism is mentioned beyond standard MySQL credentials.