Snowflake

A workflow step names the app and the action, and the editor fills in the connection when you pick one. This is the Step shape from the workflow spec, carrying Snowflake's real ids.

{
  "manifestVersion": "2",
  "name": "snowflake-example",
  "steps": [
    {
      "id": "statement-execute",
      "uses": {
        "app": "io.w6w.snowflake",
        "action": "statement-execute",
        "connection": "conn_YOUR_CONNECTION_ID"
      },
      "with": {
        "statement": "<statement>"
      }
    }
  ]
}

Here are some of the things you can do

• Execute SQL Statement

  perform
  statement-execute

• List Databases

  read
  database-list

• Get Statement Status / Results

  read
  statement-get

• List Warehouses

  read
  warehouse-list

+1 more action available

Every app-specific value here is a blank you have to fill in. An app action is reached through the connection that authenticates it, so the address is a connection id, not the app id — and connections belong to your account, so a public page cannot know yours. Create one for Snowflake, then fill in the three blanks: conn_YOUR_CONNECTION_ID, the action key, and the parameters that action declares. The call itself is real — the shape is transcribed from the studio's own snippet builder, which prints the same kind of blanks — but nothing in it is specific to Snowflake. The Workflow tab is where this app's real ids are.

npm install @w6w/sdk

yarn add @w6w/sdk

pnpm add @w6w/sdk

deno add npm:@w6w/sdk

import { W6wClient, isActionRun } from "@w6w/sdk";

// Reads W6W_BASE_URL and W6W_TOKEN from the environment when omitted.
const client = new W6wClient();

const envelope = await client.run({
  urn: "conn_YOUR_CONNECTION_ID",
  action: "statement-execute",
  payload: {
    statement: "<value>",
    // warehouse: "<value>",
    // database: "<value>",
    // schema: "<value>",
    // role: "<value>",
    // timeout: "<value>",
    // runAsync: "<value>",
    // bindings: "<value>",
  },
});

if (isActionRun(envelope)) console.log(envelope.value);

npm install -g @w6w/cli

w6w run conn_YOUR_CONNECTION_ID --action statement-execute --payload '{"statement":"<value>"}'

Give an AI agent Snowflake — without giving it Snowflake's credentials. One MCP endpoint exposes every app, function and workflow the caller is entitled to, as tools it can discover and run. Access is granted per team while we onboard.

{
  "name": "w6w_invoke",
  "arguments": {
    "ref": "app:io.w6w.snowflake#statement-execute",
    "input": {
      "statement": "<statement>"
    }
  }
}

Every tool names its target with a single ref. The app: form above doesn't name a connection at all — the host resolves which of the caller's Snowflake connections to sign with, and refuses rather than guesses when the answer is ambiguous.

What the agent gets

The MCP surface is part of the hosted platform. Snowflake itself is MIT, and the runtime that executes it is source-available (FSL).

Request MCP access