ghostinthedata-info

20 mods across 1 repository, 5 stars between them.

skills CLAUDE.md

03

ghostinthedata-info/skills

Instructions file

Instructions for ghostinthedata-info/skills, covering governance, agent skills, issue tracker, triage labels and domain docs.

5 2mo ago A 403 tokens original MIT

data-modelling

04

ghostinthedata-info/skills

Skill Claude CodeCodex

Base orchestrator for designing analytics data models. Drives the Kimball grain-first workflow, profiling source data first, then routing to the right deep-dive — SCD1, SCD2, backfilling, and fact-table design. Use when the user is designing or refactoring dimensions, facts, a star schema, or a gold/presentation…

5 2mo ago A 96 tokens original MIT

ghostinthedata-info/skills

Skill Claude CodeCodex

Classify data by sensitivity and apply the right controls — access control, masking/obfuscation, encryption, and auditing — driven by regulatory and confidentiality requirements. Covers the four A's (authentication, authorization, access, auditing), confidentiality levels, PII/PHI, and least privilege. Use when…

5 2mo ago A 88 tokens original MIT

gather-requirements

06

ghostinthedata-info/skills

Skill Claude CodeCodex

Elicit and pin down requirements for a data pipeline or model before any code. Nails grain, sources, consumers, definitions, freshness/volume SLAs, historization, access patterns, and acceptance criteria. Use when the user starts a new pipeline/model/report, or when scope is fuzzy and you need to prevent rework and…

5 2mo ago A 74 tokens original MIT

ghostinthedata-info/skills

Skill Claude CodeCodex

Use this skill whenever a data or reporting incident needs to be identified, classified, triaged, communicated, resolved, or reviewed. Triggers include: a pipeline failure, delayed/late data, a transformation defect, a replication or ingestion failure, duplicate or missing records, a dashboard showing wrong or stale…

5 2mo ago A 152 tokens original MIT

performance-tuning

08

ghostinthedata-info/skills

Skill Claude CodeCodex

A methodology for tuning slow pipelines and queries — measure first, find the critical path, then fix with partition pruning, incremental processing, idempotent merges, and dependency cleanup. Tool-agnostic spine plus engine-specific reference files for traditional RDBMS (Oracle/SQL Server), cloud warehouses…

5 2mo ago A 152 tokens original MIT

solution-design

09

ghostinthedata-info/skills

Skill Claude CodeCodex

Elicit and pin down requirements for a data pipeline, model, or report before any code, then produce a solution-design doc. Nails value (pains/gains/profiles), grain, sources & authority, definitions, freshness/volume SLAs, historization, access patterns, and acceptance criteria. Produces a one-page-style design with…

5 2mo ago A 121 tokens original MIT

profile-data

10

ghostinthedata-info/skills

Skill Claude CodeCodex

Profile a new or unfamiliar dataset BEFORE building on it. Produces row counts, cardinality, null/blank analysis, key-uniqueness checks, distribution/outlier checks, type/precision audit, and an optional saved baseline for drift detection. Use when the user is about to model, ingest, or join a dataset they don't yet…

5 2mo ago A 88 tokens original MIT

test-data

11

ghostinthedata-info/skills

Skill Claude CodeCodex

Build a defensible data test plan — what to test (uniqueness, referential integrity, nulls, accepted values, freshness, volume/variance), severity (error vs warn), and where tests run (Write-Audit-Publish). Use when adding tests to a model/pipeline, designing data-quality gates, or deciding what "good data" means here.

5 2mo ago A 77 tokens original MIT

present-data

12

ghostinthedata-info/skills

Skill Claude CodeCodex

Turn analysis into a decision — work in the explanatory (not exploratory) space, lock Who/What/How, lead with the Big Idea, choose the right visual, declutter, and direct attention so the audience acts. Use when presenting results, building a dashboard, writing an analytical summary, or whenever a chart needs to drive…

5 2mo ago A 77 tokens original MIT

set-based-sql

13

ghostinthedata-info/skills

Skill Claude CodeCodex

Think in sets, not loops — replace cursors and row-by-row procedural code with declarative constraints, window functions, GROUPING SETS/CUBE/ROLLUP, CASE, set operations, and auxiliary tables. Use when SQL is being written procedurally, a transform loops over rows, or a query could be expressed declaratively.

5 2mo ago A 73 tokens original MIT

sql-antipatterns

14

ghostinthedata-info/skills

Skill Claude CodeCodex

Recognise and avoid the common SQL schema and query design traps — comma-separated lists, adjacency-only trees, missing foreign keys, EAV, polymorphic associations, FLOAT money, SELECT , unplanned indexes, and broken NULL logic. Use when designing a schema, reviewing a migration, or diagnosing a query that's slow…

5 2mo ago A 76 tokens original MIT

sql-style

15

ghostinthedata-info/skills

Skill Claude CodeCodex

Write portable, readable SQL — ISO-standard syntax, consistent ISO-11179 naming, set-oriented formatting, and constraints in the schema. Use when establishing SQL conventions for a repo, reviewing query craft, or naming tables and columns.

5 2mo ago A 49 tokens original MIT

de-feedback

16

ghostinthedata-info/skills

Skill Claude CodeCodex

Structured, honest, empathetic feedback for data engineers at any level (junior, mid, senior, principal/staff). Identifies the engineer's expected maturity level from their position, then scores observed performance against SFIA-anchored, industry-benchmarked behaviours across technical, delivery/ops, collaboration…

5 2mo ago A 189 tokens original MIT

caveman

17

ghostinthedata-info/skills

Skill Claude CodeCodex

Ultra-compressed communication mode. Cuts token usage 75% by dropping filler, articles, and pleasantries while keeping full technical accuracy. Use when user says "caveman mode", "talk like caveman", "use caveman", "less tokens", "be brief", or invokes /caveman.

5 2mo ago A 68 tokens copy · 100% MIT

teach

18

ghostinthedata-info/skills

Skill Claude CodeCodex

Teach the user a new skill or concept, within this workspace.

5 2mo ago A 15 tokens copy · 84% MIT

write-a-skill

19

ghostinthedata-info/skills

Skill Claude CodeCodex

Create new agent skills with proper structure, progressive disclosure, and bundled resources. Use when user wants to create, write, or build a new skill.

5 2mo ago A 35 tokens copy · 100% MIT

setup-ghost-skills

20

ghostinthedata-info/skills

Skill Claude CodeCodex

Sets up an ## Agent skills block in AGENTS.md/CLAUDE.md and docs/agents/ so the ghost-skills pack knows this repo's warehouse platform & SQL dialect, transform/orchestration tooling, issue tracker (GitHub or local markdown), triage label vocabulary and domain-doc layout. Run before first use of profile-data…

5 2mo ago A 114 tokens original MIT