Simple MCP MySQL Server

@alexcc4

リポジトリ

基本情報

カテゴリ

データベース

トランスポート

stdio

作者

alexcc4

Simple MCP MySQL Server について

A lightweight MCP server for MySQL, built with python

#mysql #python #mcp-server

Simple MCP MySQL Server の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "mcp-mysql-server-alexcc4": {
      "command": "uv",
      "args": [
        "sync"
      ]
    }
  }
}

Simple MCP MySQL Server のツール

Execute read-only SQL queries and return results

概要

What is Simple MCP MySQL Server?

A lightweight Model Context Protocol (MCP) server that enables secure interaction with MySQL databases, allowing AI assistants like Claude to list tables, read data, and execute read-only SQL queries through a controlled interface.

How to use Simple MCP MySQL Server?

Clone the repository and run uv sync to install dependencies. Set the five environment variables (DB_HOST, DB_PORT, DB_USER, DB_PASSWORD, DB_NAME). Start manually with uv run main.py or integrate with Claude Desktop by adding the server configuration to claude_desktop_config.json. Then ask natural language queries like “Show me all tables” or “Top 10 rows from users table”.

Key features of Simple MCP MySQL Server?

List all MySQL tables in the database
Retrieve detailed schema information for all tables
Execute read-only SQL queries with error handling
Secure database access through environment variables
Simple configuration and deployment

Use cases of Simple MCP MySQL Server?

Ask Claude to list all tables in the database
Retrieve the top 10 rows from the users table
Find all orders placed in the last 30 days
Count the number of users by country
Show the schema of the products table

よくある質問

What dependencies are required?

Python 3.12.2+, uv (recommended), and a MySQL server.

What database permissions are recommended?

Use a database user with minimal

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

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.

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

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

MCP DB Wizard

srmadscience

Oracle MCP server with no run-sql tool: It generates tools for each of the PL/SQL procedures, tables and approved SQL you choose. The server doesn't expose a SQL prompt, and can't reveal how it's connected to Oracle.

MotherDuck's DuckDB MCP Server

motherduckdb

Local MCP server for DuckDB and MotherDuck

498