Skills
.Work. You
Rest

motherduck-duckdb-sql

Official

Write correct DuckDB SQL for MotherDuck.

Data & Analytics#duckdb#motherduck#data querying#sql translation#postgres compatibility#syntax debugging
Authormotherduckdb
Version1.0.0
Installs0

System Documentation

What problem does it solve?

It resolves confusion and production bugs caused by writing PostgreSQL-shaped SQL when the real target is DuckDB-on-MotherDuck, including MotherDuck-specific SQL capabilities and version-sensitive syntax.

Core Features & Use Cases

  • DuckDB-first SQL correctness: Guides you to use DuckDB-native syntax and semantics even when you connect through a Postgres endpoint.
  • MotherDuck feature awareness: Helps distinguish DuckDB core SQL from MotherDuck operational commands and server-mode limitations.
  • Version-lifecycle guardrails: Advises checking MotherDuck lifecycle and connection-path behavior before relying on newer upstream DuckDB features.

Quick Start

Ask: “Rewrite this query as DuckDB SQL for MotherDuck and explain what will fail versus PostgreSQL, given this statement: [paste SQL]”.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: motherduck-duckdb-sql
Download link: https://github.com/motherduckdb/agent-skills/archive/main.zip#motherduck-duckdb-sql

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.