About Simple Mysql Mcp Server (python Based)
A lightweight FastAPI-based MCP server for querying local or Dockerized MySQL databases. It blocks destructive SQL and records query timing for developers using MCP-compatible tools.
Key features
- 01Connects to MySQL instances
- 02Blocks destructive SQL statements
- 03Logs queries and timing
- 04FastAPI-based implementation
Use cases
- 01Querying a local MySQL database
- 02Inspecting data in a Dockerized MySQL instance
- 03Using MySQL through an MCP-compatible tool
MCP support
Exposes MySQL querying to MCP-compatible clients. It includes an `mcp.json` configuration for MCP.so compatibility.
Configuration
Local server config is the same for every client. Copy it into your client’s MCP config file.
We haven’t collected a package or remote endpoint for this server. Follow the instructions in the project README.
Tools
Local servers expose tools only once running on your machine, and the maintainer has not provided a tool list.
Details
From the project READMESimple MySQL MCP Server
A minimal FastAPI-based MCP server that lets GitHub Copilot or other MCP-compatible tools securely query your local or Dockerized MySQL database.
⚡ Features
- 🔌 Connects to any MySQL instance (XAMPP, Docker, Linux-native, etc.)
- 🚀 Fast and lightweight (built with FastAPI)
- 🛡️ Auto-blocks destructive SQL (
DROP,DELETE, etc.) - 📊 Logs queries with timing
- 🧩 MCP.so-compatible (
mcp.jsonincluded)
🛠 Installation (Python)
git clone https://github.com/your-username/simple-mysql-mcp-server.git
cd simple-mysql-mcp-server
cp config.sample.json config.json
pip install -r requirements.txt
uvicorn main:app --host 0.0.0.0 --port 8081
Comments
New to MCP?
From what the protocol is to installing your first server, these answers cover most first questions.
An open protocol that defines how AI applications connect to external tools and data in a uniform way. Clients talk to the model; MCP servers provide tools, resources and prompt templates. They exchange standard messages, so one server can be reused by many clients.