skills.rest
Cnext-eu
Cnext-euOFFICIAL
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/Cnext-eu/kairos-ontology-toolkit --skill kairos-medallion-silver
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
skmtcskmtc
19

skmtc-lang-kotlin

Generate and validate Kotlin source structures for SKMTC OpenAPI code generators.

Official
Advanced
abdullah1854abdullah1854
1

fabric-helper

Generate Delta Lake and Spark SQL queries for Fabric Lakehouse and Warehouse.

Community
Intermediate
Aurora-AIAurora-AI
1

Elysian Integrator

Integrate AI agents with Postgres databases and orchestrate workflows via @start and @listen.

Community
Advanced
databricks-solutionsdatabricks-solutions
5

silver-layer-setup

Orchestrate Silver layer pipeline creation with Spark Declarative Pipelines and Delta Live Tables.

Official
Advanced