Nunc Analytics MCPZero-Copy SQL & GraphQL + Studio

Query Snowflake, Postgres, BigQuery, and SaaS in place — and mint live Data Studio decks.

Connect external AI assistants directly to Nunc's federated GraphQL and SQL analytics layer without copying warehouse tables. Stage 4 AST guards block destructive SQL, Guardian masks raw PII, and one call mints interactive dashboards on studio.nunc.cloud.

Streamable HTTP EndpointOAuth 2.1 + Guardian
Connect from Claude, ChatGPT, Gemini, Cursor, or VS Code
https://api.nunc.cloud/mcp/analytics
0 Copies
query Snowflake, Postgres & BigQuery in place
AST Guard
blocks DROP/DELETE, UNION & catalog exploits
5 Tools
schema, query, insights, action & Studio report
1-Click
handoff to live dashboards, 16:9 decks & sheets
https://console.nunc.cloud/integrations?tab=data-scoping
Nunc Console Build › Integrations › Data & Warehouses panel showing configured table and schema access across Snowflake, Postgres, and BigQuery alongside per-agent and external user row-scoping SQL predicates
Your data stays putyour instancePostgresyour host · read-onlysql · tenant-scopedSELECT donor, amountFROM giftsWHERE fy = 2025✓ host allow-listed · scope guard3 rowsAda Byron⟦PII:NAME#1⟧$1,200Grace Hopper⟦PII:NAME#2⟧$850Alan Turing⟦PII:NAME#3⟧$2,400Guardiantokenize · reversible · the map stays insideModelstatelesssees tokensnever namesraw rows stay inside · tokens go out and come back
Interactive Execution & Schema Inspector

Inspect live wire traces and registered tool schemas.

Nunc Analytics MCP
01 · Caller Intentnunc_analytics_query

“Compare Q3 net ARR and 45-day renewal contraction risk across enterprise segments.”

Inbound tools/callOAuth 2.1 Verified
{
  "name": "nunc_analytics_query",
  "arguments": {
    "query": "query Q3Retention($quarter: String!) { arrBySegment(quarter: $quarter) { segment netArrUsd ndrPct } atRiskRenewals(daysOut: 45) { accountName arrUsd seatDeltaPct } }",
    "variables": { "quarter": "2026-Q3" },
    "effort": "balanced"
  }
}
02 · Stage 4 · GraphQL Depth/AST Guard + Row PolicyVERIFIED · READ-ONLY

Validated query AST depth (2) and alias count; enforced caller's Enterprise Finance row policy across Snowflake + Salesforce.

Zero-copy federated join in 148ms
03 · Sanitized MCP Response200 OK
{
  "executionMs": 148,
  "data": {
    "arrBySegment": [
      { "segment": "Enterprise", "netArrUsd": 48600000, "ndrPct": 116.2 }
    ],
    "atRiskRenewals": [
      { "accountName": "Helios Energy Corp", "arrUsd": 420000, "seatDeltaPct": -14.1 }
    ]
  }
}
01 · Zero-Copy Federated Execution
Join cloud warehouses and operational SaaS without an ETL tax

Execute governed SQL and federated GraphQL across Snowflake, Postgres, BigQuery, DuckDB, Parquet/CSV, and SaaS connectors while respecting row-level access policies.

02 · Stage 4 AST SQL & GraphQL Firewall
Refuse destructive DDL/DML, tautologies, and schema recon before dispatch

Every generated query is parsed prior to database dispatch. Stacked statements, DROP/TRUNCATE/ALTER mutations, UNION credential extraction, and runaway recursive CTEs fail closed.

03 · Irreversible PII Redaction for External LLMs
Aggregate freely while keeping raw customer PII out of external prompts

External MCP clients receive exact revenue, cohort, and variance aggregates while individual SSNs, emails, and account numbers are masked as [REDACTED:TYPE].

04 · Seamless Handoff to Nunc Data Studio
Turn chat answers into board-ready 16:9 decks and live dashboards

Calling nunc_analytics_create_report compiles a live interactive artifact at studio.nunc.cloud/view/:id where authorized staff can drill down with reversible ⟦PII⟧ tokens.

One-Click Client Setup

Install Nunc Analytics MCP in your AI client

Connect in under 60 seconds
OAuth 2.1 + company SSO discovery is built in — no API keys to mint or rotate for interactive sessions.
Streamable HTTP · OAuth 2.1
1. Choose Nunc MCP endpoint
2. Choose your AI client

Claude.ai & Claude Desktop

Open Claude Connectors
  1. Open Settings → Connectors → Add Custom Connector in Claude.ai or Claude Desktop.
  2. Paste the URL below and click Connect.
  3. Sign in with your Nunc / company SSO account and select your organization on the consent screen.
Nunc Analytics MCP (Data Studio & Lakehouse)
https://api.nunc.cloud/mcp/analytics

Claude Code CLI

Register the remote HTTP server in Claude Code, then run /mcp inside a session to complete browser SSO:

claude mcp add --transport http nunc-analytics "https://api.nunc.cloud/mcp/analytics"

Deploying across an organization? See Claude MCP enterprise lock for MDM-managed managed-mcp.json provisioning.

Launch your private AI in minutes — without giving up your data.

Start a 14-day isolated Core Platform trial with $0 due today, inspect Guardian live, or speak with our team about a custom deployment.