Semantic Layer Demo — Data skill for Claude Code
Companion repo for KC Labs AI video: Semantic Layers - Bundled vs Standalone.
How to install Semantic Layer Demo
This entry records only its repository, not the path inside it, so there is no
exact command to give. Open kyle-chalmers/semantic-layer-demo and copy the folder into
~/.claude/skills/, or the file into ~/.claude/agents/.
What Semantic Layer Demo does
Companion repo for KC Labs AI video: Semantic Layers - Bundled vs Standalone. Demos Snowflake Semantic Views and dbt MetricFlow using TPCH sample data.
Alternatives in Data
- A Stock Data — A股全栈数据工具包 · 十一层架构 · 54端点 · 19数据源 · 零鉴权 Full-stack China A-share data toolkit for AI agents — 11 layers, 54 end 9.4k ★
- Run Demo — Run a ClawBio skill demo with built-in sample data 1.1k ★
- Token Dashboard — See where Claude Code is burning tokens - turn raw JSONL transcripts into local cost analytics, hotspot views 669 ★
README
Semantic Layers: The Skill Data Professionals Need Next
Companion repository for the [KC Labs AI](https://www.youtube.com/@kylechalmersdataai) video ["Semantic Layers: The Skill Data Professionals Need Next"](https://www.youtube.com/watch?v=2hiELj4Yavw). Demonstrates the **bundled vs standalone** approaches using Snowflake's TPCH sample data.
What You'll Learn
- What a semantic layer is and why AI made it essential
- The difference between bundled (Snowflake Semantic Views) and standalone (dbt MetricFlow) approaches
- How to create and query a Snowflake Semantic View
- How to define metrics with dbt MetricFlow and query them with
mf query
Architecture

Prerequisites
| Tool | Version | Purpose |
|---|---|---|
| Snowflake | Any edition | Warehouse + Semantic Views + Cortex Analyst |
| Snowflake CLI | Latest | Running SQL from terminal |
| dbt Core | 1.10+ | Transformation framework |
| dbt-snowflake | 1.10+ | Snowflake adapter for dbt |
| Python | 3.9+ | Runtime for dbt and MetricFlow |
Snowflake offers a free trial with $400 in credits (no credit card required).
Setup
- Clone the repo
git clone https://github.com/kyle-chalmers/semantic
Related Skills
Agenda Demo
Render a complete demo agenda from bundled sample data — no accounts, no config
Gl Fix Pipeline
Find why the GitLab pipeline for this branch's MR failed, fix it, and push or retry after you confirm. Pass "d
Rogue Database Engineering Skill
Expert database engineering for application data layers: schema and ERD design, relational modeling, indexing,
Snowflake Safe Query Skill
Write and run read-only Snowflake queries against the Gaiia reporting database under a four-layer safety guard
Memory Architecture
Configure, maintain, and troubleshoot the Qdrant vector database layer of Memory OS. Covers collection setup,
Redis Agentcore Settle Agent
Debt settlement agent for a fictional bank: Claude on Amazon Bedrock AgentCore Runtime with Redis Cloud as the
Related Agents
Wp Tailwind
CSS-to-Tailwind demo conversion — converts standard HTML/CSS demos into Tailwind-native HTML
Webship Workspace Demos
Use this agent to build, remove, or maintain demo distribution projects inside ~/workspace/demos/ using its cm
Demo Proposal
Raghav Saxena, Demo & Proposal Agent. Use for preparing tailored product demos and demo scripts, writing propo