Get started

Snowflake for AI agents

Snowflake is a cloud data warehouse teams use to run SQL analytics at scale, sharing datasets securely across warehouses and cloud providers. Connect it once through Arc0, and your agent, or Claude, ChatGPT and Cursor, can use it through one MCP endpoint, limited to what each user approved.

Connect SnowflakeSee the 17 actions ↓
Databases and spreadsheetsOAuth 2.0MCP + RESTsnowflake.com
AUDIT LOG · SNOWFLAKEPOLICY: acme-support
09:41:07 · claude · u_8f2read
snowflake.get_status_rollup
Get Status Rollup✓ allowed · 212ms
09:41:08 · claude · u_8f2read
snowflake.show_tables
Show Tables✓ allowed · 164ms
09:41:09 · claude · u_8f2write
snowflake.execute_sql
Execute SQL✓ approved · approved by user
09:41:12 · claude · u_8f2destructive
snowflake.cancel_statement_execution
Cancel Statement Execution✕ blocked · policy: deny
EVERY SNOWFLAKE CALL, ON THE RECORD
01 · USE CASES

What agents do in Snowflake.

01

Preview a table before querying

Show a table's schema and sample rows before running a full query against a production warehouse.

02

Run a read-only analytics query

Execute a SQL statement scoped to a read-only role, returning results without touching the underlying tables.

03

Confirm before dropping a warehouse

Check a warehouse's usage before dropping it, since removing it stops every query that depends on it.

02 · ACTIONS

17 Snowflake actions, graded by risk.

Every Snowflake action is tagged read, write or destructive, so one policy covers the whole app and new actions inherit the right default.

read

13

Look things up. Allowed by default.

  • snowflake.get_status_rollup
    Get Status Rollup
  • snowflake.get_status_summary
    Get Status Summary
  • snowflake.get_component_status
    Get Component Status
  • snowflake.get_unresolved_incidents
    Get Unresolved Incidents
  • snowflake.get_all_scheduled_maintenances
    Get All Scheduled Maintenances
  • snowflake.get_active_scheduled_maintenances
    Get Active Scheduled Maintenances
  • snowflake.get_upcoming_scheduled_maintenances
    Get Upcoming Scheduled Maintenances
  • snowflake.show_tables
    Show Tables
  • snowflake.show_schemas
    Show Schemas
  • snowflake.show_databases
    Show Databases
  • snowflake.validate_credential
    Validate Credential
  • snowflake.check_statement_status
    Check Statement Status
  • snowflake.fetch_catalog_integration
    Fetch Catalog Integration

write

2

Create and change things. Allow, or ask the user first.

  • snowflake.execute_sql
    Execute SQL
  • snowflake.submit_sql_statement
    Submit SQL Statement (Deprecated)

destructive

2

Delete, cancel or archive. Ask first, or deny outright.

  • snowflake.cancel_statement_execution
    Cancel Statement Execution
  • snowflake.drop_warehouse
    Drop Warehouse
03 · HOW IT WORKS

Snowflake in three steps.

  1. 01Your users connect SnowflakeThey sign in to Snowflake on Arc0 Connect, under your brand, and approve the access you ask for.
  2. 02You set the rulesReads run, writes like “execute SQL” can wait for the user, and “cancel Statement Execution” can be denied outright.
  3. 03Any agent can actYour agent calls Snowflake through the Arc0 SDK or MCP, and so can Claude, ChatGPT and Cursor. Every call lands on the audit log.
POLICY.TS
await arc0.policies.set('snowflake', {
  read: 'allow',
  write: 'ask',        // execute_sql
  destructive: 'deny',  // cancel_statement_execution
})

# Claude Code: the same connection, one URL
$ claude mcp add --transport http arc0 \
    https://mcp.arc0.ai/u/u_8f2
04 · AUTH AND DATA

How Snowflake connects.

Users sign in to Snowflake on Arc0 Connect and approve the scopes you request. Build with Arc0’s Snowflake OAuth app, or bring your own so the Snowflake consent screen names you. Tokens refresh automatically, and you can export them whenever you want.

The same Snowflake connection serves your agent over MCP and your own backend over REST and the proxy, so a user connects once. How Arc0 handles credentials →

AUTH
OAuth 2.0
CREDENTIALS
Per-tenant encrypted vault
MODEL SEES
Results only, never credentials
AUDIT LOG
Every call, on every plan
05 · WORKS WITH

Use Snowflake from any agent.

Claude
ChatGPT
Cursor
Codex
VS Code
OpenAI Agents SDK
Claude Agent SDK
Vercel AI SDK
Mastra
LangGraph
06 · RELATED

More databases and spreadsheets apps.

Google Sheets58 actionsExcel55 actionsAnyDB9 actionsGigasheet150 actionsNeon110 actionsGoogle BigQuery63 actionsNocoDB28 actionsPrisma22 actions
ALL DATABASES AND SPREADSHEETS APPS →
07 · FAQ

Snowflake and Arc0, answered.

Q01

Can I use Snowflake with Claude, ChatGPT or Cursor?

Yes. Connect Snowflake to Arc0 once, then add your Arc0 MCP URL to Claude, ChatGPT, Cursor, Claude Code or any other remote-MCP client. Each assistant only gets the Snowflake actions you allow.

Q02

How do users connect Snowflake?

Users sign in to Snowflake on Arc0 Connect and approve the scopes you request. Build with Arc0’s Snowflake OAuth app, or bring your own so the Snowflake consent screen names you. Tokens refresh automatically, and you can export them whenever you want.

Q03

Which Snowflake actions can my agent take?

17 in total: 13 read, 2 write and 2 destructive, such as “execute SQL”. Your policies decide which of them each agent may call.

Q04

Can I stop my agent from deleting things in Snowflake?

Yes. Actions like “cancel Statement Execution” are graded destructive. Set destructive actions to deny, or to ask so the user approves each one, and blocked calls still show up on the audit log.

Q05

Can my own backend call Snowflake too?

Yes. The same Snowflake connection is available over REST and through the Arc0 proxy, so your product and your agent share one connection per user.

Get started

Plug Snowflake into your agent.

Your users connect Snowflake once, under your brand. Your agent gets 17 actions behind your policies, with every call on the record.

Connect SnowflakeBrowse all apps →

Free to build · MCP + REST · Audit log on every plan