Spreadsheet DB for VS Code

io.github.manddarinshop/spreadsheet-db-mcp

SQLite-authoritative entity database with an async Google Sheets projection for AI agents.

client:VS Code transport:stdio runtime:npm

Install Spreadsheet DB in VS Code

.vscode/mcp.json

{
  "inputs": [
    {
      "type": "promptString",
      "id": "hikoutei-mcp-config",
      "description": "HIKOUTEI_MCP_CONFIG",
      "password": true
    },
    {
      "type": "promptString",
      "id": "hikoutei-sync-spreadsheet-url",
      "description": "HIKOUTEI_SYNC_SPREADSHEET_URL",
      "password": true
    },
    {
      "type": "promptString",
      "id": "google-application-credentials",
      "description": "GOOGLE_APPLICATION_CREDENTIALS",
      "password": true
    }
  ],
  "servers": {
    "spreadsheet-db-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "spreadsheet-db-mcp"
      ],
      "env": {
        "HIKOUTEI_MCP_CONFIG": "${input:hikoutei-mcp-config}",
        "HIKOUTEI_SYNC_SPREADSHEET_URL": "${input:hikoutei-sync-spreadsheet-url}",
        "GOOGLE_APPLICATION_CREDENTIALS": "${input:google-application-credentials}"
      }
    }
  }
}

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

Spreadsheet DB in other clients

Spreadsheet DB MCP server