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 服务器

Sail MCP Server for Spark SQL

lakehq

Drop-in Apache Spark replacement written in Rust, unifying batch processing, stream processing, and compute-intensive AI workloads.

3.1K

Database Gateway

centralmind

Universal MCP-Server for your Databases optimized for LLMs and AI-Agents.

531

Neon MCP Server

neondatabase-labs

MCP server for interacting with Neon Management API and databases

617

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.