How do I install the Database Snowflake skill?

Run npx skillmds@latest add incidentfox/database-snowflake in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Database Snowflake safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Database Snowflake?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Database Snowflake free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Database Snowflake?

incidentfox (@incidentfox) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Database Snowflake by incidentfox — Agent Skill

Name: Database Snowflake
Author: incidentfox

File contents

Snowflake Data Warehouse

Authentication

IMPORTANT: Credentials are injected automatically by a proxy layer. Do NOT check for SNOWFLAKE_PASSWORD in environment variables - it won't be visible to you. Just run the scripts directly; authentication is handled transparently.

Configuration environment variables you CAN check (non-secret):

SNOWFLAKE_ACCOUNT - Snowflake account identifier
SNOWFLAKE_WAREHOUSE - Compute warehouse
SNOWFLAKE_DATABASE - Default database
SNOWFLAKE_SCHEMA - Default schema

MANDATORY: Schema-First Investigation

Always get the schema before writing queries.

GET SCHEMA / LIST TABLES → DESCRIBE TABLE → EXECUTE QUERY

Available Scripts

All scripts are in .claude/skills/database-snowflake/scripts/

get_schema.py - Get Database Schema (START HERE)

python .claude/skills/database-snowflake/scripts/get_schema.py

list_tables.py - List Tables

python .claude/skills/database-snowflake/scripts/list_tables.py [--database DB] [--schema SCHEMA]

describe_table.py - Table Column Details

python .claude/skills/database-snowflake/scripts/describe_table.py --table TABLE_NAME [--database DB] [--schema SCHEMA]

execute_query.py - Run SQL Queries

python .claude/skills/database-snowflake/scripts/execute_query.py --query "SELECT * FROM fact_incident ORDER BY started_at DESC LIMIT 10" [--limit 100]

Investigation Workflow

Incident Data Analysis

1. get_schema.py (understand available tables)
2. execute_query.py --query "SELECT * FROM fact_incident WHERE sev = 'SEV-1' ORDER BY started_at DESC LIMIT 10"
3. execute_query.py --query "SELECT c.customer_name, ic.estimated_arr_at_risk_usd FROM fact_incident_customer_impact ic JOIN dim_customer c ON ic.customer_id = c.customer_id WHERE ic.incident_id = '<id>'"

---name: database-snowflakedescription: Snowflake data warehouse queries and schema inspection. Use when running SQL queries against Snowflake, listing tables, or inspecting schemas.---# Snowflake Data Warehouse## Authentication**IMPORTANT**: Credentials are injected automatically by a proxy layer. Do NOT check for `SNOWFLAKE_PASSWORD` in environment variables - it won't be visible to you. Just run the scripts directly; authentication is handled transparently.Configuration environment variables you CAN check (non-secret):- `SNOWFLAKE_ACCOUNT` - Snowflake account identifier- `SNOWFLAKE_WAREHOUSE` - Compute warehouse- `SNOWFLAKE_DATABASE` - Default database- `SNOWFLAKE_SCHEMA` - Default schema---## MANDATORY: Schema-First Investigation**Always get the schema before writing queries.**```GET SCHEMA / LIST TABLES → DESCRIBE TABLE → EXECUTE QUERY```## Available ScriptsAll scripts are in `.claude/skills/database-snowflake/scripts/`### get_schema.py - Get Database Schema (START HERE)```bashpython .claude/skills/database-snowflake/scripts/get_schema.py```### list_tables.py - List Tables```bashpython .claude/skills/database-snowflake/scripts/list_tables.py [--database DB] [--schema SCHEMA]```### describe_table.py - Table Column Details```bashpython .claude/skills/database-snowflake/scripts/describe_table.py --table TABLE_NAME [--database DB] [--schema SCHEMA]```### execute_query.py - Run SQL Queries```bashpython .claude/skills/database-snowflake/scripts/execute_query.py --query "SELECT * FROM fact_incident ORDER BY started_at DESC LIMIT 10" [--limit 100]```---## Investigation Workflow### Incident Data Analysis```1. get_schema.py (understand available tables)2. execute_query.py --query "SELECT * FROM fact_incident WHERE sev = 'SEV-1' ORDER BY started_at DESC LIMIT 10"3. execute_query.py --query "SELECT c.customer_name, ic.estimated_arr_at_risk_usd FROM fact_incident_customer_impact ic JOIN dim_customer c ON ic.customer_id = c.customer_id WHERE ic.incident_id = '<id>'"```

Frequently asked questions

Database Snowflake