Skip to content
mcp/harbor
VS Code

SQL for VS Code

io.github.abhishekkumar2021/sql

Read-only SQL querying + schema introspection over Postgres & SQLite, with a gated write mode.

client:VS Code transport:stdio runtime:npm

Install SQL in VS Code

.vscode/mcp.json 

{
  "inputs": [
    {
      "type": "promptString",
      "id": "db-conn-default",
      "description": "DB_CONN_default",
      "password": true
    },
    {
      "type": "promptString",
      "id": "db-writable",
      "description": "DB_WRITABLE",
      "password": true
    }
  ],
  "servers": {
    "sql": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "@abhishekmcp/sql"
      ],
      "env": {
        "DB_CONN_default": "${input:db-conn-default}",
        "DB_WRITABLE": "${input:db-writable}"
      }
    }
  }
}

VS Code prompts for each input the first time the server starts, so no secret is written to the file. VS Code docs

SQL in other clients

SQL MCP server