nathankoerschner/snowsql
agents/dot-agents/skills/snowsql/SKILL.md
Connect to Snowflake via SnowSQL
databases
Updated May 31, 2026
$ install --global
skillsauthnpx skillsauth add nathankoerschner/dotfiles snowsqlInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: May 29, 2026, 6:49 AM156.2s1 file scanned
SKILL.md
- description:
- Connect to Snowflake via SnowSQL
- argument-hint:
- [connection-name]
- allowed-tools:
- Bash(snowsql:*)
- name:
- snowsql
Snowflake Connection: $1
You are now connected to Snowflake using the connection named "$1".
Connection configuration is stored in ~/.snowsql/config. You can read this file to see available connections if needed.
To run queries, use the snowsql command: snowsql -c $1 -q "YOUR SQL QUERY HERE"
Important guidelines:
- Always use
-c $1to specify the connection - Use
-q "query"for single queries - For queries returning large results, add
--output-format csvor--output-format json - Use
LIMITclauses when exploring data to avoid overwhelming output - The connection uses schema from config (typically RETAIL)
Example usage:
- List tables:
snowsql -c $1 -q "SHOW TABLES;" - Query data:
snowsql -c $1 -q "SELECT * FROM table_name LIMIT 10;" - Check warehouse:
snowsql -c $1 -q "SELECT CURRENT_WAREHOUSE();"
Wait for the user's instructions on what queries to run.
Related Skills
nathankoerschner/simplify
development
VerifiedTrustedCommunity
Simplifies and refines code for clarity, consistency, and maintainability while preserving all functionality. Use when asked to simplify, refactor lightly, clean up, or improve recently modified code without behavior changes.
SKILL.mdUpdated Jun 12, 2026
nathankoerschner/handoff
tools
VerifiedTrustedCommunity
Write a path-free, clipboard-ready handoff prompt that lets another agent investigate, discuss, or pick up a specific task.
SKILL.mdUpdated Jun 12, 2026
nathankoerschner/grill-me
testing
VerifiedTrustedCommunity
Interview the user relentlessly about a plan or design until reaching shared understanding, resolving each branch of the decision tree. Use when user wants to stress-test a plan, get grilled on their design, or mentions "grill me".
SKILL.mdUpdated Jun 12, 2026
nathankoerschner/autoreview
development
VerifiedTrustedCommunity
Run a Pi-based structured code review as a closeout check on local, branch, PR, or commit changes before commit or ship.
SKILL.mdUpdated Jun 10, 2026