Advertise
MCP.so
Sign In

MySQL MCP Server

@ganganbiz1

Repository

Basic information

Category

Databases

Transports

stdio

Author

ganganbiz1

About MySQL MCP Server

No overview available yet

MySQL MCP Server config

Add this server to your MCP-compatible client using the configuration below.

{
  "mcpServers": {
    "mysql-mcp-server-ganganbiz1": {
      "command": "docker",
      "args": [
        "build",
        "-t",
        "mysql-mcp-server",
        "."
      ]
    }
  }
}

MySQL MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.

Overview

What is MySQL MCP Server?

A MySQL Model Context Protocol (MCP) server implemented with FastMCP 2.0 and Python. It enables AI assistants and MCP clients to execute SQL queries, retrieve database schema information, and explore MySQL databases via standardized MCP tools.

How to use MySQL MCP Server?

Deploy using Docker (recommended) or run locally with Poetry. Set environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE) to connect to a MySQL instance. For Cursor integration, add the provided configuration to ~/.cursor/mcp.json. The server exposes five MCP tools: execute_query, execute_update, get_tables, get_table_schema, and describe_database.

Key features of MySQL MCP Server

  • Execute SQL queries and return results via MCP
  • Get schema information for tables and entire database
  • Fully containerized with Docker and docker-compose
  • Packaged with Poetry for dependency management
  • Provides five ready-to-use MCP tools

Use cases of MySQL MCP Server

  • AI assistants querying MySQL databases in real time
  • Dynamic schema exploration for database documentation
  • Automating data retrieval and updates via MCP clients
  • Integrating MySQL with Cursor or other MCP-supporting IDEs

Frequently asked questions

1

What are the prerequisites for running MySQL MCP Server?

Docker and docker-compose are required for containerized deployment. For local development, you need Python 3.13+ and Poetry.

2

How do I connect the server to my MySQL database?

Set the environment variables `MYSQL_HOST`, `MYSQL_PORT`, `MYSQL_USER`, `MYSQL_PASSWORD`, and `MYSQL_DATABASE` before starting the container. The Docker run command passes these variables from the host environment.

3

What MCP tools does the server provide?

Five tools: `execute_query` (read-only SQL), `execute_update` (INSERT/UPDATE), `get_tables`, `get_table_schema`, and `describe_database` (comprehensive structure).

4

How do I integrate MySQL MCP Server with Cursor?

Add the provided JSON block to `~/.cursor/mcp.json`, specifying the Docker command and environment variables. The server will then be available as an MCP tool within Cursor.

5

Can I develop or run the server locally without Docker?

Yes, the project is packaged with Poetry for local development. The README lists Poetry as a prerequisite for non-Docker usage, though no explicit local run command is given.

Comments

More Databases MCP servers

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

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

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

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

Postgres Mcp

crystaldba

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

3.0K
Advertise