using-duckdb — Claude Code skill: what it does, how to install
Query Delta tables and raw files in Fabric OneLake using DuckDB either on your machine or inside a Fabric notebook.
GPL-3.0 ★ 1,104 updated 2026-10-28
/plugin marketplace add data-goblin/power-bi-agentic-development
/plugin install etl@power-bi-agentic-developmentWhat using-duckdb does
The skill sets up direct SQL queries against Microsoft Fabric OneLake storage without launching heavy Spark clusters. It reads Delta Lake tables alongside raw Parquet, CSV, and JSON files stored across lakehouses and warehouses.
Execution splits into two environments. In a local terminal, DuckDB queries OneLake using Azure CLI authentication paired with the delta and azure extensions. Inside a Fabric notebook, it uses storage tokens through notebookutils, speeding up ad-hoc analytical queries on a single node. Cross-item joins work directly in a single SQL statement via full ABFSS paths.
This integration strictly handles read-only workloads. Writing data back into storage requires Spark, and local execution fails unless you authenticate via az login first.
What it helps with
- query Fabric Delta tables directly from a local terminal
- run fast analytical SQL queries in Fabric notebooks without Spark SQL
- inspect raw Parquet, JSON, and CSV files stored in OneLake
- perform cross-item joins across separate lakehouses and warehouses
Example prompts for the agent
- Query Delta tables locally with DuckDB to check row counts
- Attach DuckDB to the lakehouse in this Fabric notebook
- Scan raw parquet files in OneLake using DuckDB
How to install using-duckdb
1Plugin marketplace
/plugin marketplace add data-goblin/power-bi-agentic-development/plugin install etl@power-bi-agentic-developmentThis installs the whole etl plugin with all its skills
2Skills CLI (Vercel)
npx skills add data-goblin/power-bi-agentic-development --skill using-duckdb -a claude-code3Manually: put the files in place
~/.claude/skills/using-duckdb/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/using-duckdb/
1Skills CLI (Vercel)
npx skills add data-goblin/power-bi-agentic-development --skill using-duckdb -a codex2Manually: put the files in place
.agents/skills/using-duckdb/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add data-goblin/power-bi-agentic-development --skill using-duckdb -a cursor2Manually: put the files in place
.cursor/skills/using-duckdb/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install data-goblin/power-bi-agentic-development plugins/etl/skills/using-duckdb2Manually: put the files in place
.github/skills/using-duckdb/SKILL.md1Skills CLI (Vercel)
npx skills add data-goblin/power-bi-agentic-development --skill using-duckdb -a gemini-cli2Platform CLI
gemini skills install https://github.com/data-goblin/power-bi-agentic-development --path plugins/etl/skills/using-duckdbManually: put the files in place
.devin/skills/using-duckdb/SKILL.mdThe legacy .windsurf/skills/ path still works
Claude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about using-duckdb
How to install using-duckdb in Claude Code?
Run these two commands in order: /plugin marketplace add data-goblin/power-bi-agentic-development and then /plugin install etl@power-bi-agentic-development.
What does using-duckdb do?
It lets you run SQL queries on Microsoft Fabric OneLake Delta tables and raw data files using DuckDB, either on your developer machine or inside a notebook.
Can using-duckdb write data back to OneLake?
No, it is strictly read-only. Modifying or writing data back to Fabric lakehouses requires running Spark jobs instead.