Snowflake Basic for AI agents
Snowflake Basic connects to the same cloud data warehouse through simple username-and-password access, for teams that want SQL queries without OAuth setup. 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.
What agents do in Snowflake Basic.
List databases before connecting a report
Show the databases and schemas available on an account before pointing a dashboard at one.
Describe a table's columns
Describe a table's columns and types so an agent can write an accurate query against it.
Run a scoped query for a report
Run a query limited to the columns a report needs, rather than pulling an entire table.
6 Snowflake Basic actions, graded by risk.
Every Snowflake Basic action is tagged read, write or destructive, so one policy covers the whole app and new actions inherit the right default.
read
4Look things up. Allowed by default.
- snowflake_basic.show_tablesShow Tables
- snowflake_basic.show_schemasShow schemas
- snowflake_basic.describe_tableDescribe table
- snowflake_basic.show_databasesShow databases
write
2Create and change things. Allow, or ask the user first.
- snowflake_basic.run_queryRun Query
- snowflake_basic.explore_columnsExplore Columns
destructive
0Delete, cancel or archive. Ask first, or deny outright.
- No destructive actions.
Snowflake Basic in three steps.
- 01Your users connect Snowflake BasicThey add their Snowflake Basic username and password on Arc0 Connect, under your brand. It goes straight into the vault.
- 02You set the rulesReads run, and writes like “run Query” can wait for the user to approve.
- 03Any agent can actYour agent calls Snowflake Basic through the Arc0 SDK or MCP, and so can Claude, ChatGPT and Cursor. Every call lands on the audit log.
await arc0.policies.set('snowflake_basic', { read: 'allow', write: 'ask', // run_query destructive: 'deny', }) # Claude Code: the same connection, one URL $ claude mcp add --transport http arc0 \ https://mcp.arc0.ai/u/u_8f2
How Snowflake Basic connects.
Users add their Snowflake Basic username and password on Arc0 Connect. It is encrypted in the vault, never shown to the model, and each user can rotate or revoke it at any time.
The same Snowflake Basic 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
- Username and password
- CREDENTIALS
- Per-tenant encrypted vault
- MODEL SEES
- Results only, never credentials
- AUDIT LOG
- Every call, on every plan
Use Snowflake Basic from any agent.
ClaudeChatGPTCursor
Codex
VS CodeOpenAI Agents SDKClaude Agent SDK
Vercel AI SDK
Mastra
LangGraphMore databases and spreadsheets apps.
Snowflake Basic and Arc0, answered.
Can I use Snowflake Basic with Claude, ChatGPT or Cursor?
Yes. Connect Snowflake Basic 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 Basic actions you allow.
How do users connect Snowflake Basic?
Users add their Snowflake Basic username and password on Arc0 Connect. It is encrypted in the vault, never shown to the model, and each user can rotate or revoke it at any time.
Which Snowflake Basic actions can my agent take?
6 in total: 4 read, 2 write and 0 destructive, such as “run Query”. Your policies decide which of them each agent may call.
Can I make my agent read-only in Snowflake Basic?
Yes. Allow read actions and deny writes in the Snowflake Basic policy. Your agent can still look things up, and any write it attempts is blocked and logged.
Can my own backend call Snowflake Basic too?
Yes. The same Snowflake Basic connection is available over REST and through the Arc0 proxy, so your product and your agent share one connection per user.
Plug Snowflake Basic into your agent.
Your users connect Snowflake Basic once, under your brand. Your agent gets 6 actions behind your policies, with every call on the record.
Free to build · MCP + REST · Audit log on every plan