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.
Scanned 6/2/2026
Install to Claude Code
Skills Directorynpx -y skills add agentskillexchange/skills --skill snowflake-query-optimizer-agent --agent claude-codeInstalls into .claude/skills of the current project.
Are you the author of Snowflake Query Optimizer Agent?
Add the live security badge to your README — it updates automatically with every re-scan.
[](https://www.skillsdirectory.com/skills/agentskillexchange-snowflake-query-optimizer-agent)More formats (shields.io, HTML) on the badges page.
---
name: "Snowflake Query Optimizer Agent"
slug: "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."
github_stars: 724
verification: "security_reviewed"
source: "https://github.com/snowflakedb/snowflake-connector-python"
category: "Data Extraction & Transformation"
framework: "OpenClaw"
tool_ecosystem:
github_repo: "snowflakedb/snowflake-connector-python"
github_stars: 724
---
# Snowflake Query Optimizer Agent
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.
## Installation
Use the upstream install or setup path that matches your environment:
- git clone git@github.com:snowflakedb/snowflake-connector-python.git
- python -m pip install -U pip setuptools wheel build
Requirements and caveats from upstream:
- # Snowflake Connector for Python
- [](https://github.com/snowflakedb/snowflake-connector-python/actions/workflows/build_test.yml)
- [](https://codecov.io/gh/snowflakedb/snowflake-connector-python)
Basic usage or getting-started notes:
- to create a wheel package using PEP-517 build:
- shell
- Find the snowflake_connector_python*.whl package in the ./dist directory.
- Source: https://github.com/snowflakedb/snowflake-connector-python
- Extracted from upstream docs: https://raw.githubusercontent.com/snowflakedb/snowflake-connector-python/HEAD/README.md
## Source
- [Agent Skill Exchange](https://agentskillexchange.com/skills/snowflake-query-optimizer-agent/)
Is this your skill, or is something wrong with this listing? Request removal or report an issue. Author removals are honored within 72 hours.
No comments yet. Be the first to comment!
