snowflake-connector

Bring-your-own-account Snowflake setup and safe, cost-aware querying.

v0.2.1Source ↗#snowflake#sql#data#warehouse

At a glance

Ships
2 skills
Install with
dev-standards
Needs
  • A Snowflake account you can already log into
  • A client on the machine: the Snowflake CLI, a driver, or an MCP server
Runs in
Claude Code only — it needs a shell and a checkout

Install

  1. 01 — Add the marketplace (once)

    /plugin marketplace add https://catylai.com/marketplace.json
  2. 02 — Install snowflake-connector

    /plugin install snowflake-connector@catylai

Bring your own account. The plugin ships no account identifier, no client id and no role name, because every one of those is specific to one organisation and wrong for everyone else.

The setup skill is a wizard: how to discover your own account identifier, which authentication method to choose between key-pair, OAuth and SSO and what each costs you, why a read-only role is the right default for an agent, and how to verify the connection actually works before you depend on it.

The querying skill treats cost as the hazard, the way an observability plugin treats an unbounded log read. A careless query against a large warehouse is a real bill, and the damage is invisible until it arrives. So: bound every query by time and LIMIT, size the warehouse deliberately and let it auto-suspend, understand why SELECT * on a wide columnar table is expensive rather than merely untidy, read a query profile, and treat a query whose expected row count you cannot state as one you have not finished thinking about.