MySQL MCP Server

# 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 ```bash npm install -g @kevinwatt/mysql-mcp ``` ## Usage with [Dive Desktop](https://github.com/OpenAgentPlatform/Dive) 1. Click "+ Add MCP Server" in Dive Desktop 2. Copy and paste this configuration: ```json { "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" } } } } ``` 3. 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: ```bash 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