dv-discover

Analyze source descriptions and propose a Pragmatic Data Vault model with hubs, links, and satellites.

35|7|Updated Apr 14, 2022
One-click install
npx skills add https://github.com/PatrickCuba/the_data_must_flow --skill dv-discover
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dv-discover
Source: https://github.com/PatrickCuba/the_data_must_flow/tree/main/dvos-skills/skills/dv-discover
Command: npx skills add https://github.com/PatrickCuba/the_data_must_flow --skill dv-discover

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Analyze one or more source descriptions (DDL, table with columns, CSV headers, or plain-language narratives) and propose a Pragmatic Data Vault model (hubs, links, satellites) that captures business keys and relationships.

Core Features & Use Cases

  • Analyzes input formats (DDL, headers, descriptions) to surface candidate hubs, links, and satellites
  • Spawns Source Profiler and Pattern Recommender subagents to map domain concepts, context, and loading patterns
  • Outputs a structured vault model proposal including hubs, links, satellites, and open questions for governance and confirmation
  • Use cases include rapid vault scoping for new source systems, vendor integrations, and descriptive-to-model transformations

Quick Start

Describe your source data (DDL, headers, or plain language) and request a Pragmatic Data Vault model.

Frequently Asked Questions about dv-discover

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

FAQPage Schema
How do I propose a Data Vault model from source DDL or plain language descriptions?

To propose a Data Vault model from source descriptions, analyze the DDL, CSV headers, or plain-language narratives to identify candidate hubs, links, and satellites capturing business keys and relationships. This generates a structured vault model proposal with open questions for governance.

What is a Pragmatic Data Vault model and how does it map to domain contexts?

A Pragmatic Data Vault model structures data into hubs, links, and satellites to capture business keys and relationships. It maps domain concepts to DDD contexts by profiling sources and recommending loading patterns to produce a structured model proposal.

Can I generate hubs, links, and satellites from multiple source representations at once?

Yes, you can generate hubs, links, and satellites from multiple source representations simultaneously. Analyzing various input formats like DDL or table columns surfaces candidate vault structures and maps domain concepts across the provided sources.

What is the best way to scope a Data Vault structure for a new vendor integration?

The best way to scope a Data Vault structure for a new vendor integration is to analyze the vendor's source descriptions. Profiling the source data surfaces candidate hubs, links, and satellites, yielding a structured model proposal with open questions for confirmation.

How do Data Vault model proposals handle missing relationship details in source profiles?

Data Vault model proposals handle missing relationship details by generating open questions for governance and confirmation. The analysis surfaces candidate structures from available source descriptions while explicitly flagging ambiguities for user validation.

Do I need DDL to generate a Data Vault model proposal, or are CSV headers enough?

You do not need DDL to generate a Data Vault model proposal; CSV headers or plain-language descriptions are sufficient. The analysis accepts various input formats to surface candidate hubs, links, and satellites from the provided source data.