广告合作
MCP.so
登录

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 工具

1

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

常见问题

1

What dependencies are required?

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

2

What database permissions are recommended?

Use a database user with minimal

评论

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

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

Xata MCP Server

The Xata MCP server lets AI assistants and agents interact with your Xata organizations, projects, and Postgres database branches.

Chroma MCP Server

chroma-core

A Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma

569

Neon MCP Server

neondatabase

MCP server for interacting with Neon Management API and databases

617

MCP Alchemy

runekaagaard

A MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.

412
广告合作