Is the Snowflake MCP server free?

Yes. Activepieces is open source and free to start, and the MCP server is included on every plan, from the free cloud tier to any self-hosted deployment.

How do I connect Snowflake to Claude or Cursor?

Connect Snowflake in Activepieces, enable the server under Settings → MCP Server, then paste your server URL into your client config. It authenticates over OAuth on first use.

What can my agent do in Snowflake?

It can call 14 tools, including Run Query, Run Multiple Queries, Insert Row, and chain them with steps in other apps inside the same run.

Is it safe to let an agent call Snowflake?

Connections use OAuth2 with limited scopes and are stored under 256-bit encryption, with no API to read them back, so an agent gets scoped access rather than your keys.

Snowflake MCP server

Data warehouse built for the cloud

Snowflake is not a separate install. One Activepieces MCP server exposes it alongside 760+ other apps, behind a single URL.

Start building See the Snowflake integration

Tools: 14
Works with: Any MCP client
Auth: OAuth 2.0 or Custom auth
License: MIT, open source
Updated: August 2026

About the Snowflake MCP server

Connect Snowflake once in Activepieces and every action it ships becomes a tool your assistant can call, behind the same server URL as the rest of your apps. Your agent reaches Snowflake and 760+ other apps over a single connection, on our cloud or a self-hosted install.

Tools

Snowflake tools your AI can run

Once connected, your assistant can call any of these Snowflake actions by asking in plain language.

Run Query
Execute a SQL query against your Snowflake database and return the results as rows.
4 fields
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.
5 fields
Insert Row
Insert a row into a table.
4 fields
Update Row
Update one or more rows in a Snowflake table that match a WHERE condition.
5 fields
Delete Row
Delete one or more rows from a Snowflake table that match a WHERE condition.
4 fields
Upsert Row
Insert a new row or update an existing one if a row with the same match column value already exists (MERGE INTO).
5 fields
Insert Multiple Rows
Insert multiple rows into a Snowflake table in a single operation.
4 fields
Get Row by ID
Retrieve a single row from a Snowflake table by matching a column value.
5 fields
Search Rows
Search for rows in a Snowflake table using an optional WHERE condition, ordering, and row limit.
6 fields
Get Table Schema
Retrieve the column definitions (name, data type, nullability, default) for a Snowflake table.
3 fields
List Tables
List all tables in a Snowflake schema.
2 fields
Execute Stored Procedure
Call a stored procedure in Snowflake and return its result.
4 fields
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.
6 fields
Load Data from Stage
Load data into a Snowflake table from a named internal or external stage using COPY INTO.
9 fields

Triggers

Snowflake events your agent can watch

These start a run the moment something happens in Snowflake, so work gets picked up on its own.

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.
4 fields
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.
4 fields
New Column
Triggers when a new column is added to the selected table. Checked by polling every few minutes.
3 fields
New Table
Triggers when a new table is created in the selected schema. Checked by polling every few minutes.
2 fields
New View
Triggers when a new view is created in the selected schema. Checked by polling every few minutes.
2 fields

Give your assistant Snowflake

Connect Snowflake once and every tool above is callable from Claude, Cursor or any MCP client, behind the same server URL as 760+ other apps. Free to start.

Get your server URL Talk to sales

Snowflake MCP, answered.

No. That is the point of it. One Activepieces server exposes Snowflake alongside every other piece you connect, so your client keeps a single connection.