MCP Server MySQL Files

The following are the additional and changes in the MCP.

From: @echarrod

Add connection pool keep-alive settings

Configuration Options Added

• waitForConnections: true - Queue connection requests when pool is full instead of immediately erroring
• queueLimit: 100 (default, configurable) - Limits queued requests to prevent unbounded memory growth
• enableKeepAlive: true - Enable TCP keep-alive packets
• keepAliveInitialDelay: 0 - Start keep-alive checks immediately
• connectTimeout: 10000ms (default, configurable) - 10 second connection timeout for better UX

Environment Variables - MYSQL_QUEUE_LIMIT - Override default queue limit (default: 100) - MYSQL_CONNECT_TIMEOUT - Override connect timeout in milliseconds (default: 10000)

Use Cases This addresses connection stability issues when:

• Running long-lived MCP server instances
• Connecting through proxies with idle connection timeouts
• Database servers behind load balancers or connection pools
• Network conditions with intermittent connectivity

From @echarrod

Add MySQL connection string support

Core Implementation Connection String Parser (src/utils/index.ts):

• Parses MySQL CLI-format connection strings
• Supports short flags (-h, -P, -u, -p, -S) and long options (--host, --port, etc.)
• Handles quoted values and complex passwords
• Validates port numbers (1-65535 range, NaN checks)

Configuration Integration (src/config/index.ts): - Added MYSQL_CONNECTION_STRING environment variable support - Connection string takes precedence over individual env vars - Maintains backward compatibility with existing configurations - Fixed password fallback consistency in authPlugins

Documentation

• Updated README.md with connection string option (positioned as alternative, not primary method)
• Added examples and security notes about not storing in version control
• Updated .env.dist with connection string example

From @bulgariamitko

Correct package attribution and genericize all examples

Key Changes Fixed

🔧 Package Attribution Correction

• Restored original package name from @bulgariamitko/mcp-server-mysql-write to @benborla29/mcp-server-mysql
• Removed personal GitHub username references
• Restored original author attribution to Ben Borla

Genericized All Examples

• Project Names: Replaced personal project names (nima, izdavam, nufc, studia) with generic examples (project-a, project-b, project-c, project-d)
• Server Names: Replaced personal servers (gold.superhosting.bg, nufc.bg) with example.com variants
• Database Names: Replaced personal database names (izdavamc_, pwr0iwww_) with generic db_* format
• File Paths: Replaced personal file paths with generic placeholders