snowflake-api

Execute SQL statements against Snowflake and retrieve query results.

37|13|Updated Jun 23, 2026
One-click install
npx skills add https://github.com/anthropics/claude-tag-plugins --skill snowflake-api
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: snowflake-api
Source: https://github.com/anthropics/claude-tag-plugins/tree/main/snowflake/skills/snowflake-api
Command: npx skills add https://github.com/anthropics/claude-tag-plugins --skill snowflake-api

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires curl, jq, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill removes the friction of manually interacting with Snowflake’s SQL API by letting you submit queries, poll long-running jobs, and retrieve results in a reliable, repeatable way.

Core Features & Use Cases

  • Query execution: Submit single statements or multi-statement requests to Snowflake with the right session context, bindings, and timeout controls.
  • Result retrieval: Fetch inline results or partitioned pages from existing statement handles, including recovery after asynchronous execution.
  • Catalog browsing and operations: Inspect databases, schemas, tables, columns, and warehouses with SQL-based SHOW and INFORMATION_SCHEMA workflows.
  • Operational control: Cancel running statements, manage request idempotency, and handle errors and rate limits safely.

Quick Start

Ask the assistant to run a Snowflake query with this skill, providing the target warehouse and SQL statement so it can submit the job, wait for completion, and return the results.

Frequently Asked Questions about snowflake-api

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run SQL statements against Snowflake using the SQL API?

You can run SQL statements against Snowflake using the SQL API by submitting single or multi-statement requests with the correct session context, bindings, and timeout controls. The skill handles authentication headers and request bodies automatically.

How does asynchronous query execution and result polling work in Snowflake?

Asynchronous query execution in Snowflake submits statements and returns a statement handle for polling. The skill retrieves results from existing handles, fetches partitioned pages, and recovers results after asynchronous jobs complete.

Can I browse Snowflake databases, schemas, tables, and warehouses with SQL?

Yes, you can browse Snowflake databases, schemas, tables, columns, and warehouses through SQL-based SHOW and INFORMATION_SCHEMA queries. The skill executes these catalog browsing workflows to inspect metadata and warehouse configurations.

Do I need curl and jq to execute Snowflake API queries?

Yes, you need curl and jq installed to execute Snowflake API queries. The skill relies on these dependencies to submit HTTP requests, process JSON responses, and handle Snowflake API requirements for authentication and result fetching.

What is the best way to cancel running Snowflake statements and handle rate limits?

The best way to cancel running Snowflake statements and handle rate limits is through operational control features. The skill manages request idempotency, cancels running queries, and safely handles errors and rate limits during query execution.

Why does Snowflake SQL API return partitioned results and how do I fetch them?

Snowflake SQL API returns partitioned results to manage large datasets efficiently. The skill fetches inline results and partitioned pages from existing statement handles, retrieving all data segments through the SQL API partitioned result fetching mechanism.