MCP DBS

Name: MCP DBS
Author: cuongtl1992

cuongtl1992

Get started Repository

Connects LLMs to SQL databases including SQLite, SQL Server and PostgreSQL to run queries.

Setup

Choose your client, copy the config, then fill in any required environment variables.

Add to Cursor Add to VS Code

claude mcp add dbs --env MCP_MSSQL_SERVER='<MCP_MSSQL_SERVER>' --env MCP_MSSQL_PORT='<MCP_MSSQL_PORT>' --env MCP_MSSQL_DATABASE='<MCP_MSSQL_DATABASE>' --env MCP_MSSQL_USER='<MCP_MSSQL_USER>' --env MCP_MSSQL_PASSWORD='<MCP_MSSQL_PASSWORD>' --env MCP_MSSQL_ENCRYPT='<MCP_MSSQL_ENCRYPT>' --env MCP_MSSQL_TRUST_SERVER_CERTIFICATE='<MCP_MSSQL_TRUST_SERVER_CERTIFICATE>' --env MCP_MONGODB_URI='<MCP_MONGODB_URI>' --env MCP_MONGODB_DATABASE='<MCP_MONGODB_DATABASE>' -- npx -y mcp-dbs@1.0.4 --stdio

~/.codex/config.toml

[mcp_servers.dbs]
command = "npx"
args = ["-y", "mcp-dbs@1.0.4", "--stdio"]
env = { MCP_MSSQL_SERVER = "<MCP_MSSQL_SERVER>", MCP_MSSQL_PORT = "<MCP_MSSQL_PORT>", MCP_MSSQL_DATABASE = "<MCP_MSSQL_DATABASE>", MCP_MSSQL_USER = "<MCP_MSSQL_USER>", MCP_MSSQL_PASSWORD = "<MCP_MSSQL_PASSWORD>", MCP_MSSQL_ENCRYPT = "<MCP_MSSQL_ENCRYPT>", MCP_MSSQL_TRUST_SERVER_CERTIFICATE = "<MCP_MSSQL_TRUST_SERVER_CERTIFICATE>", MCP_MONGODB_URI = "<MCP_MONGODB_URI>", MCP_MONGODB_DATABASE = "<MCP_MONGODB_DATABASE>" }

# codex mcp add dbs --env MCP_MSSQL_SERVER='<MCP_MSSQL_SERVER>' --env MCP_MSSQL_PORT='<MCP_MSSQL_PORT>' --env MCP_MSSQL_DATABASE='<MCP_MSSQL_DATABASE>' --env MCP_MSSQL_USER='<MCP_MSSQL_USER>' --env MCP_MSSQL_PASSWORD='<MCP_MSSQL_PASSWORD>' --env MCP_MSSQL_ENCRYPT='<MCP_MSSQL_ENCRYPT>' --env MCP_MSSQL_TRUST_SERVER_CERTIFICATE='<MCP_MSSQL_TRUST_SERVER_CERTIFICATE>' --env MCP_MONGODB_URI='<MCP_MONGODB_URI>' --env MCP_MONGODB_DATABASE='<MCP_MONGODB_DATABASE>' -- npx -y mcp-dbs@1.0.4 --stdio

~/.cursor/mcp.json

{
  "mcpServers": {
    "dbs": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dbs@1.0.4",
        "--stdio"
      ],
      "env": {
        "MCP_MSSQL_SERVER": "<MCP_MSSQL_SERVER>",
        "MCP_MSSQL_PORT": "<MCP_MSSQL_PORT>",
        "MCP_MSSQL_DATABASE": "<MCP_MSSQL_DATABASE>",
        "MCP_MSSQL_USER": "<MCP_MSSQL_USER>",
        "MCP_MSSQL_PASSWORD": "<MCP_MSSQL_PASSWORD>",
        "MCP_MSSQL_ENCRYPT": "<MCP_MSSQL_ENCRYPT>",
        "MCP_MSSQL_TRUST_SERVER_CERTIFICATE": "<MCP_MSSQL_TRUST_SERVER_CERTIFICATE>",
        "MCP_MONGODB_URI": "<MCP_MONGODB_URI>",
        "MCP_MONGODB_DATABASE": "<MCP_MONGODB_DATABASE>"
      }
    }
  }
}

.vscode/mcp.json

{
  "servers": {
    "dbs": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "mcp-dbs@1.0.4",
        "--stdio"
      ],
      "env": {
        "MCP_MSSQL_SERVER": "<MCP_MSSQL_SERVER>",
        "MCP_MSSQL_PORT": "<MCP_MSSQL_PORT>",
        "MCP_MSSQL_DATABASE": "<MCP_MSSQL_DATABASE>",
        "MCP_MSSQL_USER": "<MCP_MSSQL_USER>",
        "MCP_MSSQL_PASSWORD": "<MCP_MSSQL_PASSWORD>",
        "MCP_MSSQL_ENCRYPT": "<MCP_MSSQL_ENCRYPT>",
        "MCP_MSSQL_TRUST_SERVER_CERTIFICATE": "<MCP_MSSQL_TRUST_SERVER_CERTIFICATE>",
        "MCP_MONGODB_URI": "<MCP_MONGODB_URI>",
        "MCP_MONGODB_DATABASE": "<MCP_MONGODB_DATABASE>"
      }
    }
  }
}

~/.gemini/settings.json

{
  "mcpServers": {
    "dbs": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dbs@1.0.4",
        "--stdio"
      ],
      "env": {
        "MCP_MSSQL_SERVER": "<MCP_MSSQL_SERVER>",
        "MCP_MSSQL_PORT": "<MCP_MSSQL_PORT>",
        "MCP_MSSQL_DATABASE": "<MCP_MSSQL_DATABASE>",
        "MCP_MSSQL_USER": "<MCP_MSSQL_USER>",
        "MCP_MSSQL_PASSWORD": "<MCP_MSSQL_PASSWORD>",
        "MCP_MSSQL_ENCRYPT": "<MCP_MSSQL_ENCRYPT>",
        "MCP_MSSQL_TRUST_SERVER_CERTIFICATE": "<MCP_MSSQL_TRUST_SERVER_CERTIFICATE>",
        "MCP_MONGODB_URI": "<MCP_MONGODB_URI>",
        "MCP_MONGODB_DATABASE": "<MCP_MONGODB_DATABASE>"
      }
    }
  }
}

claude_desktop_config.json

{
  "mcpServers": {
    "dbs": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dbs@1.0.4",
        "--stdio"
      ],
      "env": {
        "MCP_MSSQL_SERVER": "<MCP_MSSQL_SERVER>",
        "MCP_MSSQL_PORT": "<MCP_MSSQL_PORT>",
        "MCP_MSSQL_DATABASE": "<MCP_MSSQL_DATABASE>",
        "MCP_MSSQL_USER": "<MCP_MSSQL_USER>",
        "MCP_MSSQL_PASSWORD": "<MCP_MSSQL_PASSWORD>",
        "MCP_MSSQL_ENCRYPT": "<MCP_MSSQL_ENCRYPT>",
        "MCP_MSSQL_TRUST_SERVER_CERTIFICATE": "<MCP_MSSQL_TRUST_SERVER_CERTIFICATE>",
        "MCP_MONGODB_URI": "<MCP_MONGODB_URI>",
        "MCP_MONGODB_DATABASE": "<MCP_MONGODB_DATABASE>"
      }
    }
  }
}

.trae/mcp.json

{
  "mcpServers": {
    "dbs": {
      "command": "npx",
      "args": [
        "-y",
        "mcp-dbs@1.0.4",
        "--stdio"
      ],
      "env": {
        "MCP_MSSQL_SERVER": "<MCP_MSSQL_SERVER>",
        "MCP_MSSQL_PORT": "<MCP_MSSQL_PORT>",
        "MCP_MSSQL_DATABASE": "<MCP_MSSQL_DATABASE>",
        "MCP_MSSQL_USER": "<MCP_MSSQL_USER>",
        "MCP_MSSQL_PASSWORD": "<MCP_MSSQL_PASSWORD>",
        "MCP_MSSQL_ENCRYPT": "<MCP_MSSQL_ENCRYPT>",
        "MCP_MSSQL_TRUST_SERVER_CERTIFICATE": "<MCP_MSSQL_TRUST_SERVER_CERTIFICATE>",
        "MCP_MONGODB_URI": "<MCP_MONGODB_URI>",
        "MCP_MONGODB_DATABASE": "<MCP_MONGODB_DATABASE>"
      }
    }
  }
}

Environment variables

MCP_MSSQL_SERVER
MCP_MSSQL_PORT
MCP_MSSQL_DATABASE
MCP_MSSQL_USER
MCP_MSSQL_PASSWORD
MCP_MSSQL_ENCRYPT
MCP_MSSQL_TRUST_SERVER_CERTIFICATE
MCP_MONGODB_URI
MCP_MONGODB_DATABASE

Replace the placeholders with your own credentials and keep them out of version control.

Setup

Environment variables

Related