LM Studio
Add dbmcp to LM Studio with the one-click install button or in mcp.json
One-click install
The button installs placeholder values; edit them in mcp.json afterwards.
It adds this server:
{
"command": "npx",
"args": ["-y", "@haymon-ai/dbmcp"],
"env": {
"DBMCP_DB_BACKEND": "mysql",
"DBMCP_DB_HOST": "127.0.0.1",
"DBMCP_DB_USER": "root",
"DBMCP_DB_PASSWORD": "change-me",
"DBMCP_DB_NAME": "mydb"
}
}Manual setup
Open the Program tab, choose Install → Edit mcp.json, and add:
{
"mcpServers": {
"dbmcp": {
"command": "dbmcp",
"args": [],
"env": {
"DBMCP_DB_BACKEND": "mysql",
"DBMCP_DB_HOST": "127.0.0.1",
"DBMCP_DB_USER": "root",
"DBMCP_DB_PASSWORD": "secret",
"DBMCP_DB_NAME": "mydb"
}
}
}
}