MCP Toolbox for Databases for VS Code: Setup & Config

What you can do with MCP Toolbox for Databases in VS Code

Use one database-tool framework for exploratory assistants and deliberately scoped production queries.

• Run database queries through prebuilt MCP tools.
• Define parameterized custom operations for production agents.
• Group database tools into task-specific toolsets.

Before you start: MCP Toolbox for Databases in VS Code

• An MCP-compatible client
• npx for this execution method
• A PostgreSQL database for this example
• Database-specific connection settings from the prebuilt reference

This is the README's prebuilt PostgreSQL example. Exact database connection environment variables are not stated in the supplied README, so none are invented here. Binaries and containers are recommended for a more standard installation. The repository is now named mcp-toolbox.

MCP Toolbox for Databases VS Code configuration

1. Choose VS Code configuration scope

   For MCP Toolbox for Databases, open Workspace: .vscode/mcp.json. Merge into servers; preserve existing inputs.

2. Add MCP Toolbox for Databases to VS Code

   Use the genai-toolbox entry below in servers. Keep MCP Toolbox for Databases's documented stdio connection fields and your other VS Code entries.

3. Check MCP Toolbox for Databases in VS Code

   MCP Toolbox for Databases: Start in VS Code’s MCP controls; inspect output and trust prompts.

{
  "servers": {
    "genai-toolbox": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@toolbox-sdk/server",
        "--prebuilt=postgres",
        "--stdio"
      ],
      "env": {}
    }
  }
}

MCP Toolbox for Databases tools available to VS Code

MCP Toolbox for Databases's stored tool list documents 2 tools; compare it with VS Code's connected tool list, because the stored list is not a live check.

list_tables

Look for list_tables among VS Code's agent-mode tools after starting MCP Toolbox for Databases through the MCP controls.

Discover database tables through a prebuilt generic tool.

execute_sql

Look for execute_sql among VS Code's agent-mode tools after starting MCP Toolbox for Databases through the MCP controls.

MCP Toolbox for Databases: full stored tool descriptions

Troubleshooting MCP Toolbox for Databases in VS Code

• Make npx @toolbox-sdk/server (Node.js/npm) available in the workspace, container, or remote environment hosting MCP Toolbox for Databases. Start through VS Code's MCP controls; inspect output and trust prompts.
• MCP Toolbox for Databases uses stdio here: VS Code must keep the configured process running; protocol output belongs on stdout and diagnostics on stderr.
• Known limitation: Connection configuration is database-specific and requires separate reference details.
• Known limitation: The README characterizes npm execution as convenience-oriented rather than the most reliable installation.
• Known limitation: Custom tools require source and query definitions.
• General VS Code troubleshooting lives in the /clients/vscode guide.

Frequently asked questions