What environment variables does the server require?
MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE must be set.
mysql-server MCP Server
@MCP-Mirror
基本信息
关于 mysql-server MCP Server
Mirror of
mysql-server MCP Server 配置
mysql-server MCP Server 工具
1Execute SQL queries
概览
What is mysql-server MCP Server?
An MCP server that provides tools for querying MySQL databases. It connects to MySQL databases via environment variables and executes SQL queries. Designed for use with MCP clients like Claude Desktop.
How to use mysql-server MCP Server?
Set MySQL connection details as environment variables (MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE) and configure the server in your MCP client's configuration file. The server exposes a single tool called query that takes a SQL string parameter and returns query results.
Key features of mysql-server MCP Server
- Executes SQL queries against MySQL databases
- Single
querytool with required SQL string parameter - Configured via environment variables
- Supports debugging with MCP Inspector
- Written in TypeScript
Use cases of mysql-server MCP Server
- Query a MySQL database through an MCP client like Claude Desktop
- Run ad-hoc SELECT or write queries on demand
- Explore database schema and content interactively
常见问题
How do I configure the server for Claude Desktop?
Add a `mysql` entry to the `mcpServers` object in the Claude Desktop config file, specifying the server path and all environment variables.
How can I debug the server?
Use the MCP Inspector by running `npm run inspector`, which provides a URL with debugging tools.
What transport does the server use?
The README indicates the server communicates over stdio.
Does the server support any authentication method?
It uses password-based MySQL authentication via the MYSQL_PASSWORD environment variable.
数据库 分类下的更多 MCP 服务器
Postgres Mcp
crystaldbaPostgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.
3.0K
Redis MCP Server
redisThe official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently
539
MCP Alchemy
runekaagaardA 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
golfdata.online - Verified Golf Clubs
golfdata.onlineVerified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes
PostgreSQL Model Context Protocol (PG-MCP) Server
stuzero540
评论