広告掲載
MCP.so
ログイン

MySQL MCP Server

@kevinwatt

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT

トランスポート

stdio

作者

kevinwatt

MySQL MCP Server について

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

MySQL MCP Server の設定

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

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

MySQL MCP Server のツール

4

Execute read-only SELECT queries against the MySQL database. - Maximum query length: 4096 characters - Maximum result rows: 1000 - Query timeout: 30 seconds

Execute data modification queries (INSERT/UPDATE/DELETE). - Returns affected rows count and insert ID - Supports parameterized queries - Automatic transaction handling

List all tables in current database

Show table structure

概要

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

よくある質問

1

What limits are enforced on queries?

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

2

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.

3

How are write transactions handled?

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

4

Is the server read‑only for SELECT queries?

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

5

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.

コメント

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

mcp-server-qdrant: A Qdrant MCP server

qdrant

An official Qdrant Model Context Protocol (MCP) server implementation

637

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

PostgreSQL

modelcontextprotocol

Model Context Protocol Servers

88.1K

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

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K
広告掲載