A powerful MCP server that lets you have natural language conversations with your database. Ask it to do complex analysis, generate beautiful visualizations, or build custom interactive dashboards based your data.
Setup
Choose your client, copy the config, then fill in any required environment variables.
claude mcp add dbmcp-server-for-databases --env DB_URL='<DB_URL>' --env DB_USER='<DB_USER>' --env DB_PASSWORD='<DB_PASSWORD>' --env DB_DRIVER='<DB_DRIVER>' -- java -jar target/dbmcp-1.0.0.jar~/.codex/config.toml
[mcp_servers.dbmcp-server-for-databases]
command = "java"
args = ["-jar", "target/dbmcp-1.0.0.jar"]
env = { DB_URL = "<DB_URL>", DB_USER = "<DB_USER>", DB_PASSWORD = "<DB_PASSWORD>", DB_DRIVER = "<DB_DRIVER>" }
# codex mcp add dbmcp-server-for-databases --env DB_URL='<DB_URL>' --env DB_USER='<DB_USER>' --env DB_PASSWORD='<DB_PASSWORD>' --env DB_DRIVER='<DB_DRIVER>' -- java -jar target/dbmcp-1.0.0.jar~/.cursor/mcp.json
{
"mcpServers": {
"dbmcp-server-for-databases": {
"command": "java",
"args": [
"-jar",
"target/dbmcp-1.0.0.jar"
],
"env": {
"DB_URL": "<DB_URL>",
"DB_USER": "<DB_USER>",
"DB_PASSWORD": "<DB_PASSWORD>",
"DB_DRIVER": "<DB_DRIVER>"
}
}
}
}.vscode/mcp.json
{
"servers": {
"dbmcp-server-for-databases": {
"type": "stdio",
"command": "java",
"args": [
"-jar",
"target/dbmcp-1.0.0.jar"
],
"env": {
"DB_URL": "<DB_URL>",
"DB_USER": "<DB_USER>",
"DB_PASSWORD": "<DB_PASSWORD>",
"DB_DRIVER": "<DB_DRIVER>"
}
}
}
}~/.gemini/settings.json
{
"mcpServers": {
"dbmcp-server-for-databases": {
"command": "java",
"args": [
"-jar",
"target/dbmcp-1.0.0.jar"
],
"env": {
"DB_URL": "<DB_URL>",
"DB_USER": "<DB_USER>",
"DB_PASSWORD": "<DB_PASSWORD>",
"DB_DRIVER": "<DB_DRIVER>"
}
}
}
}claude_desktop_config.json
{
"mcpServers": {
"dbmcp-server-for-databases": {
"command": "java",
"args": [
"-jar",
"target/dbmcp-1.0.0.jar"
],
"env": {
"DB_URL": "<DB_URL>",
"DB_USER": "<DB_USER>",
"DB_PASSWORD": "<DB_PASSWORD>",
"DB_DRIVER": "<DB_DRIVER>"
}
}
}
}.trae/mcp.json
{
"mcpServers": {
"dbmcp-server-for-databases": {
"command": "java",
"args": [
"-jar",
"target/dbmcp-1.0.0.jar"
],
"env": {
"DB_URL": "<DB_URL>",
"DB_USER": "<DB_USER>",
"DB_PASSWORD": "<DB_PASSWORD>",
"DB_DRIVER": "<DB_DRIVER>"
}
}
}
}Environment variables
DB_URLDB_USERDB_PASSWORDDB_DRIVER
Replace the placeholders with your own credentials and keep them out of version control.