PromptShop

Data Context Extractor

The Data Context Extractor skill helps analysts create or improve data analysis skills tailored to their company's specific data warehouse.

Install

npx promptshop add data-context-extractor

Details

What This Skill Does

The Data Context Extractor skill helps analysts create or improve data analysis skills tailored to their company's specific data warehouse. It guides users through connecting to their database, exploring the schema, and defining key entities and identifiers. This skill streamlines the process of building domain-specific data analysis tools.

When to Use

  • Create a new data analysis skill for a specific data warehouse.
  • Improve an existing data analysis skill with domain-specific knowledge.
  • Connect to a data warehouse and explore its schema.
  • Identify key tables and columns for analysis.
  • Define company-specific entities and identifiers.
  • Bootstrap a data analysis skill from scratch.

Key Features

  • Supports multiple data warehouse types (BigQuery, Snowflake, etc.).
  • Guides users through database connection and schema discovery.
  • Asks targeted questions to disambiguate entities and identifiers.
  • Provides sample exploration queries for different dialects.
  • Offers both bootstrap and iteration modes for skill creation.
  • Helps define relationships between different entity types.