mcp-server-mysql-pool

mcp-server-mysql-pool

1
databases

The MCP Server MySQL Database Explorer is designed to facilitate connection and interaction with MySQL databases via LLMs, focusing on schema access and read-only query execution. This server offers an efficient interface for database management.

MCP Server MySQL Database Explorer

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

Features

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

Setup Instructions

  1. Install Dependencies

    • Project requires 'uv'. Installation instructions are available via the provided link.

  2. Configure Environment Variables

    • Create a .env file with your database credentials or set the variables directly in your environment.

  3. Run in MCP Interceptor

    • Follow the instructions to start the MCP server and test the connection.

  4. Install the MCP Server in MCP Client

    • Configuration involves pasting JSON settings into your MCP Client.