I craft unique cereal names, stories, and ridiculously cute Cereal Baby images.

mcp-server-mysql
MCP Server for MySQL databases
1
Github Watches
0
Github Forks
5
Github Stars
mcp-server-mysql
Model Context Protocol Server for MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
Features
- Read-only access to MySQL databases
- Schema inspection capabilities
- Safe query execution within READ ONLY transactions
- Docker support
- NPM package available
Installation
Using Docker
# Build the Docker image
make docker
# Run with Docker
docker run -i --rm mcp/mysql mysql://host:port/dbname
Using NPM
npm install @modelcontextprotocol/server-mysql
Installing via Smithery
To install MySQL Database Server for Claude Desktop automatically via Smithery:
npx -y @smithery/cli install @yuru-sha/mcp-server-mysql --client claude
Usage
With Claude Desktop
Add the following configuration to your claude_desktop_config.json
:
{
"mcpServers": {
"mysql": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"mcp/mysql",
"mysql://host:port/dbname"
]
}
}
}
Note: When using Docker on macOS, use host.docker.internal
if the MySQL server is running on the host network.
Connection URL Format
mysql://[user][:password]@host[:port]/database
Replace /database
with your database name.
Development
# Initial setup
make setup
# Build the project
make build
# Format code
make format
# Run linter
make lint
License
This project is released under the MIT License.
Security
This server enforces read-only access to protect your database. All queries are executed within READ ONLY transactions.
For enhanced security, we recommend creating a read-only user.
Contributing
Contributions are welcome! Please feel free to submit a Pull Request.
相关推荐
Evaluator for marketplace product descriptions, checks for relevancy and keyword stuffing.
I find academic articles and books for research and literature reviews.
This GPT assists in finding a top-rated business CPA - local or virtual. We account for their qualifications, experience, testimonials and reviews. Business operators provide a short description of your business, services wanted, and city or state.
Confidential guide on numerology and astrology, based of GG33 Public information
Discover the most comprehensive and up-to-date collection of MCP servers in the market. This repository serves as a centralized hub, offering an extensive catalog of open-source and proprietary MCP servers, complete with features, documentation links, and contributors.
Micropython I2C-based manipulation of the MCP series GPIO expander, derived from Adafruit_MCP230xx
The all-in-one Desktop & Docker AI application with built-in RAG, AI agents, No-code agent builder, MCP compatibility, and more.
Mirror ofhttps://github.com/agentience/practices_mcp_server
A unified API gateway for integrating multiple etherscan-like blockchain explorer APIs with Model Context Protocol (MCP) support for AI assistants.
Reviews

user_ELP5AykN
As a dedicated user of the mcp app, I am highly impressed with the Huoshan Test product. It seamlessly integrates with my existing setup and provides exceptional performance. The ease of use and intuitive design make it a must-have for anyone needing reliable testing solutions. Kudos to the mcp team for developing such a robust and efficient tool! You can check it out here: https://mcp.so/server/server/mcp