simple-mysql-mcp-server
If you are the rightful owner of simple-mysql-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A minimal FastAPI-based MCP server that lets GitHub Copilot or other MCP-compatible tools securely query your local or Dockerized MySQL database.
The Simple MySQL MCP Server is a lightweight and efficient server built using FastAPI, designed to facilitate secure interactions between GitHub Copilot or other MCP-compatible tools and a MySQL database. It supports connections to various MySQL instances, whether they are running locally, in a Docker container, or on a Linux-native setup. The server is designed with security in mind, automatically blocking potentially destructive SQL commands such as `DROP` and `DELETE`. Additionally, it logs all queries along with their execution times, providing valuable insights into database interactions. The server is also compatible with MCP.so, as indicated by the inclusion of an `mcp.json` file, ensuring seamless integration with other MCP tools.
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)