Simple Mysql Mcp Server (python Based)
Description
# Simple 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…
About
# Simple 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) - 🛡️…
Details
- Author
- bintariq
- GitHub stars
- 1
- Downloads
- 364
- Categories
- Database
Jump to
- 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.json included)
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
Simple Mysql Mcp Server (python Based)Command (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Clone the repository, copy config.sample.json to config.json, install Python dependencies with pip install -r requirements.txt, then start the server with uvicorn main:app --host 0.0.0.0 --port 8081.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"simple mysql mcp server (python based)": {
"default": {
"command": "python",
"args": [
"main.py"
]
}
}
}
}McpServers
{
"default": {
"command": "python",
"args": [
"main.py"
]
}
}Simple 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.json included)
---
🛠 Installation (Python)
```bash
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
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
