← Catalog

Snowflake

Query and administer Snowflake through the SQL API, including DDL/DML, asynchronous statements, partitioned results, and cancellation.

Tools15

  • snowflake__execute_queryFreeExecute one SQL statement that begins with SELECT/SHOW/DESCRIBE/EXPLAIN and return its first result partition plus partition metadata. The check is on the leading keyword only — a SELECT that invokes a system function or stored procedure can still have effects, so this is not a read-only tool.

    Execute one SQL statement that begins with SELECT/SHOW/DESCRIBE/EXPLAIN and return its first result partition plus partition metadata. The check is on the leading keyword only — a SELECT that invokes a system function or stored procedure can still have effects, so this is not a read-only tool.

  • snowflake__execute_statementFreeExecute arbitrary Snowflake SQL, including DDL/DML and multi-statement requests. Snowflake warehouse charges may apply.

    Execute arbitrary Snowflake SQL, including DDL/DML and multi-statement requests. Snowflake warehouse charges may apply.

  • snowflake__get_statementFreeGet statement status or its first result partition by handle.

    Get statement status or its first result partition by handle.

  • snowflake__get_result_partitionFreeFetch one result partition for a completed statement.

    Fetch one result partition for a completed statement.

  • snowflake__cancel_statementFreeCancel a running SQL statement by handle.

    Cancel a running SQL statement by handle.

  • snowflake__list_databasesFreeList databases visible to the token role.

    List databases visible to the token role.

  • snowflake__list_warehousesFreeList warehouses visible to the token role.

    List warehouses visible to the token role.

  • snowflake__list_rolesFreeList roles visible to the token role.

    List roles visible to the token role.

  • snowflake__list_usersFreeList users visible to the token role.

    List users visible to the token role.

  • snowflake__list_schemasFreeList schemas in a database.

    List schemas in a database.

  • snowflake__list_tablesFreeList tables in a database schema.

    List tables in a database schema.

  • snowflake__list_viewsFreeList views in a database schema.

    List views in a database schema.

  • snowflake__list_stagesFreeList stages in a database schema.

    List stages in a database schema.

  • snowflake__list_tasksFreeList tasks in a database schema.

    List tasks in a database schema.

  • snowflake__describe_tableFreeDescribe the columns of a table.

    Describe the columns of a table.

Give this to your agent

set up https://corespeed.io/SKILL.md
Get started