Model Context Protocol (MCP) Server for Local MySQL
@Martyr2
About Model Context Protocol (MCP) Server for Local MySQL
Quick little template for a local MCP MySQL server.
Config
No standard config provided
This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.
RepositoryTools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is Model Context Protocol (MCP) Server for Local MySQL?
A bare bones basic implementation of an MCP server using FastMCP for Python. It connects to a local MySQL database and is intended for anyone who wants to quickly copy, paste, run, and connect the server to their tool of choice, then extend it as they see fit.
How to use Model Context Protocol (MCP) Server for Local MySQL?
Copy the files into a fresh project with a virtual environment, install dependencies with pip install -r requirements.txt, rename .env.sample to .env, set your database credentials in the .env file, then run the project using python server.py or mcp dev server.py. To incorporate it into Claude Code, add the MCP to Claude’s MCP server list.
Key features of Model Context Protocol (MCP) Server for Local MySQL
- Bare bones basic implementation using FastMCP for Python
- Connects to a local MySQL database
- Quick setup with minimal configuration
- Environment‑based credential management via
.env - Easily extendable for custom use cases
Use cases of Model Context Protocol (MCP) Server for Local MySQL
- Quickly prototype MCP‑based tools that interact with a local MySQL database
- Integrate MySQL queries into AI assistant workflows like Claude Code
- Serve as a starting template for building more complex database MCP servers
FAQ from Model Context Protocol (MCP) Server for Local MySQL
How do I install the server?
Copy the files into a fresh project with a virtual environment, then run pip install -r requirements.txt to install the required packages.
How do I set up the database credentials?
Rename the .env.sample file to .env and set your database credentials inside that file.
How do I run the server?
Run the project using python server.py or, for the inspector, use mcp dev server.py.
How do I connect the server to Claude Code?
Add the MCP to Claude’s MCP server list (see the /mcp command for details). Once connected, you can type a query that would use the tool.
What is the purpose of this server?
It is a bare bones basic implementation of an MCP server for local MySQL, meant to be quickly copied, pasted, run, and then extended as needed.
Frequently asked questions
How do I install the server?
Copy the files into a fresh project with a virtual environment, then run `pip install -r requirements.txt` to install the required packages.
How do I set up the database credentials?
Rename the `.env.sample` file to `.env` and set your database credentials inside that file.
How do I run the server?
Run the project using `python server.py` or, for the inspector, use `mcp dev server.py`.
How do I connect the server to Claude Code?
Add the MCP to Claude’s MCP server list (see the `/mcp` command for details). Once connected, you can type a query that would use the tool.
What is the purpose of this server?
It is a bare bones basic implementation of an MCP server for local MySQL, meant to be quickly copied, pasted, run, and then extended as needed.
Basic information
More Databases MCP servers
Elasticsearch MCP Server
elastic
PostgreSQL Model Context Protocol (PG-MCP) Server
stuzero
Dbhub
bytebaseZero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.
nuzur
nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi
MCP MongoDB Server
kiliczshA Model Context Protocol Server for MongoDB
Comments