Files · Vertex AI MCP Server for SMB Data Analytics

# Vertex AI MCP Server for SMB Data Analytics
 
A multi-tenant MCP server that lets small business customers ask analytics questions in natural language — powered by Vertex AI and BigQuery.
 
## Architecture
 
Express server + MCP SDK + `@reaatech/*` packages + Vertex AI + BigQuery.
 
## Prerequisites
 
- Node 22+, pnpm
- GCP project with BigQuery and Vertex AI enabled
 
## Setup
 
```bash
pnpm install
pnpm dev
```
 
## MCP Tools
 
- **analytics_query** — Natural-language analytics question → SQL → BigQuery → explanation
- **upload_spreadsheet** — Upload XLSX data for analysis
 
## Admin Routes
 
- `GET /admin/summary` — Cost summary per tenant
- `GET /admin/health` — Server health
- `GET /admin/config` — Safe config (log level, port)
 
## Health
 
- `GET /api/health` — Health check endpoint
 
## License
 
MIT — see [LICENSE](./LICENSE).