What are the prerequisites for running MySQL MCP Server?
You need Node.js 18 or higher, a running MySQL server, and a database with appropriate permissions.
MySQL MCP Server
@LeonMelamud
基本信息
关于 MySQL MCP Server
MCP server that provides direct access to MySQL databases
MySQL MCP Server 配置
MySQL MCP Server 工具
6Create new text notes in the database
List all tables in the connected database
Get the total number of tables in the database
Search for tables using LIKE pattern
Get the structure of a specific table
Execute custom SQL queries
概览
What is MySQL MCP Server?
MySQL MCP Server is an MCP server that gives AI agents direct access to MySQL databases. It lets agents execute SQL queries, manage database content, and interact with database objects through a simple interface.
How to use MySQL MCP Server?
Clone the repository, install dependencies with npm install, create a .env file with MySQL connection details, and run npm run build. Then configure the server for Claude Desktop or Cline by adding the appropriate MCP server configuration pointing to the built index.js file. Once installed, you can ask your AI agent to list tables, execute SQL queries, or create notes.
Key features of MySQL MCP Server
- Access notes stored in the database via
note:///{id}URIs - Create new text notes with
create_notetool - List all tables with
list_tablestool - Count tables with
count_tablestool - Search tables using LIKE pattern with
search_tables - Execute custom SQL queries with
execute_sql
Use cases of MySQL MCP Server
- List all tables in a MySQL database through natural language prompts
- Execute arbitrary SQL queries and retrieve results via an AI agent
- Create and store text notes directly in the database
- Search for tables matching a pattern or describe a table’s structure
常见问题
How do I configure MySQL MCP Server for Claude Desktop?
Add a server entry to `~/Library/Application Support/Claude/claude_desktop_config.json` (MacOS) or `%APPDATA%/Claude/claude_desktop_config.json` (Windows), specifying the `command`, `args` path to `build/index.js`, and `env` variables for MySQL connection.
Where is my database data stored?
All data resides in your own MySQL database. The server connects to the database you configure, and does not store data externally.
What tools does the server provide?
The server provides seven tools: `create_note`, `list_tables`, `count_tables`, `search_tables`, `describe_table`, and `execute_sql`. It also exposes notes as resources.
How do I debug the server?
Use the MCP Inspector by running `npm run inspector`, which provides a URL for debugging tools in your browser.
数据库 分类下的更多 MCP 服务器
Sqlite
modelcontextprotocolModel Context Protocol Servers
88.1K
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
Chroma MCP Server
chroma-coreA Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma
569
Redis
modelcontextprotocolModel Context Protocol Servers
88.2K
MCP Server for MySQL based on NodeJS
benborlaA 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
评论