MCP Server MySQL

A Model Context Protocol (MCP) server that provides MySQL database operations. This server enables LLMs to interact with MySQL databases through a standardized protocol.

Features

Database Management: Create, drop, list, and switch databases
Table Operations: Create, alter, drop, describe, and list tables
Data Queries: Execute SELECT queries and retrieve results
Data Modification: Execute INSERT, UPDATE, DELETE statements
Index Management: Create and drop indexes

Installation

npm install npm run build

Configuration

Set environment variables for database connection:

export MYSQL_HOST=localhost export MYSQL_PORT=3306 export MYSQL_USER=root export MYSQL_PASSWORD=your-password export MYSQL_DATABASE=your-database # optional

Permission Controls

Control which write operations are allowed (all default to true):

export MYSQL_ALLOW_INSERT=true # Set to "false" to disable INSERT export MYSQL_ALLOW_UPDATE=true # Set to "false" to disable UPDATE export MYSQL_ALLOW_DELETE=false # Set to "false" to disable DELETE

Or use the connect tool at runtime to specify connection parameters.

Usage with Claude Desktop

Using npx (Recommended)

Add to your claude_desktop_config.json:

{ "mcpServers": { "mysql": { "command": "npx", "args": ["-y", "@nilsir/mcp-server-mysql"], "env": { "MYSQL_HOST": "localhost", "MYSQL_PORT": "3306", "MYSQL_USER": "root", "MYSQL_PASSWORD": "your-password", "MYSQL_DATABASE": "your-database", "MYSQL_ALLOW_INSERT": "true", "MYSQL_ALLOW_UPDATE": "true", "MYSQL_ALLOW_DELETE": "false" } } } }

Using Local Installation

{ "mcpServers": { "mysql": { "command": "node", "args": ["/absolute/path/to/mcp-server-mysql/dist/index.js"], "env": { "MYSQL_HOST": "localhost", "MYSQL_PORT": "3306", "MYSQL_USER": "root", "MYSQL_PASSWORD": "your-password", "MYSQL_DATABASE": "your-database", "MYSQL_ALLOW_INSERT": "true", "MYSQL_ALLOW_UPDATE": "true", "MYSQL_ALLOW_DELETE": "false" } } } }

Available Tools

Tool	Description
`connect`	Connect to a MySQL database
`query`	Execute SELECT queries
`execute`	Execute INSERT/UPDATE/DELETE queries
`list_databases`	List all databases
`list_tables`	List tables in a database
`describe_table`	Get table structure
`create_table`	Create a new table
`alter_table`	Modify table structure
`drop_table`	Drop a table
`create_database`	Create a new database
`drop_database`	Drop a database
`use_database`	Switch to a database
`create_index`	Create an index
`drop_index`	Drop an index

Examples

Query data

Use the query tool with sql: "SELECT * FROM users WHERE active = ?" and params: [true]

Create a table

Use the create_table tool with: - table: "users" - columns: [ {"name": "id", "type": "INT", "primaryKey": true, "autoIncrement": true}, {"name": "email", "type": "VARCHAR(255)", "nullable": false}, {"name": "created_at", "type": "TIMESTAMP", "default": "CURRENT_TIMESTAMP"} ]