Antarestar Live — MCP Server (for Hermes)

MCP read-only that gives Hermes (AI agent) access to Antarestar Live Dashboard data. It pulls from the same Google Sheet as the dashboard, using identical column mapping — so the numbers Hermes reads = the numbers shown on the dashboard.

Available Tools

All dates in YYYY-MM-DD format. Read-only — Hermes cannot modify data.

Related MCP server: SEOAnalytics Read MCP

1. Local setup & test

npm install
npm run smoke      # tes lapisan data ke sheet live (harus keluar angka)
npm run typecheck  # cek TypeScript

Test as MCP stdio (for local Hermes / MCP Inspector):

npx @modelcontextprotocol/inspector npx tsx src/stdio.ts

2. Deploy to Vercel (remote HTTP — for Hermes cloud)

npm i -g vercel      # kalau belum
vercel               # deploy (ikutin promptnya)
vercel --prod        # deploy production

Then in Vercel → Project → Settings → Environment Variables, set:

• MCP_API_KEY = long secret key (Hermes must send this)

• (optional) SHEET_ID if you want to override the spreadsheet

The MCP endpoint:

https://<project>.vercel.app/api/mcp      (atau /mcp)

3. Connect Hermes

Hermes (MCP client) connects via Streamable HTTP to the URL above, with header:

x-api-key: <MCP_API_KEY>

Example MCP config (common MCP client format):

{
  "mcpServers": {
    "antarestar-live": {
      "url": "https://<project>.vercel.app/api/mcp",
      "headers": { "x-api-key": "<MCP_API_KEY>" }
    }
  }
}

Quick check of live endpoint (GET):

curl -H "x-api-key: <MCP_API_KEY>" https://<project>.vercel.app/api/mcp

Architecture

Hermes (AI) ──MCP/HTTP──► api/mcp.ts ──► src/tools.ts ──► src/sheet.ts ──CSV──► Google Sheet
                          (Vercel)        (5 tools)      (parse + calcO)        (RAW Shopee/Tiktok, Data)

• src/csv.ts — parser & number/date conversion (ported from dashboard).

• src/sheet.ts — fetch + parse + aggregation (60-second cache per instance).

• src/tools.ts — definition of 5 MCP tools.

• api/mcp.ts — Streamable HTTP endpoint + API key auth (Vercel).

• src/stdio.ts — local mode (stdio).

Notes

• Read-only: no write tools. Safe.

• Data follows the sheet — as soon as the dashboard/importer adds data, MCP automatically stays fresh (60s cache).

• Want to add a tool (e.g. checkpoint_daily_live, daily_report_host)? Just add it in src/tools.ts + its tab parser in src/sheet.ts.