MCP Server for Local MySQL

@Martyr2

代码仓库主页

基本信息

分类

数据库

传输方式

stdio

作者

Martyr2

关于 MCP Server for Local MySQL

Quick little template for a local MCP MySQL server.

#mcp #mysql #server #fastmcp #python

MCP Server for Local MySQL 配置

暂无标准配置

该服务器的 README 中没有可解析的 MCP 配置块，请前往代码仓库查看安装说明。

代码仓库

MCP Server for Local MySQL 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

工具是从 README 中自动提取的。维护者可以在 ## Tools 标题下列出工具,即可填充这部分内容。

概览

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

常见问题

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.

数据库分类下的更多 MCP 服务器

NPILayer

Healthcare provider data for AI assistants, from the official CMS NPPES dataset (updated weekly). Look up any NPI (active or deactivated), search providers and organizations by name, city, state, ZIP, taxonomy code or pl

golfdata.online - Verified Golf Clubs

golfdata.online

Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes

Local YDB MCP

astandrik

Safety-first stdio MCP server with 38 tools for operating Docker-based local-ydb environments locally or over SSH.

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

Schemity

tbson

Local database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.