SZ84.NET
Back to List
OfficialDatabaseSQL

MySQL MCP

The MySQL MCP server allows AI models to query and manage MySQL databases. It provides tools for executing SQL queries, inspecting table schemas, and managing database records. This is a vital tool for developers and data analysts who want to use AI for database management and data exploration with MySQL.

How to Install

1

1. Ensure you have an MCP client installed (e.g., Claude Desktop)

2

2. Click 'Visit Source' below to get the code or package

3

3. Follow the README instructions in the project

4

4. Add the server configuration to your MCP client config file

Configuration Example (claude_desktop_config.json)

{
  "mcpServers": {
    "mysql": {
      "command": "npx",
      "args": [
        "-y",
        "@mcp-get/mysql-mcp"
      ],
      "env": {
        "MYSQL_URL": "mysql://user:password@localhost:3306/database"
      }
    }
  }
}

Key Features

Execute arbitrary SQL queries with safety checks

Inspect database schema and table structures

List tables, columns, and indexes

Support for both read and write operations

Server Details

The MySQL MCP server allows AI models to query and manage MySQL databases. It provides tools for executing SQL queries, inspecting table schemas, and managing database records. This is a vital tool for developers and data analysts who want to use AI for database management and data exploration with MySQL.

Pricing

free

Tags

OfficialDatabaseSQL

Visit Source / Official Link

Go to the official GitHub repository to view source code, documentation, and installation instructions.

GitHub Repository