MySQL MCP Server
An MCP server implementation that integrates with MySQL databases, providing secure database access capabilities for LLMs.
Features
- Read Operations
- Execute read-only SELECT queries
- List all database tables
- Show table structures
- View schema information
- Write Operations
- Execute INSERT/UPDATE/DELETE with transaction support
- Parameterized queries for data safety
- Returns affected rows and insert IDs
- Security
- Read-only transaction mode for SELECT queries
- Query length and result size limits
- Performance monitoring and logging
- Automatic transaction handling
Installation
npm install -g @kevinwatt/mysql-mcp
Usage with Dive Desktop
- Click "+ Add MCP Server" in Dive Desktop
- Copy and paste this configuration:
{
"mcpServers": {
"mysql": {
"command": "npx",
"args": [
"-y",
"@kevinwatt/mysql-mcp"
],
"env": {
"MYSQL_HOST": "127.0.0.1",
"MYSQL_PORT": "3306",
"MYSQL_USER": "root",
"MYSQL_PASS": "",
"MYSQL_DB": "your_database"
}
}
}
}
- Click "Save" to install the MCP server
Tool Documentation
-
mysql_query
- Execute read-only SELECT queries
- Inputs:
sql(string): SQL SELECT query to execute
- Limits:
- Maximum query length: 4096 characters
- Maximum result rows: 1000
- Query timeout: 30 seconds
-
mysql_execute
- Execute data modification operations
- Inputs:
sql(string): SQL statement (INSERT/UPDATE/DELETE)params(array, optional): Parameters for the SQL statement
- Features:
- Returns affected rows count
- Returns last insert ID
- Automatic transaction handling
-
list_tables
- List all tables in current database
- No inputs required
-
describe_table
- Show table structure
- Inputs:
table(string): Table name to describe
Usage Examples
Ask your LLM to:
"Show me all tables in the database"
"Describe the structure of users table"
"Select all active users from the database"
"Insert a new record into orders table"
Manual Start
If needed, start the server manually:
npx @kevinwatt/mysql-mcp
Requirements
- Node.js 18+
- MySQL Server
- MCP-compatible LLM service
License
MIT
Author
Dewei Yen
Keywords
- mcp
- mysql
- database
- dive
- llm
- ai