Spreadsheet DB MCP Server

Name: Spreadsheet DB MCP Server
Author: io.github.ManddarinShop

io.github.ManddarinShop/spreadsheet-db-mcp

Repository Registry

What is the Spreadsheet DB MCP server?

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

How to install Spreadsheet DB

Copy-paste configuration for popular MCP clients.

transport: stdio

Config generated by PluginBench — verify against the source before use.

Environment / auth

HIKOUTEI_MCP_CONFIG
Path to the entity configuration file (hikoutei.config.json). Optional; the server also looks for ./hikoutei.config.json in the working directory.
HIKOUTEI_SYNC_SPREADSHEET_URL
Google Sheets spreadsheet URL. Absent means local-only mode (no Google contact); when set, the Google Sheets projection is enabled and GOOGLE_APPLICATION_CREDENTIALS must also be set.
GOOGLE_APPLICATION_CREDENTIALS
secret
Path to a Google service-account key file (JSON) used for the Sheets projection. Only needed when HIKOUTEI_SYNC_SPREADSHEET_URL is set.

Claude Desktop

~/Library/Application Support/Claude/claude_desktop_config.json

{
  "mcpServers": {
    "spreadsheet-db-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "spreadsheet-db-mcp"
      ],
      "env": {
        "HIKOUTEI_MCP_CONFIG": "<YOUR_HIKOUTEI_MCP_CONFIG>",
        "HIKOUTEI_SYNC_SPREADSHEET_URL": "<YOUR_HIKOUTEI_SYNC_SPREADSHEET_URL>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<YOUR_GOOGLE_APPLICATION_CREDENTIALS>"
      }
    }
  }
}

Cursor

~/.cursor/mcp.json

{
  "mcpServers": {
    "spreadsheet-db-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "spreadsheet-db-mcp"
      ],
      "env": {
        "HIKOUTEI_MCP_CONFIG": "<YOUR_HIKOUTEI_MCP_CONFIG>",
        "HIKOUTEI_SYNC_SPREADSHEET_URL": "<YOUR_HIKOUTEI_SYNC_SPREADSHEET_URL>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<YOUR_GOOGLE_APPLICATION_CREDENTIALS>"
      }
    }
  }
}

Windsurf

~/.codeium/windsurf/mcp_config.json

{
  "mcpServers": {
    "spreadsheet-db-mcp": {
      "command": "npx",
      "args": [
        "-y",
        "spreadsheet-db-mcp"
      ],
      "env": {
        "HIKOUTEI_MCP_CONFIG": "<YOUR_HIKOUTEI_MCP_CONFIG>",
        "HIKOUTEI_SYNC_SPREADSHEET_URL": "<YOUR_HIKOUTEI_SYNC_SPREADSHEET_URL>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<YOUR_GOOGLE_APPLICATION_CREDENTIALS>"
      }
    }
  }
}

VS Code

.vscode/mcp.json

{
  "servers": {
    "spreadsheet-db-mcp": {
      "type": "stdio",
      "command": "npx",
      "args": [
        "-y",
        "spreadsheet-db-mcp"
      ],
      "env": {
        "HIKOUTEI_MCP_CONFIG": "<YOUR_HIKOUTEI_MCP_CONFIG>",
        "HIKOUTEI_SYNC_SPREADSHEET_URL": "<YOUR_HIKOUTEI_SYNC_SPREADSHEET_URL>",
        "GOOGLE_APPLICATION_CREDENTIALS": "<YOUR_GOOGLE_APPLICATION_CREDENTIALS>"
      }
    }
  }
}

Claude Code

claude mcp add spreadsheet-db-mcp --env HIKOUTEI_MCP_CONFIG=<YOUR_HIKOUTEI_MCP_CONFIG> --env HIKOUTEI_SYNC_SPREADSHEET_URL=<YOUR_HIKOUTEI_SYNC_SPREADSHEET_URL> --env GOOGLE_APPLICATION_CREDENTIALS=<YOUR_GOOGLE_APPLICATION_CREDENTIALS> -- npx -y spreadsheet-db-mcp