kairos-medallion-projection

Generate dbt Core projects for bronze-to-silver transformations using ontologies and SHACL constraints.

1|1|Updated Jan 3, 2026
One-click install
npx skills add https://github.com/Cnext-eu/kairos-ontology-toolkit --skill kairos-medallion-projection
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: kairos-medallion-projection
Source: https://github.com/Cnext-eu/kairos-ontology-toolkit/tree/main/.github/skills/kairos-medallion-projection
Command: npx skills add https://github.com/Cnext-eu/kairos-ontology-toolkit --skill kairos-medallion-projection

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill automates the creation of a dbt Core project that implements bronze-to-silver transformations driven by domain ontologies, bronze vocabularies, and source-to-domain mappings. It provides a reproducible, ontology-driven framework to generate staging and silver models with integrated SHACL tests, enabling faster analytics pipeline development.

Core Features & Use Cases

  • Ontology-driven dbt project generation for bronze-to-silver pipelines using domain ontologies, source vocabulary, and SKOS mappings.
  • Automatic creation of staging models and silver domain models structured under a standard medallion output layout.
  • Incorporation of SHACL-derived tests into the dbt workflow for data quality validation.
  • Use Case: accelerate multi-domain analytics projects by reusing a single ontology-driven projection to deploy consistent pipelines across domains.

Quick Start

Run the medallion projection to generate a dbt Core project that transforms bronze data into silver domain tables.

Frequently Asked Questions about kairos-medallion-projection

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

FAQPage Schema
How do I generate dbt Core models for bronze-to-silver transformations?

Generate dbt Core models for bronze-to-silver transformations by using ontology-driven projection to automatically create staging and silver domain tables with integrated SHACL tests. This approach ensures consistent schema and data quality validation across multi-domain analytics pipelines.

Can I use SKOS mappings and SHACL constraints to drive dbt project generation?

Yes, SKOS mappings and SHACL constraints can drive dbt project generation to automate bronze-to-silver transformations. This framework translates domain ontologies and source vocabularies into standardized staging and silver models with deterministic data quality testing artifacts.

What is the best way to automate data quality validation in dbt pipelines?

Automate data quality validation in dbt pipelines by incorporating SHACL-derived tests directly into the generated staging and silver models. This ontology-driven approach ensures that schema constraints and data quality checks are consistently applied across all domain analytics transformations.

Do I need domain ontologies to build a medallion data architecture with dbt?

Yes, domain ontologies are required to build a medallion architecture with this skill. They provide the necessary structural framework and source-to-domain mappings needed to deterministically generate standardized staging models, silver domain tables, and validation checks.

How does ontology-driven analytics pipeline development handle multi-domain projects?

Ontology-driven analytics pipeline development handles multi-domain projects by reusing a single ontology-driven projection to deploy consistent pipelines across domains. This standardizes the output structure, dependency handling, and validation checks for the entire dbt Core workspace.

What are the limitations of ontology-driven dbt medallion projections?

Ontology-driven dbt medallion projections focus specifically on bronze-to-silver transformations and do not handle gold layer outputs. They require predefined domain ontologies, source vocabularies, and SKOS mappings to produce staging and silver models deterministically.