MySQL MCP Server

MCPOpen Source14.0

by wuwen1030 • Data & Databases

A Model Context Protocol (MCP) server implementation that lets AI agents interact with MySQL databases for schema discovery and read-only queries.

Example Use Cases

1
List available MySQL tables and discover database structure before generating queries.
2
Inspect table schemas and metadata to validate or construct context-aware SQL queries.
3
Run read-only SQL queries safely against a MySQL database with automatic transaction rollback.

Description

This project implements an MCP server backed by MySQL so models and agents can list tables, retrieve table schemas, and execute read-only SQL queries. It includes safe transaction handling with automatic rollback to prevent persistent changes. The README includes a sample Claude Desktop App configuration showing how to launch the server with environment variables for database connection.

Quick Actions

View on GitHub

Security

Scanned 2 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

D41/100

3/17 checks passed

Scores are informational only and provided “as is” without warranty. AgentHotspot assumes no liability for actions taken based on these ratings.

Quick Stats

Service TypeMCP

Pricing ModelFree

Capabilities0 Tools / 0 Prompts / 0 Resources

Ownerwuwen1030

CategoryData & Databases

DependenciesStandalone