MySQL MCP Server

Example Use Cases

• 1

  Read-only access to a MySQL database to run SELECT, SHOW, EXPLAIN, or DESCRIBE queries without exposing write capabilities.

• 2

  Inspect table structure and retrieve schema details for automated analysis or data-mapping tasks.

• 3

  Enumerate tables and fetch sample rows (up to 100 rows) from a specified table for previewing or validation.

Description

This project implements a Model Context Protocol (MCP) server that connects to a MySQL database and exposes read-only operations. It supports executing SELECT/SHOW/EXPLAIN/DESCRIBE queries, retrieving table schemas, listing all tables, and fetching up to 100 rows from a specified table. Configuration is done via environment variables and a simple mcp.json entry, making it easy to integrate into MCP-enabled systems. It's intended as an open-source utility for agents that need safe, read-only database access.