Model Context Protocol (MCP) Server for Local MySQL

Created By

Martyr26 months ago

Quick little template for a local MCP MySQL server.

# mcp

# mysql

Overview Content Tools Comments

Content

Model Context Protocol (MCP) Server for Local MySQL

Purpose

This is a bare bones basic implementation of an MCP server using FastMCP for Python. I am providing this for anyone who wants to quickly copy, paste run and connect to their tool of choice. Then extend it as they see fit.

How To Get Started

Copy the files into a fresh project with a virtual environment set up.
Type: pip install -r requirements.txt (to install the packages into the virutal environment)
Rename the .env.sample file to be just .env
Set your database credentials in the .env file
Run the project using: python server.py or for the inspector mcp dev server.py

Incorporate it into Claude Code

Claude Code can run these MCP servers by launching a process. Simply add the MCP to the Claude MCP server list (check out the /mcp command for details) and once connected, you can type in a query that would use the tool.

Recommend Servers

TraeBuild with Free GPT-4.1 & Claude 3.7. Fully MCP-Ready.

ChatWiseThe second fastest AI chatbot™

Serper MCP ServerA Serper MCP Server

MiniMax MCPOfficial MiniMax Model Context Protocol (MCP) server that enables interaction with powerful Text to Speech, image generation and video generation APIs.

Baidu Map百度地图核心API现已全面兼容MCP协议，是国内首家兼容MCP协议的地图服务商。

Howtocook Mcp基于Anduin2017 / HowToCook （程序员在家做饭指南）的mcp server，帮你推荐菜谱、规划膳食，解决“今天吃什么“的世纪难题； Based on Anduin2017/HowToCook (Programmer's Guide to Cooking at Home), MCP Server helps you recommend recipes, plan meals, and solve the century old problem of "what to eat today"

AiimagemultistyleA Model Context Protocol (MCP) server for image generation and manipulation using fal.ai's Stable Diffusion model.

DeepChatYour AI Partner on Desktop

MCP AdvisorMCP Advisor & Installation - Use the right MCP server for your needs

Jina AI MCP ToolsA Model Context Protocol (MCP) server that integrates with Jina AI Search Foundation APIs.

Zhipu Web SearchZhipu Web Search MCP Server is a search engine specifically designed for large models. It integrates four search engines, allowing users to flexibly compare and switch between them. Building upon the web crawling and ranking capabilities of traditional search engines, it enhances intent recognition capabilities, returning results more suitable for large model processing (such as webpage titles, URLs, summaries, site names, site icons, etc.). This helps AI applications achieve "dynamic knowledge acquisition" and "precise scenario adaptation" capabilities.