Snowflake
Cloud data warehouse — execute SQL queries, manage databases, schemas, and tables via the SQL REST API
Tools
| Name | Description |
|---|---|
execute_queryExecute a SQL statement on Snowflake | Execute a SQL statement on Snowflake |
check_statusCheck the status of a previously submitted SQL statement | Check the status of a previously submitted SQL statement |
get_resultsGet results for a completed SQL statement by partition | Get results for a completed SQL statement by partition |
list_databasesList all databases in the Snowflake account | List all databases in the Snowflake account |
list_schemasList all schemas in a database | List all schemas in a database |
list_tablesList all tables in a schema | List all tables in a schema |
custom_api_callMake a custom API call to the Snowflake SQL REST API | Make a custom API call to the Snowflake SQL REST API |
Quick Start
import { WeavzClient } from '@weavz-io/sdk'
const weavz = new WeavzClient({ apiKey: 'wvz_...' })
const result = await weavz.actions.execute('snowflake', 'execute_query', {
workspaceId: '550e8400-e29b-41d4-a716-446655440000',
integrationAlias: 'snowflake',
input: { /* ... */ },
})Related Integrations
Works well with
Frequently Asked Questions
How do I connect Snowflake to my app?
Use Weavz Hosted Connect for Custom authentication. Install the SDK, create a connection through the connect portal or API, then execute tools programmatically.
What tools does Snowflake support?
Snowflake supports 7 tools including Execute Query, Check Query Status, Get Query Results, List Databases, List Schemas, and more.
Can I use Snowflake with AI agents?
Yes. Add Snowflake to an MCP server in Tool Mode or Code Mode. Code Mode provides 3 meta-tools with on-demand API discovery so agents can compose stateful workflows without loading every action schema up front.
How do I connect Snowflake to ChatGPT or Claude?
Open the Weavz connector setup, sign in, choose a workspace, and add Snowflake as an approved app. ChatGPT, Claude, and other remote MCP clients can then call the scoped Snowflake tools exposed by that workspace.
Does Snowflake work with Claude Code, Cursor, Codex, and local agents?
Yes. Remote and local MCP clients can connect to a Weavz MCP endpoint for the workspace. Local coding agents can also use the Weavz CLI to inspect apps, discover actions, run approved Snowflake work, and execute Code Mode workflows from a terminal.
What can I ask an AI agent to do with Snowflake?
Snowflake exposes 7 tools, including Execute Query, Check Query Status, Get Query Results, List Databases, List Schemas, and more. Use Weavz to keep credentials scoped, require approval for sensitive work, and audit what the agent did.
Can Snowflake be used in stateful agent workflows?
Yes. Agents can combine Snowflake tools with Filesystem, State KV, Human Gates, input partials, and other workspace integrations while keeping execution scoped to the selected workspace or end user.
What authentication does Snowflake use?
Snowflake uses Custom. Weavz stores credentials securely and uses them for authorized action execution.
How much does the Snowflake integration cost?
The Snowflake integration is included on all Weavz plans including the free tier with 20,000 actions per month. No credit card required.
Connect Snowflake in minutes
Get 20,000 free action executions every month. No credit card required.