# Snowflake MCP tools for AI agents

Source: https://corespeed.io/catalog/snowflake

Connect Snowflake to Claude Code, Codex, Cursor or any MCP agent through CoreSpeed. Query and administer Snowflake through the SQL API, including DDL/DML, asynchronous statements, partitioned results, and cancellation. Your agent works through your own Snowflake account and gets 15 Snowflake tools; CoreSpeed holds the credential, so the agent never sees the token. Calling it is free.

## Tools

- `snowflake__execute_query`: 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_statement`: Execute arbitrary Snowflake SQL, including DDL/DML and multi-statement requests. Snowflake warehouse charges may apply.
- `snowflake__get_statement`: Get statement status or its first result partition by handle.
- `snowflake__get_result_partition`: Fetch one result partition for a completed statement.
- `snowflake__cancel_statement`: Cancel a running SQL statement by handle.
- `snowflake__list_databases`: List databases visible to the token role.
- `snowflake__list_warehouses`: List warehouses visible to the token role.
- `snowflake__list_roles`: List roles visible to the token role.
- `snowflake__list_users`: List users visible to the token role.
- `snowflake__list_schemas`: List schemas in a database.
- `snowflake__list_tables`: List tables in a database schema.
- `snowflake__list_views`: List views in a database schema.
- `snowflake__list_stages`: List stages in a database schema.
- `snowflake__list_tasks`: List tasks in a database schema.
- `snowflake__describe_table`: Describe the columns of a table.

## Questions

### Does Snowflake need my own account?

Yes. Connect your own Snowflake account once; CoreSpeed holds the credential, and your agents get tools, never the token.

### What does Snowflake cost on CoreSpeed?

Calling it is free.

### Which agents can use Snowflake?

Any MCP client, such as Claude Code, Codex, or Cursor. Give your agent the setup line, and the tools join its tool list. Set up an agent: https://corespeed.io/docs/mcp

## Related pages

- [Snowflake for Claude Code, Codex, and Cursor](https://corespeed.io/integrations/snowflake): Query Snowflake from your agent under your own token and role. It finds the table, reads the columns, and runs the SQL you asked for.

## Links

- Catalog: https://corespeed.io/catalog
- Set up an agent: https://corespeed.io/SKILL.md
- Pricing: https://corespeed.io/pricing (Markdown: https://corespeed.io/pricing.md)
