Does this skill require manual SQL knowledge?

While it helps, the skill automates schema discovery and uses a pattern cache to suggest proven query strategies for common business questions based on your specific database structure.

How does the kernel management work?

The skill uses the 'uv' Python tool to manage a dedicated kernel that starts automatically on the first query. This allows for execution of SQL and post-processing of data using libraries like Polars and Pandas.

Can it handle very large datasets?

Yes, the skill includes specialized guardrails for tables with millions of rows, enforcing date filtering and providing tips to avoid expensive joins on initial exploration queries.

Which data warehouses are supported?

The skill supports common dialects including Snowflake, PostgreSQL, and BigQuery, with built-in logic to handle specific syntax differences in dates and casing.

SQL Data Warehouse Analyst

Name: SQL Data Warehouse Analyst
Author: astronomer

byastronomer

•

データサイエンスとML

Queries data warehouses and analyzes business metrics to provide actionable insights directly within Claude Code.

This skill empowers Claude to act as a sophisticated data analyst by connecting to various data warehouses to answer complex business questions. It leverages a unique dual-layer caching system—Concepts for table mapping and Patterns for query strategies—ensuring efficient, accurate, and repeatable SQL execution. The skill automatically manages a dedicated Python kernel for processing results, handles schema discovery across your codebase, and provides specific guardrails for querying massive datasets to ensure performance and cost-efficiency.

主な機能

01Multi-dialect SQL support for Snowflake, PostgreSQL, and BigQuery

02Safety-first querying for large-scale data with automatic filtering recommendations

03Pattern and Concept caching to reuse proven query strategies and table mappings

04Automated Python kernel management for SQL execution and data processing via Polars or Pandas

05Intelligent table discovery through codebase analysis (Grep/SQL files) and schema lookups

0677 GitHub stars

ユースケース

01Answering complex business questions like 'who uses feature X' or 'what is the count of Y'

02Discovering and mapping data concepts to physical warehouse table definitions

03Performing trend analysis and metrics reporting on data warehouse tables

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add astronomer/agents analyzing-data

For use in Claude.ai and ChatGPT

Download Skill