Snowflake CLI for AI Agents

CLIs are eating MCPs. The industry is converging on the very same idea. MCPs for all their merit can be token hungry, slow, and unreliable for complex tool chaining. However, coding agents have become incredibly good at working with CLIs, and in fact they are far more comfortable working with CLI tools than MCP. With Composio's Universal CLI, your coding agents can talk to over 1000+ SaaS applications. With Snowflake, agents can run a sql query to list today's new users, cancel a long-running data import statement, show all unresolved incidents in snowflake, and more — all without worrying about authentication. This guide walks you through Composio Universal CLI and explains how you can connect it with coding agents like Claude Code, Codex, OpenCode, etc, for end-to-end Snowflake automation.

Get started for freeGet a demo
Snowflake logoSnowflake
Oauth2

Snowflake is a cloud data warehouse built for elastic scaling, secure data sharing, and fast SQL analytics across major clouds.

14 Tools

Introduction

CLIs are eating MCPs. The industry is converging on the very same idea. MCPs for all their merit can be token hungry, slow, and unreliable for complex tool chaining. However, coding agents have become incredibly good at working with CLIs, and in fact they are far more comfortable working with CLI tools than MCP.

With Composio's Universal CLI, your coding agents can talk to over 1000+ SaaS applications. With Snowflake, agents can run a sql query to list today's new users, cancel a long-running data import statement, show all unresolved incidents in snowflake, and more — all without worrying about authentication.

This guide walks you through Composio Universal CLI and explains how you can connect it with coding agents like Claude Code, Codex, OpenCode, etc, for end-to-end Snowflake automation.

Also integrate Snowflake with

ChatGPTOpenAI Agents SDKClaude Agent SDKClaude CodeClaude CoworkCodexOpenCodeCursorVS CodeOpenClawHermesGoogle ADKLangChainVercel AI SDKMastra AILlamaIndexCrewAI

What is Universal CLI and why use it?

The idea behind building the universal CLI is to give agents a single command interface to interact with all your external applications. Here's what you'll get with it:

  • Agent-friendly: Coding agents like Claude Code, Codex, and OpenCode can use CLI tools natively — no MCP setup required.
  • Authentication handled: Connect once via OAuth or API Key, and all CLI commands work with your credentials automatically.
  • Tool discovery: Search, inspect, and execute 20,000+ tools across 1000+ apps from one interface.
  • Trigger support: Use triggers to listen for events across your apps, powered by real-time webhooks or polling under the hood.
  • Type generation: Generate typed schemas for autocomplete and type safety in your projects.

Prerequisites

Install the Composio CLI, authenticate, and initialize your project:

bash
# Install the Composio CLI
curl -fsSL https://composio.dev/install | bash

# Authenticate with Composio
composio login

During login you'll be redirected to sign in page, finish the complete flow and you're all set.

Composio CLI authentication flow

Connecting Snowflake to Coding Agents via Universal CLI

Once it is installed, it's essentially done. Claude Code, Codex, OpenCode, OpenClaw, or any other agent will be able to access the CLI. A few steps to give agents access to your apps.

  1. Launch your Coding Agent — Claude Code, Codex, OpenCode, anything you prefer.
  2. Prompt it to "Authenticate with Snowflake"
  3. Complete the authentication and authorization flow and your Snowflake integration is all set.
  4. Start asking anything you want.

Universal CLI Commands for Snowflake

You can also manually execute CLI commands to interact with your Snowflake.

Connect your Snowflake account

Link your Snowflake account and verify the connection:

bash
# Connect your Snowflake account (opens OAuth flow)
composio connected-accounts link snowflake

# Verify the connection
composio connected-accounts list --toolkits snowflake

Discover Snowflake tools

Search and inspect available Snowflake tools:

bash
# List all available Snowflake tools
composio tools list --toolkit snowflake

# Search for Snowflake tools by action
composio tools search "snowflake"

# Inspect a tool's input schema
composio tools info SNOWFLAKE_CANCEL_STATEMENT_EXECUTION

Common Snowflake Actions

Cancel Statement Execution — Cancels the execution of a running sql statement

bash
composio tools execute SNOWFLAKE_CANCEL_STATEMENT_EXECUTION \
  --statementHandle "019c07bc-0000-df4f-0000-001000067c3e"

Execute SQL — Tool to execute a sql statement and return the resulting data

bash
composio tools execute SNOWFLAKE_EXECUTE_SQL \
  --statement "SELECT * FROM my_table;"

Fetch Catalog Integration — Fetches details of a specific catalog integration

bash
composio tools execute SNOWFLAKE_FETCH_CATALOG_INTEGRATION \
  --name "my_catalog_integration"

Get Active Scheduled Maintenances — Retrieves a list of any active scheduled maintenances currently in the in progress or verifying state

bash
composio tools execute SNOWFLAKE_GET_ACTIVE_SCHEDULED_MAINTENANCES

Generate Type Definitions

Generate typed schemas for Snowflake tools to get autocomplete and type safety in your project:

bash
# Auto-detect language
composio generate --toolkits snowflake

# TypeScript
composio ts generate --toolkits snowflake

# Python
composio py generate --toolkits snowflake

Tips & Tricks

  • Always inspect a tool's input schema before executing: composio tools info <TOOL_NAME>
  • Pipe output with jq for better readability: composio tools execute TOOL_NAME -d '{}' | jq
  • Set COMPOSIO_API_KEY as an environment variable for CI/CD pipelines
  • Use composio dev logs tools to inspect execution logs and debug issues

Next Steps

  • Try asking your coding agent to perform various Snowflake operations
  • Explore cross-app workflows by connecting more toolkits
  • Set up triggers for real-time automation
  • Use composio generate for typed schemas in your projects
TOOLS

Supported Tools

Every Snowflake action and event your agent gets out of the box.

Cancel Statement Execution

Cancels the execution of a running SQL statement.

Check Statement Status

Retrieves the status and results of a previously submitted SQL statement using its statement handle.

Execute SQL

Execute SQL statements in Snowflake and retrieve results.

Fetch Catalog Integration

Retrieves detailed configuration and metadata for a specific catalog integration.

Get Active Scheduled Maintenances

Retrieves a list of any active scheduled maintenances currently in the In Progress or Verifying state.

Get All Scheduled Maintenances

Retrieves a list of the 50 most recent scheduled maintenances, including those in the Completed state.

Get Component Status

Retrieves the status of individual components, each listed with its current status.

Get Status Rollup

Retrieves the status rollup for the entire page, including indicators and human-readable descriptions of the blended component status.

Get Status Summary

Retrieves the current status summary from Snowflake's public status page (status.

Get Unresolved Incidents

Retrieves a list of any unresolved incidents from the Snowflake status page.

Get Upcoming Scheduled Maintenances

Retrieves upcoming scheduled maintenances from Snowflake's public status page.

Show Databases

Lists all databases for which you have access privileges.

Show Schemas

Lists all schemas for which you have access privileges.

Show Tables

Lists all tables for which you have access privileges.

FRAMEWORKS

How to build Snowflake MCP Agent with another framework

ChatGPT logo

ChatGPT

Use Snowflake MCP with ChatGPT

OpenAI Agents SDK logo

OpenAI Agents SDK

Use Snowflake MCP with OpenAI Agents SDK

Claude Agent SDK logo

Claude Agent SDK

Use Snowflake MCP with Claude Agent SDK

Claude Code logo

Claude Code

Use Snowflake MCP with Claude Code

Claude Cowork logo

Claude Cowork

Use Snowflake MCP with Claude Cowork

Codex logo

Codex

Use Snowflake MCP with Codex

Cursor logo

Cursor

Use Snowflake MCP with Cursor

OpenClaw logo

OpenClaw

Use Snowflake MCP with OpenClaw

Hermes logo

Hermes

Use Snowflake MCP with Hermes

Google ADK logo

Google ADK

Use Snowflake MCP with Google ADK

LangChain logo

LangChain

Use Snowflake MCP with LangChain

Vercel AI SDK logo

Vercel AI SDK

Use Snowflake MCP with Vercel AI SDK

Mastra AI logo

Mastra AI

Use Snowflake MCP with Mastra AI

LlamaIndex logo

LlamaIndex

Use Snowflake MCP with LlamaIndex

CrewAI logo

CrewAI

Use Snowflake MCP with CrewAI

OpenCode logo

OpenCode

Use Snowflake MCP with OpenCode

VS Code logo

VS Code

Use Snowflake MCP with VS Code

FAQ

Frequently asked questions

The Composio Universal CLI is a single command-line interface that lets coding agents and developers interact with 1000+ SaaS applications. It handles authentication, tool discovery, action execution, and trigger setup — all from the terminal, without needing to configure MCP servers.

Any coding agent that can run shell commands works with the Composio CLI — including Claude Code, Codex, OpenCode, OpenClaw, and others. Once the CLI is installed, agents automatically discover and use the composio commands to interact with Snowflake and other connected apps.

MCP servers require configuration and can be token-heavy for complex workflows. The CLI gives agents a direct, lightweight interface — no server setup needed. Agents simply call composio commands like any other shell tool. It's faster to set up, more reliable for multi-step tool chaining, and works natively with how coding agents already operate.

All sensitive data such as tokens, keys, and configuration is fully encrypted at rest and in transit. Composio is SOC 2 Type 2 compliant and follows strict security practices so your Snowflake data and credentials are handled as safely as possible. You can also bring your own OAuth credentials for full control.

Start with Snowflake.It takes 30 seconds.

Managed auth, hosted MCP servers, and every Snowflake tool your agent needs.Free to start.

Start building
Customer stories

Teams ship real agents on Composio

GET STARTED FOR FREEBOOK A DEMO
agent.aiZoomLettaGleanHubSpotAWSWabi

Karan skipped his own birthday party to fix our critical issue. It was 10pm and he diverted his Waymo to help us instead. This really sets the bar — it shows the commitment you need when users rely on your software.

Harsha Gaddipati
Harsha Gaddipati
Co-founder, Slashy

A lot of students tell us that the moment their connected tools start talking to each other inside Opennote feels almost magical. The agent just knows them, and it's immensely helped keep new users on the platform.

Abhi Arya
Abhi Arya
Co-founder, Opennote

We chose Composio over Pipedream because it delivered depth where it mattered — niche tools and tricky edge cases other platforms simply ignored. That gave us confidence to scale without compromising.

Nirman Dave
Nirman Dave
CEO, Zams

As a solo builder, shipping fast is life or death. The only way I can outcompete incumbents is by outmanoeuvring them. Getting bogged down managing agent auth would have been a death sentence.

Ryan Yu
Ryan Yu
Founder, Extra Thursday

Before Composio, adding tool integrations was slow and resource-intensive. Each one could take weeks of engineering time, and maintaining them meant constantly keeping up with API changes.

Tomisin Jenrola
Tomisin Jenrola
Founder & CEO, SwarmZero

With hands-on help from their founder, we integrated Gmail and Google Drive in just 30 minutes. This level of personal support and commitment is exactly what startups should strive for.

Jerome Leclanche
Jerome Leclanche
Co-Founder, Ingram Technologies