Name: Integrate
Author: Integrate

Manage Snowflake submit statement, get statement, cancel statement, list databases, list warehouses

The Snowflake integration provides access to manage Snowflake submit statement, get statement, cancel statement, list databases, list warehouses through the Integrate MCP server.

Installation

The Snowflake integration is included with the SDK:

import { snowflakeIntegration } from "integrate-sdk/server";

Setup

1. Create a Snowflake OAuth App

Create an OAuth application for Snowflake
Configure your redirect URI
Note your Client ID and Client Secret

2. Configure the Integration on Your Server

Add the Snowflake integration to your server configuration. The integration automatically reads SNOWFLAKE_CLIENT_ID and SNOWFLAKE_CLIENT_SECRET from your environment variables:

import { createMCPServer, snowflakeIntegration } from "integrate-sdk/server";

export const { client: serverClient } = createMCPServer({
  apiKey: process.env.INTEGRATE_API_KEY,
  integrations: [
    snowflakeIntegration({
      scopes: ["session:role-any"], // Optional
    }),
  ],
});

You can override the environment variables by passing explicit values:

snowflakeIntegration({
  clientId: process.env.CUSTOM_SNOWFLAKE_ID,
  clientSecret: process.env.CUSTOM_SNOWFLAKE_SECRET,
      scopes: ["session:role-any"], // Optional
});

3. Client-Side Usage

The default client automatically includes all integrations. You can use it directly:

import { client } from "integrate-sdk";

await client.authorize("snowflake");
const result = await client.snowflake.submitStatement({
  statement_json: "value",
});

console.log(result);

If you're using a custom client, add the integration to the integrations array:

import { createMCPClient, snowflakeIntegration } from "integrate-sdk";

const customClient = createMCPClient({
  integrations: [snowflakeIntegration()],
});