Advertise
MCP.so
Sign In

Mysql MCP Server

@Mineru98

Repository

Basic information

Category

Databases

License

MIT

Transports

stdio

Author

Mineru98

About Mysql MCP Server

A server application designed on top of MCP to interact with Cursor and MySQL.

#mysql#mcp

Mysql MCP Server config

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

{
  "mcpServers": {
    "mysql-mcp-server-mineru98": {
      "command": "python",
      "args": [
        "mysql_mcp_server/main.py",
        "run"
      ]
    }
  }
}

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?

mysql-mcp-server is a server application for MySQL database operations built on the Model Context Protocol (MCP). It provides tools that allow AI models to interact with a MySQL database.

How to use mysql-mcp-server?

Deploy via Docker, Docker Compose, or run directly with Python. Set environment variables for MySQL connection (host, port, user, password, database). For Cursor IDE, version 0.46+ and a Pro account are required. Use python mysql_mcp_server/main.py run for local execution.

Key features of mysql-mcp-server

  • Docker and Docker Compose deployment
  • Python-based MCP server using FastMCP
  • Tools for CREATE, SELECT, INSERT, DESC, EXPLAIN, SHOW TABLES
  • Database connection management via singleton pattern
  • Environment variable configuration for credentials
  • Visualization chart recommendation tool

Use cases of mysql-mcp-server

  • AI models querying MySQL databases via natural language
  • Automated database schema exploration and reporting
  • Generating data analysis reports with chart recommendations
  • Executing safe SQL operations through tool-based access
  • Integrating MySQL into MCP-enabled workflows

Frequently asked questions

1

What database tools does mysql-mcp-server provide?

It offers tools for creating tables, viewing schemas, executing SELECT and INSERT queries, retrieving table lists, explaining query plans, and generating insight reports.

2

What are the runtime requirements for mysql-mcp-server?

Python with dependencies (mcp, PyMySQL, pandas, python-dotenv, fire) and MySQL 8.0. Docker and Docker Compose are optional for containerized deployment.

3

How do I add a new tool to mysql-mcp-server?

Create an executor file in `mysql_mcp_server/executors`, then import it in `__init__.py` and add it to the `__all__` array. The `@tool` decorator registers it with MCP.

4

Are there any security considerations for mysql-mcp-server?

Database credentials are managed via environment variables. Use strong passwords in production and consider implementing SSL/TLS encryption for database connections.

5

Does mysql-mcp-server support Cursor IDE?

Yes, it works with Cursor version 0.46 and above, but only for Cursor Pro account users. Configuration requires adding the server in Cursor settings.

Comments

More Databases MCP servers

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

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

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569
Advertise