{"id":"8611092c-836a-460f-8880-77dd19a6b7e5","shortId":"etWYTF","kind":"skill","title":"Snowflake Query Optimizer Agent","tagline":"Analyzes and optimizes Snowflake SQL queries using the QUERY_HISTORY and ACCESS_HISTORY views in ACCOUNT_USAGE. Identifies expensive scans, recommends clustering keys, and monitors warehouse credit consumption via WAREHOUSE_METERING_HISTORY.","description":"# Snowflake Query Optimizer Agent\n\nAnalyzes and optimizes Snowflake SQL queries using the QUERY_HISTORY and ACCESS_HISTORY views in ACCOUNT_USAGE. Identifies expensive scans, recommends clustering keys, and monitors warehouse credit consumption via WAREHOUSE_METERING_HISTORY.\n\n## Installation\n\nUse the upstream install or setup path that matches your environment:\n- git clone git@github.com:snowflakedb/snowflake-connector-python.git\n- python -m pip install -U pip setuptools wheel build\n\nRequirements and caveats from upstream:\n- # Snowflake Connector for Python\n- [![Build and Test](https://github.com/snowflakedb/snowflake-connector-python/actions/workflows/build_test.yml/badge.svg)](https://github.com/snowflakedb/snowflake-connector-python/actions/workflows/build_test.yml)\n- [![codecov](https://codecov.io/gh/snowflakedb/snowflake-connector-python/branch/main/graph/badge.svg?token=MVKSNtnLr0)](https://codecov.io/gh/snowflakedb/snowflake-connector-python)\n\nBasic usage or getting-started notes:\n- to create a wheel package using PEP-517 build:\n- shell\n- Find the snowflake_connector_python*.whl package in the ./dist directory.\n\n- Source: https://github.com/snowflakedb/snowflake-connector-python\n- Extracted from upstream docs: https://raw.githubusercontent.com/snowflakedb/snowflake-connector-python/HEAD/README.md\n\n## Source\n\n- [Agent Skill Exchange](https://agentskillexchange.com/skills/snowflake-query-optimizer-agent/)","tags":["snowflake","query","optimizer","agent","skills","agentskillexchange","agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex"],"capabilities":["skill","source-agentskillexchange","skill-snowflake-query-optimizer-agent","topic-agent-skills","topic-ai-agents","topic-ai-tools","topic-awesome-list","topic-claude-code","topic-codex","topic-cursor","topic-llm","topic-mcp","topic-npx-skills","topic-openclaw","topic-skills-catalog"],"categories":["skills"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/agentskillexchange/skills/snowflake-query-optimizer-agent","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add agentskillexchange/skills","source_repo":"https://github.com/agentskillexchange/skills","install_from":"skills.sh"}},"qualityScore":"0.454","qualityRationale":"deterministic score 0.45 from registry signals: · indexed on github topic:agent-skills · 8 github stars · SKILL.md body (1,434 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-05-18T19:12:32.309Z","embedding":null,"createdAt":"2026-05-18T13:19:30.240Z","updatedAt":"2026-05-18T19:12:32.309Z","lastSeenAt":"2026-05-18T19:12:32.309Z","tsv":"'-517':131 '/dist':143 '/gh/snowflakedb/snowflake-connector-python/branch/main/graph/badge.svg?token=mvksntnlr0)](https://codecov.io/gh/snowflakedb/snowflake-connector-python)':116 '/skills/snowflake-query-optimizer-agent/)':162 '/snowflakedb/snowflake-connector-python':148 '/snowflakedb/snowflake-connector-python/actions/workflows/build_test.yml/badge.svg)](https://github.com/snowflakedb/snowflake-connector-python/actions/workflows/build_test.yml)':112 '/snowflakedb/snowflake-connector-python/head/readme.md':155 'access':16,52 'account':20,56 'agent':4,40,157 'agentskillexchange.com':161 'agentskillexchange.com/skills/snowflake-query-optimizer-agent/)':160 'analyz':5,41 'basic':117 'build':97,107,132 'caveat':100 'clone':86 'cluster':26,62 'codecov':113 'codecov.io':115 'codecov.io/gh/snowflakedb/snowflake-connector-python/branch/main/graph/badge.svg?token=mvksntnlr0)](https://codecov.io/gh/snowflakedb/snowflake-connector-python)':114 'connector':104,137 'consumpt':32,68 'creat':125 'credit':31,67 'directori':144 'doc':152 'environ':84 'exchang':159 'expens':23,59 'extract':149 'find':134 'get':121 'getting-start':120 'git':85 'git@github.com':87 'github.com':111,147 'github.com/snowflakedb/snowflake-connector-python':146 'github.com/snowflakedb/snowflake-connector-python/actions/workflows/build_test.yml/badge.svg)](https://github.com/snowflakedb/snowflake-connector-python/actions/workflows/build_test.yml)':110 'histori':14,17,36,50,53,72 'identifi':22,58 'instal':73,77,92 'key':27,63 'm':90 'match':82 'meter':35,71 'monitor':29,65 'note':123 'optim':3,7,39,43 'packag':128,140 'path':80 'pep':130 'pip':91,94 'python':89,106,138 'queri':2,10,13,38,46,49 'raw.githubusercontent.com':154 'raw.githubusercontent.com/snowflakedb/snowflake-connector-python/head/readme.md':153 'recommend':25,61 'requir':98 'scan':24,60 'setup':79 'setuptool':95 'shell':133 'skill':158 'skill-snowflake-query-optimizer-agent' 'snowflak':1,8,37,44,103,136 'snowflakedb/snowflake-connector-python.git':88 'sourc':145,156 'source-agentskillexchange' 'sql':9,45 'start':122 'test':109 'topic-agent-skills' 'topic-ai-agents' 'topic-ai-tools' 'topic-awesome-list' 'topic-claude-code' 'topic-codex' 'topic-cursor' 'topic-llm' 'topic-mcp' 'topic-npx-skills' 'topic-openclaw' 'topic-skills-catalog' 'u':93 'upstream':76,102,151 'usag':21,57,118 'use':11,47,74,129 'via':33,69 'view':18,54 'warehous':30,34,66,70 'wheel':96,127 'whl':139","prices":[{"id":"bfc1a72d-7214-40ad-9d87-33fe228d8ba3","listingId":"8611092c-836a-460f-8880-77dd19a6b7e5","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"agentskillexchange","category":"skills","install_from":"skills.sh"},"createdAt":"2026-05-18T13:19:30.240Z"}],"sources":[{"listingId":"8611092c-836a-460f-8880-77dd19a6b7e5","source":"github","sourceId":"agentskillexchange/skills/snowflake-query-optimizer-agent","sourceUrl":"https://github.com/agentskillexchange/skills/tree/main/skills/snowflake-query-optimizer-agent","isPrimary":false,"firstSeenAt":"2026-05-18T13:19:30.240Z","lastSeenAt":"2026-05-18T19:12:32.309Z"}],"details":{"listingId":"8611092c-836a-460f-8880-77dd19a6b7e5","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"agentskillexchange","slug":"snowflake-query-optimizer-agent","github":{"repo":"agentskillexchange/skills","stars":8,"topics":["agent-skills","ai-agents","ai-tools","awesome-list","claude-code","codex","cursor","llm","mcp","npx-skills","openclaw","skills-catalog"],"license":"mit","html_url":"https://github.com/agentskillexchange/skills","pushed_at":"2026-05-18T19:02:17Z","description":"The open catalog of AI agent skills — 2,000+ security-scanned skills for Claude Code, Cursor, Codex, and more.","skill_md_sha":"3a0dccfca6fc9711f413ccdf6cee48863560a281","skill_md_path":"skills/snowflake-query-optimizer-agent/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/agentskillexchange/skills/tree/main/skills/snowflake-query-optimizer-agent"},"layout":"multi","source":"github","category":"skills","frontmatter":{"name":"Snowflake Query Optimizer Agent","description":"Analyzes and optimizes Snowflake SQL queries using the QUERY_HISTORY and ACCESS_HISTORY views in ACCOUNT_USAGE. Identifies expensive scans, recommends clustering keys, and monitors warehouse credit consumption via WAREHOUSE_METERING_HISTORY."},"skills_sh_url":"https://skills.sh/agentskillexchange/skills/snowflake-query-optimizer-agent"},"updatedAt":"2026-05-18T19:12:32.309Z"}}