powerbi-duckdb-lakehouse SKILL.md skillA

powerbi-duckdb-lakehouse from santoshkanthety/powerbi-agent is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add santoshkanthety/powerbi-agent/powerbi-duckdb-lakehouse@git:20261005.504c1f5

Pins git:20261005.504c1f5 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
santoshkanthety/powerbi-agent
Path
skills/powerbi-duckdb-lakehouse/SKILL.md
Versions recorded
1
Latest version
git:20261005.504c1f5, committed Oct 5, 2026
Size
8,189 bytes
Repository stars
3
License
MIT

Query Fabric lakehouse Delta tables, warehouse data and OneLake Parquet with DuckDB — locally or inside a Fabric notebook — for data profiling, freshness and quality checks, and reconciling a semantic model against its source without paying Spark cold-start or capacity cost. Use when the user mentions: DuckDB, duckdb, query Delta locally, read Parquet without Spark, profile lakehouse data, data freshness check, data quality check, row count reconciliation, compare model to source, cheap…

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# DuckDB over lakehouse and OneLake data

DuckDB is an in-process SQL engine that reads Parquet and Delta directly. Pointed at OneLake,
it answers most of the questions people reach for Spark to answer — row counts, distincts,
null rates, min/max dates, a reconciliation against what the semantic model reports — with no
cluster, no cold start, and **no capacity consumption**.

That last point is the reason this skill exists. A freshness check that costs nothing can run
on every delivery; one that opens a Spark session and smooths CU forward for 24 hours cannot.

Reach for DuckDB first. Reach for `powerbi-spark-livy` only when the volume or the
transformation genuinely needs distributed compute.

## Where it runs

| Location | Use when |
|---|---|
| **Local** (your machine, this CLI) | Profiling, reconciliation, quality gates, anything in a delivery loop. Needs OneLake access from the host. |
| **Inside a Fabric notebook** | Data is large enough that pulling it to the host is the bottleneck, but small enough that Spark is overkill. Still cheaper than a Spark session on the same notebook. |

## Setup

```bash
pip install duckdb        # or: uv pip install duckdb
```
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add santoshkanthety/powerbi-agent/powerbi-duckdb-lakehouse@sha256:846262d0de70a31e

The line at the top of this page pins the label git:20261005.504c1f5, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_opghsnquenraz4kd.svg)](https://markdownregistry.com/a/art_opghsnquenraz4kd)

2 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 1 version of this file, committed on Oct 5, 2026.

versioncommittedcommitsizeaudit
git:20261005.504c1f5 latest2026-10-05 504c1f5 8,189 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (8189 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

santoshkanthety/powerbi-agent · 3 stars · license MIT · pushed 2026-10-05 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_opghsnquenraz4kd
GET https://markdownregistry.com/api/v1/resolve?ref=santoshkanthety/powerbi-agent/powerbi-duckdb-lakehouse
GET https://markdownregistry.com/api/v1/blob/846262d0de70a31ee024aab2832ae8e4b35bb31a46b40883328dbef6612efc37

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from santoshkanthety/powerbi-agent

powerbi-audit-tenant-settings SKILL.md skill
santoshkanthety/powerbi-agent · skills/powerbi-audit-tenant-settings/SKILL.md · Automatically invoke this skill whenever the user asks about Fabric tenant settings or Power BI tenant settings or…
git:20260808.22d6d33 · audit A · 3 stars
powerbi-bpa-rules SKILL.md skill
santoshkanthety/powerbi-agent · skills/powerbi-bpa-rules/SKILL.md · Interactive BPA rule generation for Power BI semantic models; guided discovery, model investigation, and expert rule…
git:20260808.22d6d33 · audit A · 3 stars
powerbi-c-sharp-scripting SKILL.md skill
santoshkanthety/powerbi-agent · skills/powerbi-c-sharp-scripting/SKILL.md · Writing and executing C# scripts and macros against Power BI semantic models using Tabular Editor 2/3. Automatically…
git:20260808.22d6d33 · audit A · 3 stars
powerbi-connect-pbid SKILL.md skill
santoshkanthety/powerbi-agent · skills/powerbi-connect-pbid/SKILL.md · TOM and ADOMD.NET guidance via PowerShell for connecting to Power BI Desktop's local Analysis Services instance. Covers…
git:20260808.22d6d33 · audit A · 3 stars
powerbi-connect SKILL.md skill
santoshkanthety/powerbi-agent · skills/powerbi-connect/SKILL.md · Connect powerbi-agent to a running Power BI Desktop instance. Invoke when the user wants to connect to Power BI…
git:20260808.22d6d33 · audit A · 3 stars
powerbi-create-pbi-report SKILL.md skill
santoshkanthety/powerbi-agent · skills/powerbi-create-pbi-report/SKILL.md · Step-by-step workflow for creating complete Power BI reports from scratch using pbir CLI. Covers model discovery…
git:20260808.22d6d33 · audit A · 3 stars
powerbi-custom-visuals SKILL.md skill
santoshkanthety/powerbi-agent · skills/powerbi-custom-visuals/SKILL.md · Build, package, and embed Power BI custom visuals (.pbiviz) into PBIR reports via the powerbi-visuals SDK…
git:20260808.22d6d33 · audit A · 3 stars
powerbi-cyber-security SKILL.md skill
santoshkanthety/powerbi-agent · skills/powerbi-cyber-security/SKILL.md · Power BI and Microsoft Fabric cybersecurity - tenant hardening, conditional access, OAuth flows, export controls, data…
git:20260808.22d6d33 · audit A · 3 stars
powerbi-data-catalog-lineage SKILL.md skill
santoshkanthety/powerbi-agent · skills/powerbi-data-catalog-lineage/SKILL.md · Data catalog and lineage management. Use when the user mentions: data catalog, lineage, data governance, Microsoft…
git:20260808.22d6d33 · audit A · 3 stars
powerbi-data-governance-traceability SKILL.md skill
santoshkanthety/powerbi-agent · skills/powerbi-data-governance-traceability/SKILL.md · End-to-end data governance traceability for Power BI and Microsoft Fabric - GDPR/CCPA compliance, Purview lineage…
git:20260808.22d6d33 · audit A · 3 stars
powerbi-data-transformation SKILL.md skill
santoshkanthety/powerbi-agent · skills/powerbi-data-transformation/SKILL.md · ETL/ELT transformation patterns. Use when the user mentions: union, append, stack tables, combine datasets, convert…
git:20260808.22d6d33 · audit A · 3 stars
powerbi-dax-mastery SKILL.md skill
santoshkanthety/powerbi-agent · skills/powerbi-dax-mastery/SKILL.md · DAX measures, time intelligence, evaluation context. Use when the user mentions: DAX, measure, calculated column…
git:20260808.22d6d33 · audit A · 3 stars

Every file in santoshkanthety/powerbi-agent

Browse by kind, by grade A, or by owner.