motherduck-build-data-pipeline SKILL.md skillA

motherduck-build-data-pipeline from motherduckdb/agent-skills is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add motherduckdb/agent-skills/motherduck-build-data-pipeline@git:20261120.20ce5f0

Pins git:20261120.20ce5f0 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
motherduckdb/agent-skills
Path
plugins/motherduck-skills-claude/skills/motherduck-build-data-pipeline/SKILL.md
Versions recorded
11
Latest version
git:20261120.20ce5f0, committed Nov 20, 2026
First version recorded
Jun 18, 2026
Size
4,775 bytes
Repository stars
62
License
none declared

Build ingestion-to-serving pipelines on MotherDuck, including stage boundaries, transformations, and publication. Use for any recurring ingestion from an API, SaaS app, or database into MotherDuck.

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

# Build a Data Pipeline with MotherDuck

## Start Here: Is a MotherDuck Server Active?

Use an active remote MotherDuck MCP server or local MotherDuck server to inspect the in-scope database, schema, grain, keys, and relevant metrics. Reuse known context and narrow discovery to the requested work; do not scan the whole workspace by default. Let the actual data model shape the result.

Resolve the target from the request or active context. Ask only if ambiguity materially affects the result. Without a server, use supplied schema and explicit assumptions for planning; do not imply live validation.

## Pipeline Defaults

- batch over streaming
- raw landing before curation
- explicit raw -> staging -> analytics boundaries
- bulk ingest paths over row-by-row writes: stage files and load with `read_parquet`/`read_json_auto` or one `INSERT ... SELECT`; never `executemany()` or per-row `INSERT` loops against MotherDuck
- idempotent stage rebuilds or append contracts before scheduled automation
- verify the MotherDuck-supported DuckDB client version before recommending upstream-only write, checkpoint, or lakehouse features
- native MotherDuck storage unless DuckLake is explicitly required
…

Read the whole file at its exact version.

How to install

No tool to install first
claude plugin marketplace add https://markdownregistry.com/mp/a/art_o5wbiuchzne2d4gr/5aa3de534e9cc3fa70b8ee3a71a4e3f65141f12c0a0d681d7513edf755cc069d.json

Then /plugin install motherduck-build-data-pipeline@markdownregistry-o5wbiuchzne2d4gr in Claude Code. It installs git:20261120.20ce5f0, the one graded A here, pinned to the commit it was graded at, and leaves it there.

The exact contents, by fingerprint
mdr add motherduckdb/agent-skills/motherduck-build-data-pipeline@sha256:5aa3de534e9cc3fa

The line at the top of this page pins the label git:20261120.20ce5f0, 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_o5wbiuchzne2d4gr.svg)](https://markdownregistry.com/a/art_o5wbiuchzne2d4gr)

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

Ask from your agent
claude mcp add --transport http markdownregistry https://markdownregistry.com/mcp/registry

Then ask it: what changed in motherduckdb/agent-skills/motherduck-build-data-pipeline since the version I have? It reads every saved version here, no key and no account. Any agent that speaks MCP can add it.

Got a copy of motherduck-build-data-pipeline from somewhere else? Ask it: where did my motherduck-build-data-pipeline come from, and what was changed? It names the public original, the version yours is closest to and every changed line. The text is not kept.

Versions

The registry has recorded 11 versions of this file, between Jun 18, 2026 and Nov 20, 2026, about one every 16 days.

Watch this file (sign in, one email per new version)

versioncommittedcommitsizeaudit
git:20261120.20ce5f0 latest2026-11-20 20ce5f0 4,775 BA view · diff
git:20261120.e36a3302026-11-20 e36a330 4,775 BA view · diff
git:20261025.fc2009b2026-10-25 fc2009b 4,775 BA view · diff
git:20261025.c6c646c2026-10-25 c6c646c 4,775 BA view · diff
git:20261025.b7094032026-10-25 b709403 4,537 BA view · diff
git:20261024.5f135662026-10-24 5f13566 4,563 BA view · diff
git:20260905.e7007462026-09-05 e700746 4,220 BA view · diff
git:20260827.1ff9a102026-08-27 1ff9a10 6,650 BA view · diff
git:20260731.19b103e2026-07-31 19b103e 6,245 BA view · diff
git:20260713.0d44fed2026-07-13 0d44fed 6,245 BA view · diff
git:20260618.747023e2026-06-18 747023e 6,142 BA view
Keep it current by itself, install once

Committed this skill to a repository? Install the markdownregistry skill updates app on it, or on all of them. When the registry saves a newer version, a pull request brings your copy to it within minutes, the newest version first, then what changed and any check it newly trips. A copy you edited is never touched, and nothing is deleted.

Install on GitHub

It asks to read and write contents and pull requests, and to read metadata. No workflow file, no Actions setting, nothing runs on your runners. Uninstall it and everything the registry kept about your repository is deleted.

Keep it current by itself

Committed this skill to a repository? Add one workflow file, and when a newer version is saved, a pull request brings your copy to it, the newest version first, then what changed and any check it newly trips. A copy you edited is never touched, and nothing is deleted.

mkdir -p .github/workflows && curl -fsSL https://markdownregistry.com/ci/skill-updates.yml -o .github/workflows/skill-updates.yml

It runs daily on GitHub Actions, no key and no account. Read the workflow before you add it.

Check a whole project

From the root of your project, one line hashes each installed skill's SKILL.md, your AGENTS.md and your CLAUDE.md, and asks the registry once. Only the fingerprints and paths are sent.

sha256sum .claude/skills/*/SKILL.md AGENTS.md CLAUDE.md | curl -s --data-binary @- https://markdownregistry.com/api/v1/check-copies

In CI, add --fail-with-body: the answer is 409 when any file is behind, so the step fails and still prints which files.

sha256sum .claude/skills/*/SKILL.md AGENTS.md CLAUDE.md | curl -s --fail-with-body --data-binary @- https://markdownregistry.com/api/v1/check-copies

No sha256sum on your machine? shasum -a 256 prints the same lines.

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 (4775 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

motherduckdb/agent-skills · 62 stars · license none declared · pushed 2026-11-20 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_o5wbiuchzne2d4gr
GET https://markdownregistry.com/api/v1/resolve?ref=motherduckdb/agent-skills/motherduck-build-data-pipeline
GET https://markdownregistry.com/api/v1/blob/5aa3de534e9cc3fa70b8ee3a71a4e3f65141f12c0a0d681d7513edf755cc069d

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 motherduckdb/agent-skills

motherduck-skills Plugin marketplace
motherduckdb/agent-skills · .claude-plugin/marketplace.json · MotherDuck skills for agents and developers: use the CLI and Guides, explore schemas, write DuckDB SQL, build Dives and…
v3.2.0 · audit A · 62 stars
AGENTS.md AGENTS.md file
motherduckdb/agent-skills · AGENTS.md
git:20261025.0a30e3f · audit A · 62 stars
CLAUDE.md CLAUDE.md file
motherduckdb/agent-skills · CLAUDE.md
git:20261025.a384a78 · audit A · 62 stars
motherduck-build-cfa-app SKILL.md skill
motherduckdb/agent-skills · plugins/motherduck-skills-claude/skills/motherduck-build-cfa-app/SKILL.md · Build MotherDuck analytics into customer-facing applications with tenant isolation, backend routing, and serving APIs.
git:20261120.20ce5f0 · audit A · 62 stars
motherduck-build-dashboard SKILL.md skill
motherduckdb/agent-skills · plugins/motherduck-skills-claude/skills/motherduck-build-dashboard/SKILL.md · Build a MotherDuck dashboard as a Dive, choosing the analytical story, metrics, and section queries.
git:20261120.20ce5f0 · audit A · 62 stars
motherduck-cli SKILL.md skill
motherduckdb/agent-skills · plugins/motherduck-skills-claude/skills/motherduck-cli/SKILL.md · Use the MotherDuck CLI for terminal queries, authentication, and file-based Dive or Flight workflows.
git:20261024.5f13566 · audit A · 62 stars
motherduck-connect SKILL.md skill
motherduckdb/agent-skills · plugins/motherduck-skills-claude/skills/motherduck-connect/SKILL.md · Set up or troubleshoot MotherDuck connections, the MotherDuck MCP server in AI clients, authentication, client…
git:20261025.b709403 · audit A · 62 stars
motherduck-create-dive SKILL.md skill
motherduckdb/agent-skills · plugins/motherduck-skills-claude/skills/motherduck-create-dive/SKILL.md · Create, edit, design, publish, share, or embed MotherDuck Dives, including responsive layout, light/dark themes, and…
git:20261025.c6c646c · audit A · 62 stars
motherduck-create-flight SKILL.md skill
motherduckdb/agent-skills · plugins/motherduck-skills-claude/skills/motherduck-create-flight/SKILL.md · Create, run, schedule, or debug MotherDuck Flights, Python jobs executed on MotherDuck compute.
git:20261025.c6c646c · audit A · 62 stars
motherduck-duckdb-sql SKILL.md skill
motherduckdb/agent-skills · plugins/motherduck-skills-claude/skills/motherduck-duckdb-sql/SKILL.md · Look up or repair DuckDB SQL syntax and verify MotherDuck-specific command and feature support.
git:20261024.5f13566 · audit A · 62 stars
motherduck-ducklake SKILL.md skill
motherduckdb/agent-skills · plugins/motherduck-skills-claude/skills/motherduck-ducklake/SKILL.md · Decide whether DuckLake fits a MotherDuck workload and operate it safely. Use whenever DuckLake, open table formats, or…
git:20261025.b709403 · audit A · 62 stars
motherduck-enable-self-serve-analytics SKILL.md skill
motherduckdb/agent-skills · plugins/motherduck-skills-claude/skills/motherduck-enable-self-serve-analytics/SKILL.md · Roll out governed MotherDuck analytics to internal teams, choosing trusted datasets, access boundaries, and owners.
git:20261025.fc2009b · audit A · 62 stars

Every file in motherduckdb/agent-skills

Other files named motherduck-build-data-pipeline

motherduck-build-data-pipeline SKILL.md skill
motherduckdb/agent-skills · plugins/motherduck-skills-copilot/skills/motherduck-build-data-pipeline/SKILL.md · Build ingestion-to-serving pipelines on MotherDuck, including stage boundaries, transformations, and publication. Use…
git:20261120.20ce5f0 · audit A · 62 stars
motherduck-build-data-pipeline SKILL.md skill
motherduckdb/agent-skills · plugins/motherduck-skills/skills/motherduck-build-data-pipeline/SKILL.md · Build ingestion-to-serving pipelines on MotherDuck, including stage boundaries, transformations, and publication. Use…
git:20261025.fc2009b · audit A · 62 stars
motherduck-build-data-pipeline SKILL.md skill
motherduckdb/agent-skills · skills/motherduck-build-data-pipeline/SKILL.md · Build ingestion-to-serving pipelines on MotherDuck, including stage boundaries, transformations, and publication. Use…
git:20261025.fc2009b · audit A · 62 stars

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