Execute SQL query against Snowflake data warehouse
Executes SQL queries against Snowflake data warehouse with configurable output formats.
/plugin marketplace add haggler09/claude-haggler-skills/plugin install converter-skills@claude-haggler-skills<query or -f file.sql> [options]snowflake-query/commands/Execute SQL queries against Snowflake using the Python connector.
$ARGUMENTS: SQL query string or options including -f <file.sql>Ensure required environment variables are set:
SNOWFLAKE_ACCOUNT: Account identifierSNOWFLAKE_USER: UsernameSNOWFLAKE_PASSWORD, SNOWFLAKE_PRIVATE_KEY_PATH, or SNOWFLAKE_AUTHENTICATOR# Inline query
/snowflake-query -q "SELECT * FROM my_table LIMIT 10"
# From SQL file
/snowflake-query -f query.sql
# With table format output
/snowflake-query -q "SHOW TABLES" --format table
# Export to CSV
/snowflake-query -q "SELECT * FROM users" --format csv -o users.csv
# Test connection
/snowflake-query --dry-run
Run the query script using uvx:
# For JSON/CSV output
uvx --with snowflake-connector-python python skills/snowflake-query/scripts/query.py $ARGUMENTS
# For table output (include tabulate)
uvx --with snowflake-connector-python --with tabulate python skills/snowflake-query/scripts/query.py $ARGUMENTS
Check if --format table is in arguments to include tabulate dependency.