MCBMSMCP Framework

Framework

MCP Framework

BMS Agent · bq-mcp · MCBMS — access-controlled MCP tools over three BigQuery datasets.

Data source
bq-mcp · Cloud Run
mc-bms2Master Concept · ← BMS2 MySQL (CDC)
/mcp/bms2Master Concept tools
fc-bms2Finda Cloud mirror · ← Finda BMS
/mcp/fc-bms2Finda Cloud tools
Google BillingGCP/GMP billing & cost export
/mcp · Billingbilling & cost tools
CMSBigQuery dataset · content data
/mcp/cmsCMS tools
NetSuitenative NetSuite ERP · not BigQuery
NetSuite MCPnative · separate MCP
Predefined toolscurated, parameterized (revenue, cost, P&L…)
Composable & free-form SQLbms2_query · run_sql (admin)
Claude Marketplace Pluginbms2@zorskill · Claude Code skill
IAM access · Google Grouprun.invoker on the Cloud Run — gates the MCP & tools
to be developed
⇄
BMS Agent · Cloud Run
Claude Sonnet 5 / Opus 5direct Anthropic API · default
Gemini 2.5 Pro / 3.6 Flashrun_sql: Pro yes · Flash no
System prompt & groundingteaches the LLM how to use the tools
JWT auth · RS256MCBMS signs (private) · agent verifies (public)
↕
MCBMS · SiteGround
Google loginsign in with Google — guards the app (OAuth)
Granular permissionsscoped by module & data view — agent.use / .mc / .finda
Chat Widgetask BMS in plain English
Model pickerClaude · Gemini
Dataset pickerMC · Finda · Billing
Chartstrend · cost-by-customer · ageing

Access architecture

Three ways in — one shared set of tools

Developers & Skills
bms2 skill · dashboardsClaude Code / CLI · ad-hoc
run.invoker · Google ID token
▼ direct
Coworkers · Claude Desktop
Custom connectorconnect by URL
▼
mc-mcp gateway NEWmcp.mcai.dev · standard MCP + OAuth
Google login @hkmci.com · per-dataset policy
▼
BMS Agent · MCBMS
Chat widgetask BMS in plain English
▼
BMS Agent · Cloud RunClaude · Gemini
service account · run.invoker
▼
all three call the same tools
4 private MCP servers · Cloud Run · Google Toolbox · asia-east2
bq-mc-bms2/mcp/bms2 · 15 tools
bq-fc-bms2/mcp/fc-bms2 · 13 tools
bq-gcp-billing/mcp/billing · 6 tools
bq-mc-cms/mcp/mc-cms · 9 tools
↓
BigQuery — read-only mirrors
mc-bms2Master Concept
fc-bms2Finda Cloud
billingGCP cost
cmsCloud reseller