https://api.nunc.cloud/mcp/analyticsZero-Copy Warehouse & SaaS Analytics
Analytics MCP
The Analytics MCP endpoint exposes five purpose-built tools for schema discovery, read-only warehouse queries, anomaly insights, governed action proposals, and instant Data Studio Web dashboards and 16:9 decks — directly inside Claude, ChatGPT, Gemini, Cursor, or VS Code.
The five nunc_analytics_* tools
| Tool Name | Mode | What It Does |
|---|---|---|
| nunc_analytics_schema | Read-only | Lists authorized warehouse tables, federated SaaS views, column types, semantic metric definitions, and join keys so models write accurate SQL on the first try. |
| nunc_analytics_query | Read-only | Validates that SQL is strictly read-only, executes zero-copy against Snowflake, BigQuery, PostgreSQL, or federated SaaS datasets, masks PII via Guardian, and returns structured rows plus summary statistics. |
| nunc_analytics_insights | Read-only | Surfaces proactive KPI anomalies, period-over-period variance drivers, and recent metric shifts for your workspace. |
| nunc_analytics_create_report | Workspace Artifact | Publishes an interactive Dashboard, 16:9 Executive Deck, Spreadsheet, or Brief in Data Studio Web and returns a shareable studio.nunc.cloud deep link. |
| nunc_analytics_propose_action | Approval-Gated | Stages a governed write-back proposal (e.g., CRM stage update, finance review task, Slack alert) that awaits explicit human approval in Data Studio or Console before executing. |
Typical analyst & executive workflow
1. Ask in Claude or ChatGPT
“Compare net dollar retention by enterprise cohort over the last 4 quarters and identify accounts with usage drops over 25%.” The client calls
nunc_analytics_schema and nunc_analytics_query.2. Open as a live 16:9 deck
“Turn this into an executive board deck.” The client calls
nunc_analytics_create_report and returns a governed studio.nunc.cloud link ready for Presenter Mode.3. Approve follow-up actions
“Flag the top 5 at-risk renewals in Salesforce.”
nunc_analytics_propose_action queues an approval preview for the account owner — never mutating records silently.Built-in analytical guardrails
Strict read-only SQL parser: INSERT, UPDATE, DELETE, DROP, ALTER, and multi-statement batches are rejected before reaching your warehouse.
Row caps & query timeouts: Automatic result limits and execution timeouts protect warehouse compute credits.
Outbound PII redaction: External MCP clients receive [REDACTED:TYPE] masks for customer PII columns according to your Console Guardian policy.