mcp-server-mysql
Provides read-only access to MySQL databases, supporting queries and schema inspection.
- Type
- MCP
- Transport
- stdio
- Open source
- Yes
- GitHub Stars
- ★ 1.9k
- Source
- mcp-github
- Repository
- github.com/benborla/mcp-server-mysql
Overview
mcp-server-mysql is a Model Context Protocol server that enables LLMs to inspect MySQL database schemas and perform read-only queries. It supports SSH tunneling, multiple database schemas, and automatic PII data masking. Through the MCP protocol, AI can seamlessly connect to MySQL databases, making it suitable for applications requiring data analysis and querying. Ideal for developers and data analysts.
Capabilities
- ▪Read-only query MySQL databases
- ▪Inspect database schemas
- ▪SSH tunneling support
- ▪Multiple database schemas
- ▪Automatic PII data masking
Use cases
Setup
claude mcp add mcp_server_mysql -e MYSQL_HOST="127.0.0.1" -e MYSQL_PORT="3306" -e MYSQL_USER="root" -e MYSQL_PASS="your_password" -e MYSQL_DB="your_database" -- npx @benborla29/mcp-server-mysql
This information was compiled by AI from public sources and may contain inaccuracies — please refer to the source.
FAQ
How to enable write operations?
Set the environment variables ALLOW_INSERT_OPERATION=true, ALLOW_UPDATE_OPERATION=true, ALLOW_DELETE_OPERATION=true.
What transport protocols are supported?
Supports stdio and HTTP transport protocols.
Related skills
OpenMetadata
OpenMetadata is an open data context layer that provides trustworthy data context and business semantics for AI.
XHS-Downloader
A link extraction and content collection tool for Xiaohongshu, supporting multiple download and information extraction features.
unstract
LLM-based tool for extracting structured data from unstructured documents, supporting API deployment and ETL workflows.
FinanceToolkit
Transparent and efficient financial analysis tool supporting various financial products and metrics.
deeplake
Deeplake is a data runtime designed for AI agents, offering a serverless multimodal data lake.
skills
Provides real-time market data and options analytics for AI agents.