广告合作
MCP.so
登录

mysqldb-mcp-server MCP server

@MCP-Mirror

代码仓库

基本信息

分类

其他

许可证

MIT license

传输方式

stdio

作者

MCP-Mirror

关于 mysqldb-mcp-server MCP server

Mirror of

#mysqldb#mcp-server#database

mysqldb-mcp-server MCP server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "burakdirin_mysqldb-mcp-server": {
      "command": "uv",
      "args": [
        "pip",
        "install",
        "mysqldb-mcp-server"
      ]
    }
  }
}

mysqldb-mcp-server MCP server 工具

2

Connects to a specific MySQL database

Executes MySQL queries

概览

What is mysqldb-mcp-server?

mysqldb-mcp-server is a MySQL database MCP server that provides tools to connect to MySQL databases and execute SQL queries via the Model Context Protocol. It is designed for developers who want to interact with MySQL databases through AI assistants that support MCP.

How to use mysqldb-mcp-server?

Install the package using pip or uv, then configure environment variables (MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE, MYSQL_READONLY). Add the server configuration to Claude Desktop’s claude_desktop_config.json. Use the connect_database tool to connect to a specific database and execute_query to run SQL queries.

Key features of mysqldb-mcp-server

  • Provides two tools: connect_database and execute_query
  • Supports multiple SQL queries separated by semicolons
  • Returns query results in JSON format
  • Enables read‑only mode via the MYSQL_READONLY environment variable
  • Can be installed via Smithery for automated Claude Desktop setup

Use cases of mysqldb-mcp-server

  • Querying MySQL databases directly from an AI assistant conversation
  • Executing database migrations or updates through natural language commands
  • Reading and analyzing data from a MySQL database without leaving the chat interface

常见问题

1

What tools does the server provide?

Two tools: `connect_database` (connects to a specific database) and `execute_query` (runs SQL queries and returns results in JSON).

2

How do I configure the server?

Set environment variables `MYSQL_HOST`, `MYSQL_USER`, `MYSQL_PASSWORD`, optionally `MYSQL_DATABASE`, and `MYSQL_READONLY` for read‑only mode.

3

Can I run queries in read‑only mode?

Yes, by setting `MYSQL_READONLY` to `1` or `true`.

4

How do I install the server?

Using `pip install mysqldb-mcp-server` or `uv pip install mysqldb-mcp-server`. A published version can also be run via `uvx`.

5

What are the runtime requirements?

The server runs on Python and requires a MySQL connection. No additional runtime dependencies beyond the package are mentioned in the README.

评论

其他 分类下的更多 MCP 服务器

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

YOUB

Connect your AI assistant to your own YOUB endurance training account. Read recorded activities with full analysis, planned sessions, race goals, wellness (HRV, sleep, resting HR) and your athletic profile. Create or mov

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

Codelf

unbug

A search tool helps dev to solve the naming things problem.

14.2K

Yuppsy

Yuppsy MCP: build and publish real estate websites from your AI assistant. Yuppsy lets your AI assistant create live websites for real estate agents and individual property listings. You don't need a designer or any code

广告合作