MySQL MCP Server

MCPOfficialOpen SourceMIT13.5

by shensiqi0701 • Data & Databases

A read-only MCP server that exposes MySQL databases for listing schemas, describing tables, and running safe SELECT/SHOW/EXPLAIN queries.

Example Use Cases

1
Discover available databases and their tables on a MySQL server before executing queries or making decisions.
2
Inspect table schemas and column comments to construct correct, type-aware read-only queries.
3
Run safe read-only SQL (SELECT/SHOW/DESCRIBE/EXPLAIN) against a MySQL database without granting write privileges.

Description

This MCP server provides a simple, read-only interface to a MySQL instance, allowing agents to list databases, enumerate tables, view table structure (with column comments), and execute only safe read-only SQL statements. It is distributed as an npm package (@valuprosys/mysql-mcp-server) and is configured via environment variables for easy integration into an MCP setup. The server helps enforce read-only access patterns and can be auto-approved for common introspection commands in MCP configurations.

Quick Actions

View on GitHub

Security

Scanned 2 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

C53/100

9/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

Ownershensiqi0701

CategoryData & Databases

DependenciesStandalone