MySQL MCP Server

MCPOpen SourceMIT33.1

by yuru-sha • Data & Databases

A Model Context Protocol (MCP) server that lets LLM agents inspect MySQL schemas and run read-only queries safely.

Example Use Cases

1
Inspect MySQL database schemas to understand table structures, columns, and relationships before generating queries.
2
Run safe, read-only SQL queries against a MySQL database to answer data-focused questions without risking data modification.
3
Integrate database access into desktop LLM workflows (e.g., Claude Desktop) via Docker or an NPM-installed MCP server.

Description

This repository provides an MCP server for MySQL databases, enabling language models to explore database schemas and execute read-only queries within READ ONLY transactions. It emphasizes safety by enforcing read-only access and recommends using a read-only database user. The project supports Docker and publishing via an NPM package, and integrates easily with tools like Claude Desktop.

Capabilities(1 total)

Tools (1)

mysql_query

[MySQL MCP Server [v0.1.0]] Run SELECT queries against MySQL database (READ-ONLY) (Multi-DB mode enabled)

sql:string*

Quick Actions

View on GitHub

Security

Scanned 3 month(s) ago

Risk Level

MINIMAL

Read-only data retrieval, no side effects

Trust Score

C63/100

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

Capabilities1 Tools / 0 Prompts / 0 Resources

Owneryuru-sha

CategoryData & Databases

DependenciesStandalone

Set Your Username