MCP MySQL Server

# MySQL Connection Settings MYSQL_HOST=localhost MYSQL_PORT=3306 MYSQL_USER=root MYSQL_PASSWORD=your_password MYSQL_DATABASE=your_database # Optional: Use Unix socket instead of TCP connection # MYSQL_SOCKET_PATH=/tmp/mysql.sock # Write Operation Permissions (default: false for security) ALLOW_WRITE=false ALLOW_INSERT=false ALLOW_UPDATE=false ALLOW_DELETE=false ALLOW_DDL=false # Performance Settings POOL_SIZE=10 QUERY_TIMEOUT=30000 # Logging ENABLE_LOGGING=false # Multi-Database Mode # Leave MYSQL_DATABASE empty to enable multi-database mode # In multi-DB mode, you can query any database the user has access to # Example queries in multi-DB mode: # SELECT * FROM database_name.table_name; # USE database_name; SELECT * FROM table_name; # Security Notes: # - Only enable write operations if you trust the AI to modify your data # - Consider using a read-only MySQL user for maximum security # - Use specific database permissions to limit access scope # - Always backup your data before enabling write operations