data-context-extractor

Extract analyst knowledge into company-specific data analysis skills.

1|Updated Mar 30, 2026
One-click install
npx skills add https://github.com/ilove323/comlan-skills --skill data-context-extractor-ilove323
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-context-extractor
Source: https://github.com/ilove323/comlan-skills/tree/main/data/skills/data-context-extractor
Command: npx skills add https://github.com/ilove323/comlan-skills --skill data-context-extractor-ilove323

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

Captures analysts' institutional knowledge and converts it into reusable, company-specific data analysis skills to reduce onboarding time, prevent inconsistent metrics, and avoid common query mistakes.

Core Features & Use Cases

  • Interactive schema discovery: Guides connection to BigQuery, Snowflake, PostgreSQL/Redshift, or Databricks to list datasets, surface key tables, and inspect schema details.
  • Analyst-driven knowledge capture: Runs targeted questions for entity disambiguation, primary identifiers, metric formulas, standard filters, and common gotchas to produce clear documentation.
  • Skill generation and packaging: Produces a structured skill directory with SKILL.md, domain reference files, SQL dialect notes, example queries, and a packaged distributable for delivery or iteration.
  • Use case: Rapidly bootstrap a Snowflake-backed "company-data-analyst" skill that standardizes KPI definitions and common query patterns for a new analytics hire.

Quick Start

Use the data-context-extractor to build a new company data skill by connecting to your warehouse and answering guided discovery questions.

Frequently Asked Questions about data-context-extractor

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I document institutional knowledge for a data warehouse to standardize metrics?

You can document institutional knowledge for a data warehouse by running interactive schema discovery and targeted analyst interviews to capture metric formulas, entity disambiguation, and common gotchas into structured reference files.

What is the best way to bootstrap company-specific data analysis skills for new hires?

The best way to bootstrap company-specific data analysis skills is to extract existing analyst knowledge through guided discovery questions and package it into a structured skill directory with SKILL.md and SQL examples.

Does this data context extraction approach work with Snowflake, BigQuery, and PostgreSQL?

Yes, this data context extraction approach works with Snowflake, BigQuery, PostgreSQL, Redshift, and Databricks. It guides connection to these warehouses to list datasets, surface key tables, and inspect schema details for documentation.

How do I capture common SQL query mistakes and standard filters from analytics teams?

You capture common SQL query mistakes and standard filters by running targeted interview questions focused on metric definitions, primary identifiers, and common gotchas, then converting the answers into reusable domain reference files.

Can I generate a packaged distributable skill with SQL dialect guidance and example queries?

Yes, you can generate a packaged distributable skill. The extraction process produces a structured skill directory containing SKILL.md, domain reference files, SQL dialect notes, and example queries ready for delivery or iteration.

When do I need to create a company-specific data context skill instead of writing ad-hoc SQL?

You need to create a company-specific data context skill during onboarding, documentation updates, or analytics troubleshooting to reduce onboarding time, prevent inconsistent metrics, and avoid common query mistakes across the team.