Snowflake

Suspend an active warehouse. Stops a running warehouse to conserve credits. Any running queries will complete before the warehouse suspends. Args: - name: Warehouse name to suspend (required) Returns: Confirmation of warehouse suspension.

List all databases accessible to the current user. Returns information about each database including name, owner, creation date, and other metadata. Args: - format: Response format ('json' or 'markdown') Returns: List of databases with their metadata.

List all schemas in a database. Returns information about each schema including name, owner, and creation date. Args: - database: Database name to list schemas from (required) - format: Response format ('json' or 'markdown') Returns: List of schemas in the specified database.

List all tables in a schema. Returns information about each table including name, row count, size, owner, and other metadata. Args: - database: Database name (required) - schema: Schema name (required) - format: Response format ('json' or 'markdown') Returns: List of tables in the specified schema.

List all views in a schema. Returns information about each view including name, whether it's secure, materialized, and other metadata. Args: - database: Database name (required) - schema: Schema name (required) - format: Response format ('json' or 'markdown') Returns: List of views in the specified schema.

Get detailed column information for a table or view. Returns information about each column including name, data type, nullability, default value, and constraints. Args: - database: Database name (required) - schema: Schema name (required) - table: Table or view name (required) - format: Response format ('json' or 'markdown') Returns: List of columns with their definitions.

Execute a SQL statement synchronously in Snowflake. This tool executes a SQL query and waits for the result. Use this for queries that complete quickly (under 45 seconds). For long-running queries, use snowflake_execute_async instead. Args: - statement: SQL statement to execute (required) - database: Database context for the query - schema: Schema context for the query - warehouse: Warehouse to use for execution - role: Role to use for the session - timeout: Query timeout in seconds (default: 60) - format: Response format ('json' or 'markdown') Returns: Query results including columns, data, and execution statistics. Example: statement: "SELECT * FROM my_table LIMIT 10" database: "MY_DB" schema: "PUBLIC"

Execute a SQL statement asynchronously in Snowflake. This tool submits a SQL query for asynchronous execution and returns immediately with a statement handle. Use snowflake_get_status to check execution progress and snowflake_get_result to retrieve results when ready. Args: - statement: SQL statement to execute (required) - database: Database context for the query - schema: Schema context for the query - warehouse: Warehouse to use for execution - role: Role to use for the session - timeout: Query timeout in seconds (default: 3600) Returns: Statement handle and status URL for polling. Example: statement: "SELECT * FROM large_table"

Check the execution status of an async SQL statement. Use this tool to poll for completion of statements submitted with snowflake_execute_async. Args: - statementHandle: The statement handle from async execution (required) Returns: Current execution status (running, queued, success, failed_with_error, etc.)

Retrieve results from a completed SQL statement. Use this tool to fetch results after a statement has completed execution. For large result sets, use the partition parameter to fetch additional data. Args: - statementHandle: The statement handle (required) - partition: Partition number for large result sets (default: 0) - format: Response format ('json' or 'markdown') Returns: Query results including columns, data, and partition information.

Cancel a running SQL statement. Use this tool to terminate execution of a statement that is still running. Args: - statementHandle: The statement handle to cancel (required) Returns: Confirmation of cancellation.

List all warehouses accessible to the current user. Returns information about each warehouse including name, state (STARTED/SUSPENDED), size, running queries, queued queries, and configuration. Args: - format: Response format ('json' or 'markdown') Returns: List of warehouses with their status and configuration.

Get detailed status of a specific warehouse. Returns comprehensive information about the warehouse including state, size, cluster count, running/queued queries, and all configuration settings. Args: - name: Warehouse name (required) - format: Response format ('json' or 'markdown') Returns: Warehouse details and current status.

Resume a suspended warehouse. Starts a suspended warehouse so it can execute queries. The warehouse will begin consuming credits once resumed. Args: - name: Warehouse name to resume (required) Returns: Confirmation of warehouse resumption.