Execute a SQL SELECT or read-only query on Snowflake and return structured rows with metadata.

Execute a data modification SQL statement (INSERT, UPDATE, DELETE, MERGE, CREATE).

Cancel an active running Snowflake query by its Query ID.

Retrieve recent query execution history for the current account/user.

Generate the EXPLAIN execution plan for a SQL query without executing it.

Retrieve operator-level execution statistics and profiling data for a past Query ID.

Begin an explicit transaction on the active session.

Commit the current active transaction on the session.

Rollback the current active transaction on the session.

List all available databases accessible to the current role.

Describe properties, owner, retention time, and comment of a database.

Create a new database in Snowflake.

Create a zero-copy clone of a database in Snowflake.

Drop a database in Snowflake. Requires confirmation flag.

Restore a recently dropped database using Time Travel.

Retrieve the exact CREATE DATABASE DDL definition.

List all schemas within a specific database or the current active database.

Describe schema properties, owner, and retention settings.

Create a new schema inside a specified database.

Create a zero-copy clone of a schema.

Drop a schema in Snowflake. Requires confirmation flag.

Restore a recently dropped schema using Time Travel.

List tables in a database schema with row counts and bytes.

List views in a database schema.

Describe column definitions, data types, nullability, and primary keys for a table or view.

Retrieve the exact CREATE OR REPLACE TABLE/VIEW DDL definition for an object.

Preview sample rows from a table (default 10 rows).

Create a table in Snowflake with specified column definitions SQL.

Drop a table in Snowflake. Requires confirmation flag.

Restore a recently dropped table using Time Travel.

Truncate all data rows from a table while preserving schema. Requires confirmation.

Create a zero-copy clone of an existing table.

List virtual warehouses in the account with size, state, and auto-suspend configurations.

Describe details and running state of a specific virtual warehouse.

Create a new virtual warehouse in Snowflake.

Drop a virtual warehouse. Requires confirmation.

Resume a suspended virtual warehouse.

Suspend an active virtual warehouse to save compute costs.

Change warehouse compute size (XSMALL, SMALL, MEDIUM, LARGE, XLARGE, 2XLARGE, etc.).

Get execution load, queuing, and provisioning history for a warehouse.

List internal and external stages available in the active database or schema.

Describe stage location URL, storage integration, and file format properties.

Create an internal named stage in Snowflake.

Drop a stage in Snowflake. Requires confirmation.

List files inside a Snowflake stage location (e.g. '@MY_STAGE/path/').

Remove a file from a stage location. Requires confirmation.

List tasks in a database or schema with schedule, state, and predecessor info.

Describe task definition, schedule, warehouse, and definition SQL.

Create a scheduled or serverless task in Snowflake.

Drop a task in Snowflake. Requires confirmation.

Resume a suspended task.

Suspend an active scheduled task.

Trigger an immediate one-time execution of a task.

List table/view streams in a database or schema.

Describe stream metadata, source table, and stale status.

Create a CDC stream on a table or view.

Drop a stream. Requires confirmation.

Query unconsumed CDC changes recorded in a stream (default 10 rows).

List dynamic tables with lag targets, refresh mode, and last refresh status.

Describe dynamic table definition, target lag, warehouse, and query text.

Trigger an immediate manual refresh of a dynamic table.

Resume scheduling and lag monitoring for a dynamic table.

Suspend automated refresh and lag evaluation for a dynamic table.

List Apache Iceberg tables in the account, database, or schema.

Describe schema, catalog integration, and external volume of an Iceberg table.

List external cloud storage volumes configured for Apache Iceberg tables.

List catalog integrations (Polaris, AWS Glue, Object Storage) configured in Snowflake.

List Snowpipes configured in a database or schema.

Describe pipe definition and COPY statement.

Create a Snowpipe for continuous ingestion.

Drop a Snowpipe. Requires confirmation.

Get execution and health status of a Snowpipe (pending file count, last ingested timestamp).

List configured alerts with condition queries, schedules, and state.

Describe alert condition SQL, action SQL, schedule, and warehouse.

Create an alert with schedule, condition SQL, and action SQL. Destructive actions require confirm=True.

Drop an alert in Snowflake. Requires confirmation.

Resume a suspended alert.

Suspend an active alert.

Retrieve current active session context (current user, role, warehouse, database, schema, and account).

List available connection profiles configured in ~/.snowflake/connections.toml and show active profile.

Dynamically switch the active Snowflake session to a different connection profile from ~/.snowflake/connections.toml.

List roles available in the Snowflake account.

Describe role properties and assigned grants.

Create a new role in Snowflake.

Drop a role in Snowflake. Requires confirmation.

List users in the Snowflake account with login status and default roles.

Describe user properties, email, disabled status, and default warehouse/role.

Create a new Snowflake user with default role and warehouse.

List privileges granted to a specific role.

List roles granted to a specific user.

List network policies configured in the account.

Describe allowed IP lists, blocked IP lists, and comments for a network policy.

List network rules defined in a database or schema.

Describe mode (INGRESS, INTERNAL_STAGE, EGRESS), type (IPV4, AWSVPCEID, HOST_PORT), and value list of a network rule.

List password security policies defined in the account or database.

Describe password policy constraints (min length, lockout time, history, age).

List Streamlit applications hosted in Snowflake.

Describe Streamlit application root location, stage, and query warehouse.

List Snowpark Container Services (SPCS) compute pools.

Describe compute pool instance family, min/max nodes, active nodes, and state.

Resume an idle or suspended SPCS compute pool.

Suspend an active SPCS compute pool to stop node provisioning costs.

List container services running on SPCS compute pools.

List OCI image repositories in Snowflake.

List object tags defined in a database or schema.

Describe tag properties, allowed values, and comment.

Get tag key/value assignments on a specific database object.

Set or assign a tag value on a Snowflake object (TABLE, SCHEMA, DATABASE, etc.).

Retrieve upstream source and downstream dependent object lineage from Snowflake Horizon.

Trace origin and transformation lineage for a column using Snowflake Horizon Access History.

List column masking policies in the account, database, or schema.

Describe signature, return type, and body of a masking policy.

List row access policies defined in the account, database, or schema.

Describe signature, filter expression, and comment of a row access policy.

List stored procedures in a database or schema.

Describe procedure signature, return type, language, and definition body.

List user-defined functions (UDFs) in a database or schema.

Describe UDF function signature, return type, language, and body.

List security secrets (API keys, OAuth credentials) stored in Snowflake.

Describe secret metadata, type (GENERIC_STRING, OAUTH2), and owner without exposing secret value.

List auto-increment sequences in a database or schema.

List external integrations (API, Storage, Notification, Security integrations).

List event tables used for application logging, tracing, and SPCS telemetry.

List notification integrations configured for alerts, tasks, and cloud messaging (SNS, PubSub, Webhooks).

Run LLM completion using Snowflake Cortex AI (e.g., 'llama3.3-70b', 'mistral-large2', 'snowflake-arctic').

Summarize English text using Snowflake Cortex AI.

Analyze sentiment of text returning score from -1.0 (most negative) to 1.0 (most positive).

Extract direct answer to a question from unstructured source document/text.

Translate text from a source language to a target language using Snowflake Cortex AI.

Query a Snowflake Cortex Search Service index over unstructured text.

Generate 768-dimensional dense vector embeddings for text using Snowflake Cortex AI.

Ask a natural language analytical question using Cortex Analyst semantic models.

Composite recipe: Run health check on connection, active session, warehouse state, and credit consumption.

Composite recipe: Describe table schema, row count, column types, and preview sample rows in 1 call.

Composite recipe: Profile table metadata, row count, and column inventory.

Composite recipe: Safely scale up a warehouse, run a heavy query, and optionally restore previous size.

Composite recipe: Clone table with Time Travel timestamp or statement ID in 1 call.

Composite recipe: Unload query results to a stage as Parquet or CSV files.

Composite recipe: Summary of warehouse compute credits and storage consumption over the past 7 days.

Composite recipe: Discover all tables and views in a schema along with their column definitions.