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). Requires confirmation.

Cancel an active running Snowflake query by its Query ID. Requires confirmation.

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. Requires confirmation.

List all available databases accessible to the current role. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

List views in a database schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Describe details and running state of a specific virtual warehouse. A name in double quotes, such as a list row's quoted_name, must match exactly.

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. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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. Requires confirmation.

List table/view streams in a database or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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

List external cloud storage volumes configured for Apache Iceberg tables. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

List catalog integrations (Polaris, AWS Glue, Object Storage) configured in Snowflake. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

List Snowpipes configured in a database or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Describe role properties and assigned grants. A name in double quotes, such as a list row's quoted_name, must match exactly.

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. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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

List network rules defined in a database or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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

List Streamlit applications hosted in Snowflake. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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

List Snowpark Container Services (SPCS) compute pools. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

List OCI image repositories in Snowflake. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

List object tags defined in a database or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

Describe tag properties, allowed values, and comment. A name in double quotes, such as a list row's quoted_name, must match exactly.

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. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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

List row access policies defined in the account, database, or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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

List stored procedures in a database or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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

List user-defined functions (UDFs) in a database or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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

List security secrets (API keys, OAuth credentials) stored in Snowflake. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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

List auto-increment sequences in a database or schema. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

List external integrations (API, Storage, Notification, Security integrations). Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

List event tables used for application logging, tracing, and SPCS telemetry. Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

List notification integrations configured for alerts, tasks, and cloud messaging (SNS, PubSub, Webhooks). Each row also has quoted_name, the name in double quotes, and, when the row has a database and schema, quoted_qualified_name.

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. Requires confirmation.

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.