Snowflake MCP
Use Snowflake with Claude Desktop, Cursor, or Windsurf to let AI read, act, and automate — no code required.
Or build automated Snowflake workflowsHow to use this MCP
Connect Your Snowflake Account
Sign up and connect your Snowflake account to Activepieces.
Start freeGet Your MCP Server URL
Get your MCP URL and install it in Claude Desktop, Cursor, or Windsurf.
Ask AI to Act
Ask your AI assistant to read emails, manage your calendar, and more.
Snowflake Triggers
New Row
Triggers when a new row is inserted into the selected table. Uses a timestamp column you choose to detect rows added since the last check.
New or Updated Row
Triggers when a row is inserted or updated in the selected table. Uses an "updated at" timestamp column you choose — any row whose timestamp is newer than the last check will fire the trigger.
New Column
Triggers when a new column is added to the selected table. Checked by polling every few minutes.
New Table
Triggers when a new table is created in the selected schema. Checked by polling every few minutes.
New View
Triggers when a new view is created in the selected schema. Checked by polling every few minutes.
Snowflake Actions
Run Query
Execute a SQL query against your Snowflake database and return the results as rows.
Run Multiple Queries
Execute multiple SQL statements in sequence against your Snowflake database. Optionally wrap them in a transaction so all changes are rolled back if any statement fails.
Insert Row
Insert a row into a table.
Update Row
Update one or more rows in a Snowflake table that match a WHERE condition.
Delete Row
Delete one or more rows from a Snowflake table that match a WHERE condition.
Upsert Row
Insert a new row or update an existing one if a row with the same match column value already exists (MERGE INTO).
Insert Multiple Rows
Insert multiple rows into a Snowflake table in a single operation.
Get Row by ID
Retrieve a single row from a Snowflake table by matching a column value.
Search Rows
Search for rows in a Snowflake table using an optional WHERE condition, ordering, and row limit.
Get Table Schema
Retrieve the column definitions (name, data type, nullability, default) for a Snowflake table.
List Tables
List all tables in a Snowflake schema.
Execute Stored Procedure
Call a stored procedure in Snowflake and return its result.
Create / Refresh Dynamic Table
Create or replace a Snowflake Dynamic Table that automatically refreshes based on a query. Dynamic Tables are a declarative way to define a table whose content is derived from a query, updated on a schedule.
Load Data from Stage
Load data into a Snowflake table from a named internal or external stage using COPY INTO.
Get started
Start automating in minutes.
Join 300,000+ builders at MoneyGram, Alan, and PostHog shipping secure, open source AI automation.