skills.rest
oxy-hq
oxy-hqOFFICIAL
Explore all skills by this author →
Website𝕏@askoxygenGitHub

oxy-semantic-layer

Generate Oxy semantic layer view and topic files from database schemas.

1|1|Updated Dec 19, 2025
Search Tags:#analytics#validation#yaml#views#semantic layer#topics#database-schemas
One-click install
npx skills add https://github.com/oxy-hq/skills --skill oxy-semantic-layer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: oxy-semantic-layer
Source: https://github.com/oxy-hq/skills/tree/main/skills/oxy-semantic-layer
Command: npx skills add https://github.com/oxy-hq/skills --skill oxy-semantic-layer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Build and maintain Oxy semantic layer files (views and topics) for analytics. Use when the user asks to create, update, or validate Oxy semantic layers, view files, topic files, or needs help understanding database schemas for semantic layer creation.

Core Features & Use Cases

  • Create and maintain semantics/views and topics from database schemas
  • Validate and test semantic layer with Oxy tooling
  • Progressive loading and templates for quick, safe deployment

Quick Start

Ask Claude to generate semantic layer views and topics from my database schemas.

Frequently Asked Questions about oxy-semantic-layer

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

FAQPage Schema
How do I generate a semantic layer from my database schema?▼

A semantic layer in analytics is a set of YAML-structured view and topic definitions that maps database schemas into business-ready metrics. It translates raw schemas into governed topics for consistent reporting.

How do I validate and test semantic layer files before deployment?▼

Validate and test semantic layer files by running dedicated validation commands against the generated YAML views and topics. This workflow testing ensures safe, production-ready outputs before deployment.

Can I update existing view and topic definitions without breaking analytics?▼

Yes, you can update existing view and topic definitions by applying progressive loading guidance during maintenance. This approach incrementally validates changes to YAML files, ensuring analytics remain safe.

Do I need YAML files to build and maintain an analytics semantic layer?▼

Yes, YAML-structured files are required to build and maintain this semantic layer. The system uses YAML formats to define views and topics, ensuring structured and validated analytics outputs.

What are the limitations when creating topics from large database schemas?▼

When creating topics from large database schemas, limitations include processing complexity and validation overhead. Progressive loading templates are provided to manage these constraints and ensure safe deployment.

Related Skills

Explore More Data & Analytics Skills→
exploreomniexploreomni
30

omni-to-snowflake-semantic-view

Convert Omni Analytics topics into Snowflake Semantic View YAML definitions.

Official
Advanced
GodSpeedAIGodSpeedAI
1

sea-last-mile

Enforce a post-codegen last-mile workflow for generated adapters.

Official
Intermediate
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
tecnologia-ibtechtecnologia-ibtech

metabase-schema

Explore Metabase-connected database schemas, tables, and field metadata.

Community
Intermediate