Connect Claude Code to Snowflake with the CLI and MCP
Watch Claude Code run Snowflake SQL through the Snowflake CLI, then connect the Snowflake MCP to Claude Code and Claude Desktop.
Who it's for: Anyone who writes SQL in Snowflake or another SQL-based warehouse.
The problem: Effective SQL queries can take a very long time to write by hand, and an AI tool can only help once it can reach your warehouse.
Claude Code connects through the Snowflake CLI with MFA, runs queries in plan mode, and asks before anything destructive. Two parallel sessions build a data catalog and answer an analysis question. The Snowflake MCP then goes into Claude Code and Claude Desktop.
Takeaways:
- The CLI takes fewer tokens and exports data better; the MCP also works in Claude Desktop.
- Use Snowflake CLI 3.0 or above to export results as a CSV.
- Review the plan before you bypass permissions.