Skip to content
Back to skills

Snowflake Query Optimizer Agent

ASecurity

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.

  • 36 stars
  • 0 votes
  • 0 copies
  • 1 view
  • Added June 2, 2026
ai-agentspythongoshellsqlgitsecurity

Security analysis

A92/100
  • mediumInstalls packages at runtime which could introduce malicious dependencies

Pro shows the line behind each finding and how to fix it

Scanned June 2, 2026

npx -y skills add agentskillexchange/skills --skill snowflake-query-optimizer-agent --agent claude-code

Installs 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 with every re-scan.

Security grade badge for Snowflake Query Optimizer Agent
[![Security: A — Skills Directory](https://www.skillsdirectory.com/api/skills/agentskillexchange-snowflake-query-optimizer-agent/badge)](https://www.skillsdirectory.com/skills/agentskillexchange-snowflake-query-optimizer-agent)

More formats (shields.io, HTML) on the badges page. Keep it an A: scan every change in CI with Pro.

Download with Pro
SKILL.md
---
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
- [![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)
- [![codecov](https://codecov.io/gh/snowflakedb/snowflake-connector-python/branch/main/graph/badge.svg?token=MVKSNtnLr0)](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/)

Attribution

agentskillexchangeView sourceSee grades on GitHubMore from agentskillexchange

Is this your skill, or is something wrong with this listing? Request removal or report an issue. Author removals are honored within 72 hours.

Comments

Loading comments…

Newsletter

Get the weekly list of safe new skills, and the ones we pulled.