kairos-medallion-silver

Generate Spark SQL DDL, Mermaid ERD, and ALTER TABLE FK scripts from OWL ontologies for MS Fabric silver layers.

1|1|Updated Jan 3, 2026

Search Tags:#ontology #erd #delta-lake #ddl #spark-sql #silver-layer

Ready to run

npx skills add https://github.com/Cnext-eu/kairos-ontology-toolkit --skill kairos-medallion-silver

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: kairos-medallion-silver
Source: https://github.com/Cnext-eu/kairos-ontology-toolkit/tree/main/.github/skills/kairos-medallion-silver
Command: npx skills add https://github.com/Cnext-eu/kairos-ontology-toolkit --skill kairos-medallion-silver

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a guided approach to turning OWL ontologies into production-ready MS Fabric Delta Lake silver-layer projections. It encodes the R1-R16 common annotation vocabulary and S1-S8 Silver Fabric Warehouse behaviours, and it documents how to generate Spark SQL DDL, Mermaid ERD, and ALTER TABLE FK scripts for MS Fabric Warehouse.

Core Features & Use Cases

Silver-layer projection design guided by the R1-R16 annotations and S1-S8 warehouse rules.
Generates Spark SQL DDL, Mermaid ERD diagrams, and ALTER TABLE FK scripts for MS Fabric Warehouse.
Supports per-domain artifact generation and automated master ERD assembly across multiple domains.

Quick Start

Run the silver projection workflow on your ontology hub to produce the Spark SQL DDL, ERD, and FK scripts for the MS Fabric silver layer.

Frequently Asked Questions about kairos-medallion-silver

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

FAQPage Schema

How do I generate Spark SQL DDL for an MS Fabric silver layer from an OWL ontology?▼

You can generate Spark SQL DDL for an MS Fabric silver layer by running a silver projection workflow that applies R1-R16 annotation rules to your OWL ontology, producing deterministic DDL scripts stored under the output directory.

What is the best way to create Mermaid ERD diagrams for MS Fabric Delta Lake schemas?▼

Creating Mermaid ERD diagrams for MS Fabric Delta Lake is best handled by a silver-layer projection that translates OWL ontology structures into visual ERD outputs, automatically assembling master diagrams across multiple domains.

Can I automate foreign key creation in MS Fabric Warehouse using ontology annotations?▼

Yes, you can automate foreign key creation by applying S1-S8 Silver Fabric Warehouse rules to your ontology, which generates ALTER TABLE FK scripts designed specifically for MS Fabric Warehouse deployment.

How does a silver layer projection handle multi-domain schema generation in Delta Lake?▼

Silver layer projection handles multi-domain schema generation by processing each domain individually through R1-R16 annotation rules, then automatically assembling a master ERD to unify the Delta Lake schema artifacts.

Do I need a Kairos ontology hub to use silver layer projection rules for MS Fabric?▼

A Kairos ontology hub is required to apply the R1-R16 common annotation vocabulary and S1-S8 warehouse behaviors, as the silver layer projection is integrated with the kairos_ontology workflow to produce deterministic outputs.