Model Context Protocol (MCP) Server for Local MySQL

Name: Model Context Protocol (MCP) Server for Local MySQL
Author: Martyr2

@Martyr2

リポジトリホームページ

Model Context Protocol (MCP) Server for Local MySQL について

Quick little template for a local MCP MySQL server.

#mcp #mysql #server #fastmcp #python

基本情報

カテゴリ

データベース

トランスポート

stdio

公開者

Martyr2

設定

標準の設定はありません

このサーバーの README には解析可能な MCP 設定ブロックが含まれていません。インストール手順はリポジトリをご確認ください。

リポジトリ

ツール

ツールは検出されませんでした

ツールは 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

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.

「データベース」の他のコンテンツ

MCP Server for MySQL based on NodeJS

benborla

A Model Context Protocol server that provides read-only access to MySQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.

1.9K