MySQL MCP Server

# MySQL MCP Server Model Context Protocol server for MySQL database access. ## Features - Execute SQL queries with prepared statements - List database tables - Describe table schemas - Get table statistics (row counts, sizes) - Connection pooling for performance ## Installation ```bash npm install npm run build ``` ## Configuration Configure via environment variables: - `MYSQL_HOST` - MySQL server hostname (default: localhost) - `MYSQL_PORT` - MySQL server port (default: 3306) - `MYSQL_USER` - MySQL username (default: root) - `MYSQL_PASS` - MySQL password (default: empty) - `MYSQL_DB` - MySQL database name (default: empty) ## Usage with Claude Code Add to `.claude/.mcp.json`: ```json { "mcpServers": { "mysql": { "command": "node", "args": [ "/path/to/mysql-mcp-server/dist/server.js" ], "env": { "MYSQL_HOST": "your-host", "MYSQL_PORT": "3306", "MYSQL_USER": "your-user", "MYSQL_PASS": "your-password", "MYSQL_DB": "your-database" } } } } ``` ## Available Tools ### `mysql_query` Execute any SQL query with optional prepared statement parameters. **Example:** ```sql SELECT * FROM users WHERE id = ? ``` ### `mysql_show_tables` List all tables in the current database. ### `mysql_describe_table` Get the schema/structure of a specific table. ### `mysql_table_info` Get detailed table information including row counts and sizes. ## License MIT