MCP.so
Sign In

MCP Server MySQL Database Explorer

@eth-ts-x

Basic information

Category

Databases

Transports

stdio

Author

eth-ts-x

About MCP Server MySQL Database Explorer

No overview available yet

MCP Server MySQL Database Explorer config

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

{
  "mcpServers": {
    "mcp-server-mysql-pool": {
      "command": "uv",
      "args": [
        "run",
        "mcp",
        "dev",
        "main.py"
      ]
    }
  }
}

MCP Server MySQL Database Explorer 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 MCP Server MySQL Database Explorer?

This MCP server connects to your MySQL database, providing seamless access to database schemas, tables, and query capabilities through LLMs.

How to use MCP Server MySQL Database Explorer?

Install dependencies with uv add "mcp[cli]" aiomysql, configure environment variables (MYSQL_HOST, MYSQL_PORT, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DB, MYSQL_POOL_SIZE) in a .env file or directly in the environment, then run the server via uv run mcp dev main.py for testing or paste the JSON configuration into your MCP client (e.g., Cline, Cursor).

Key features of MCP Server MySQL Database Explorer

  • Connect to your MySQL database
  • Expose table schemas, CREATE statements, and sample data as resources
  • Run read-only SQL queries with secure validation

Use cases of MCP Server MySQL Database Explorer

—

Frequently asked questions

1

What dependencies are required?

The project requires `uv` and the packages `mcp[cli]` and `aiomysql` to be installed.

2

How do I configure the database credentials?

Set environment variables via a `.env` file at the project root (e.g., MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DB) or define them directly in your environment.

3

Are write operations supported?

No, the server only runs read-only SQL queries with secure validation.

4

Which MCP clients can I use?

The server can be installed in MCP clients like Cline and Cursor by pasting the provided JSON configuration.

5

What is the default connection pool size?

The default MYSQL_POOL_SIZE is 10, configurable via environment variables.

Comments

More Databases MCP servers