Snowflake

Connect your AI agents to Snowflake.

Available Tools

list_databases

List all databases in the Snowflake account

create_database

Create a new database in Snowflake

alter_database

Alter an existing database in Snowflake

drop_database

Drop a database from Snowflake

get_database

Get details of a specific database

list_schemas

List all schemas in a database

create_schema

Create a new schema in a database

alter_schema

Alter an existing schema in Snowflake

drop_schema

Drop a schema from a database

get_schema

Get details of a specific schema

list_roles

List all roles in the Snowflake account

create_role

Create a new role in Snowflake

drop_role

Drop a role from Snowflake

get_role

Get details of a specific role

grant_privilege

Grant privileges to a role on a Snowflake object

revoke_privilege

Revoke privileges from a role on a Snowflake object

grant_role

Grant a role to a user or another role

revoke_role

Revoke a role from a user or another role

execute_sql

Execute a SQL statement in Snowflake (query, DDL, or DML)

get_statement_status

Get the status of an asynchronous SQL statement

get_query_results

Fetch results from a completed SQL query with pagination

cancel_statement

Cancel a running SQL statement

list_stages

List all stages in a schema

create_stage

Create a new stage for data loading/unloading

drop_stage

Drop a stage from Snowflake

get_stage

Get details of a specific stage

list_stage_files

List files in a stage

describe_stage

Describe a stage to see its properties and file format settings

copy_into_table

Load data from a stage into a table. Supports file patterns, error handling modes, and validation.

copy_into_location

Unload data from a table or query to a stage. Supports file format and partitioning options.

list_tables

List all tables in a schema

create_table

Create a new table in Snowflake

alter_table

Alter an existing table in Snowflake

drop_table

Drop a table from Snowflake

describe_table

Get the structure and column definitions of a table

get_table

Get details of a specific table

list_tasks

List all tasks in a schema

create_task

Create a new scheduled task in Snowflake

alter_task

Alter an existing task in Snowflake

drop_task

Drop a task from Snowflake

resume_task

Resume a suspended task to start scheduled execution

suspend_task

Suspend a running task to stop scheduled execution

execute_task

Execute a task immediately without waiting for schedule

get_task_history

Get execution history for a task

get_task

Get details of a specific task

list_users

List all users in the Snowflake account

create_user

Create a new user in Snowflake

alter_user

Alter an existing user in Snowflake

drop_user

Drop a user from Snowflake

get_user

Get details of a specific user

validate_credential

Validate Snowflake credentials by executing a lightweight query. Supports OAuth2, key-pair, and programmatic access token authentication. Returns {success, message}.

list_warehouses

List all warehouses in the Snowflake account

create_warehouse

Create a new virtual warehouse in Snowflake

alter_warehouse

Alter an existing warehouse in Snowflake

drop_warehouse

Drop a warehouse from Snowflake

resume_warehouse

Resume a suspended warehouse

suspend_warehouse

Suspend a running warehouse to stop billing

get_warehouse

Get details of a specific warehouse