Back to MCP Servers

Snowflake Slack integration for your AI agent

Integrate Snowflake MCP server into your Slack workspace for instant access to your AI agent.

A data warehouse built for the cloud

Categories

Databases

Available Tools

Tools that your AI agent can use through this MCP server to interact with Snowflake

  • Start SQL Session

    Start a Snowflake session and return it in serialized form, so subsequent Snowflake actions can run in the same session (preserving temporary tables, USE context, and session parameters) by passing it to their Session prop. The returned value contains session auth tokens — treat it as sensitive. Sessions expire server-side after ~4 hours or your account's idle timeout. See the documentation

  • Insert Multiple Rows

    Insert multiple rows into a table

  • Execute SQL Query In Session

    Execute a Snowflake query inside a session started by the Start SQL Session action, so it shares that session's state — temporary tables, USE context, and session parameters — with the other queries in the same session. Pass the serialized session from Start SQL Session to the Session prop. Note: to preserve the session this query runs on a direct connection and therefore does NOT egress from the shared static IP (use_pd_sql_proxy); if your Snowflake network policy allowlists only the static IP, use Execute SQL Query instead. See our docs to learn more about working with SQL in Pipedream.

  • List Warehouse Name Options

    Retrieves available options for the Warehouse Name field.

  • List User Name Options

    Retrieves available options for the User Name field.

  • List Database Options

    Retrieves available options for the Database field.

  • Insert Single Row

    Insert a row into a table

  • Execute SQL Query

    Execute a custom Snowflake query. See our docs to learn more about working with SQL in Pipedream.

  • Query SQL Database

    Execute a SQL Query. See our docs to learn more about working with SQL in Pipedream.