simple-mysql-mcp-server

simple-mysql-mcp-server

3.1

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)