Enables secure interaction with MySQL databases: list tables, read table contents and run SQL queries.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add mysql-server-designcomputer --env MYSQL_HOST='<MYSQL_HOST>' --env MYSQL_USER='<MYSQL_USER>' --env MYSQL_PASSWORD='<MYSQL_PASSWORD>' --env MYSQL_DATABASE='<MYSQL_DATABASE>' --env MYSQL_PORT='<MYSQL_PORT>' -- uv --directory path/to/mysql_mcp_server run mysql_mcp_server~/.codex/config.toml
[mcp_servers.mysql-server-designcomputer]
command = "uv"
args = ["--directory", "path/to/mysql_mcp_server", "run", "mysql_mcp_server"]
env = { MYSQL_HOST = "<MYSQL_HOST>", MYSQL_USER = "<MYSQL_USER>", MYSQL_PASSWORD = "<MYSQL_PASSWORD>", MYSQL_DATABASE = "<MYSQL_DATABASE>", MYSQL_PORT = "<MYSQL_PORT>" }
# codex mcp add mysql-server-designcomputer --env MYSQL_HOST='<MYSQL_HOST>' --env MYSQL_USER='<MYSQL_USER>' --env MYSQL_PASSWORD='<MYSQL_PASSWORD>' --env MYSQL_DATABASE='<MYSQL_DATABASE>' --env MYSQL_PORT='<MYSQL_PORT>' -- uv --directory path/to/mysql_mcp_server run mysql_mcp_server~/.cursor/mcp.json
{
"mcpServers": {
"mysql-server-designcomputer": {
"command": "uv",
"args": [
"--directory",
"path/to/mysql_mcp_server",
"run",
"mysql_mcp_server"
],
"env": {
"MYSQL_HOST": "<MYSQL_HOST>",
"MYSQL_USER": "<MYSQL_USER>",
"MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
"MYSQL_DATABASE": "<MYSQL_DATABASE>",
"MYSQL_PORT": "<MYSQL_PORT>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"mysql-server-designcomputer": {
"type": "stdio",
"command": "uv",
"args": [
"--directory",
"path/to/mysql_mcp_server",
"run",
"mysql_mcp_server"
],
"env": {
"MYSQL_HOST": "<MYSQL_HOST>",
"MYSQL_USER": "<MYSQL_USER>",
"MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
"MYSQL_DATABASE": "<MYSQL_DATABASE>",
"MYSQL_PORT": "<MYSQL_PORT>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"mysql-server-designcomputer": {
"command": "uv",
"args": [
"--directory",
"path/to/mysql_mcp_server",
"run",
"mysql_mcp_server"
],
"env": {
"MYSQL_HOST": "<MYSQL_HOST>",
"MYSQL_USER": "<MYSQL_USER>",
"MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
"MYSQL_DATABASE": "<MYSQL_DATABASE>",
"MYSQL_PORT": "<MYSQL_PORT>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"mysql-server-designcomputer": {
"command": "uv",
"args": [
"--directory",
"path/to/mysql_mcp_server",
"run",
"mysql_mcp_server"
],
"env": {
"MYSQL_HOST": "<MYSQL_HOST>",
"MYSQL_USER": "<MYSQL_USER>",
"MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
"MYSQL_DATABASE": "<MYSQL_DATABASE>",
"MYSQL_PORT": "<MYSQL_PORT>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"mysql-server-designcomputer": {
"command": "uv",
"args": [
"--directory",
"path/to/mysql_mcp_server",
"run",
"mysql_mcp_server"
],
"env": {
"MYSQL_HOST": "<MYSQL_HOST>",
"MYSQL_USER": "<MYSQL_USER>",
"MYSQL_PASSWORD": "<MYSQL_PASSWORD>",
"MYSQL_DATABASE": "<MYSQL_DATABASE>",
"MYSQL_PORT": "<MYSQL_PORT>"
}
}
}
}Environment variables
MYSQL_HOSTMYSQL_USERMYSQL_PASSWORDMYSQL_DATABASEMYSQL_PORT
Replace the placeholders with your own credentials and keep them out of version control.