Docs/Warehouses & Table Scoping
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 NameModeWhat It Does
nunc_analytics_schemaRead-onlyLists 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_queryRead-onlyValidates 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_insightsRead-onlySurfaces proactive KPI anomalies, period-over-period variance drivers, and recent metric shifts for your workspace.
nunc_analytics_create_reportWorkspace ArtifactPublishes 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_actionApproval-GatedStages 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.