Snowflake
Available Tools
List all databases in the Snowflake account
Create a new database in Snowflake
Alter an existing database in Snowflake
Drop a database from Snowflake
Get details of a specific database
List all schemas in a database
Create a new schema in a database
Alter an existing schema in Snowflake
Drop a schema from a database
Get details of a specific schema
List all roles in the Snowflake account
Create a new role in Snowflake
Drop a role from Snowflake
Get details of a specific role
Grant privileges to a role on a Snowflake object
Revoke privileges from a role on a Snowflake object
Grant a role to a user or another role
Revoke a role from a user or another role
Execute a SQL statement in Snowflake (query, DDL, or DML)
Get the status of an asynchronous SQL statement
Fetch results from a completed SQL query with pagination
Cancel a running SQL statement
List all stages in a schema
Create a new stage for data loading/unloading
Drop a stage from Snowflake
Get details of a specific stage
List files in a stage
Describe a stage to see its properties and file format settings
Load data from a stage into a table. Supports file patterns, error handling modes, and validation.
Unload data from a table or query to a stage. Supports file format and partitioning options.
List all tables in a schema
Create a new table in Snowflake
Alter an existing table in Snowflake
Drop a table from Snowflake
Get the structure and column definitions of a table
Get details of a specific table
List all tasks in a schema
Create a new scheduled task in Snowflake
Alter an existing task in Snowflake
Drop a task from Snowflake
Resume a suspended task to start scheduled execution
Suspend a running task to stop scheduled execution
Execute a task immediately without waiting for schedule
Get execution history for a task
Get details of a specific task
List all users in the Snowflake account
Create a new user in Snowflake
Alter an existing user in Snowflake
Drop a user from Snowflake
Get details of a specific user
Validate Snowflake credentials by executing a lightweight query. Supports OAuth2, key-pair, and programmatic access token authentication. Returns {success, message}.
List all warehouses in the Snowflake account
Create a new virtual warehouse in Snowflake
Alter an existing warehouse in Snowflake
Drop a warehouse from Snowflake
Resume a suspended warehouse
Suspend a running warehouse to stop billing
Get details of a specific warehouse