- MySQL MCP Server
MySQL MCP Server
Overview
What is MySQL MCP Server?
MySQL MCP Server is a Model Context Protocol (MCP) server designed for interacting with a MySQL database, allowing MCP clients (like AI assistants) to query and modify data.
How to use MySQL MCP Server?
To use the MySQL MCP Server, install it as a project dependency or as a standalone tool, configure the necessary environment variables for database connection, and run the server to listen for MCP requests.
Key features of MySQL MCP Server?
- Connects to a MySQL database using standard connection parameters.
- Provides tools for executing SQL queries and statements.
- Supports read-only queries (
SELECT,SHOW,DESCRIBE) and write operations (INSERT,UPDATE,DELETE) gated by an environment variable. - Communicates over standard input/output (stdio).
Use cases of MySQL MCP Server?
- Enabling AI assistants to perform database queries.
- Allowing applications to modify database records securely.
- Facilitating data retrieval and manipulation in a controlled environment.
FAQ from MySQL MCP Server?
- Can I use MySQL MCP Server for all types of SQL queries?
Yes, it supports both read-only and write operations, but write operations must be enabled via an environment variable.
- Is MySQL MCP Server free to use?
Yes, it is open-source and free to use.
- How do I enable write operations?
Set the
MYSQL_ALLOW_WRITE_OPSenvironment variable totrueto enable write operations.
Project Info
Created At
a year agoUpdated At
a year agoAuthor Name
actstormsStar
0Language
JavaScriptLicense
-Category
developer-tools
Recommend Servers
View All虎嗅嗅 Ai行业参谋
6 hours ago
Memory
@modelcontextprotocol
a year ago
Shotapi
@smallhandsome
a day ago
Voyei
32 minutes ago
Playwright Mcp
@microsoft
Playwright MCP server
TypeScript
10 months ago
Airtreks Mcp
@SEKeener
a day ago
Fabric
@fabric-agent-plugins
4 hours ago
Amap Maps
@amap
高德地图官方 MCP Server
a year ago