MySQL MCP Server
Description
# MySQL MCP Server Version: 0.1.0 A Model Context Protocol (MCP) server for interacting with a MySQL database. This server allows MCP clients (like AI assistants) to query and modify data in a configured MySQL database. ## Features * Connects to a MySQL database using standard…
About
# MySQL MCP Server Version: 0.1.0 A Model Context Protocol (MCP) server for interacting with a MySQL database. This server allows MCP clients (like AI assistants) to query and modify data in a configured MySQL database. ## Features * Connects to a MySQL database using standard connection parameters. * Provides MCP…
Details
- Author
- actstorms
- Downloads
- 298
- Categories
- Database
Jump to
- Connects to MySQL using standard connection parameters.
- Provides MCP tools for executing SQL queries and statements.
- Read-only queries (SELECT, SHOW, DESCRIBE) via the query tool.
- Write operations (INSERT, UPDATE, DELETE) via separate tools.
- Write tools are gated by the MYSQL_ALLOW_WRITE_OPS environment variable.
- Communicates over standard input/output (stdio).
Setting up with Highlight
This MCP is not yet compatible with Highlight’s one-click setup. However, you can still use it with Highlight by following these steps:
- Download and install Highlight from highlightai.com/download
- Navigate to the plugins tab and select "Add Custom Plugin"
-
Configure the plugin with the settings below
Plugin Name
MySQL MCP ServerCommand (node, npx, python, etc.)Please refer to the README for specific instructions on how to obtain API keys or other required environment variables.
- Enable "Start Automatically" if you want the plugin to start when Highlight launches
From the repository
Install dependencies with npm install, build the TypeScript code with npm run build, then run mysql-server (if linked globally) or node build/index.js. Configure connection via environment variables: MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, MYSQL_DATABASE (required), and optionally MYSQL_PORT (default 3306). Set MYSQL_ALLOW_WRITE_OPS=true to enable write tools (insert, update, delete); otherwise only read-only queries are allowed.
Claude Desktop / Cursor
Paste into your MCP client config file to install this server.
{
"mcpServers": {
"mysql mcp server": {
"mcp-mysql-server-actstorms": {
"command": "node",
"args": [
"build/index.js"
]
}
}
}
}McpServers
{
"mcp-mysql-server-actstorms": {
"command": "node",
"args": [
"build/index.js"
]
}
}MySQL MCP Server
Version: 0.1.0
A Model Context Protocol (MCP) server for interacting with a MySQL database. This server allows MCP clients (like AI assistants) to query and modify data in a configured MySQL database.
Features
Connects to a MySQL database using standard connection parameters.
Provides MCP tools for executing SQL queries and statements.
Supports read-only queries (SELECT, SHOW, DESCRIBE).
Supports write operations (INSERT, UPDATE, DELETE) via separate tools, gated by an environment variable (MYSQL_ALLOW_WRITE_OPS).
- Communicates over standard input/output (stdio).
Installation
```bash
Sign in to leave a review
Use Google, GitHub, or an email account so ratings stay tied to real people.
No reviews posted yet.
