Mysql MCP Server

Name: Mysql MCP Server
Author: midu2

@midu2

代码仓库

基本信息

分类

数据库

传输方式

stdio

作者

midu2

提交者

di zhou

关于 Mysql MCP Server

暂无概览

Mysql MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@kevinwatt/mysql-mcp"
      ],
      "env": {
        "MYSQL_HOST": "127.0.0.1",
        "MYSQL_PORT": "3306",
        "MYSQL_USER": "root",
        "MYSQL_PASS": "",
        "MYSQL_DB": "your_database"
      }
    }
  }
}

Mysql MCP Server 工具

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

数据库分类下的更多 MCP 服务器

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

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

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