# Duckdb

> DuckDB in-process analytical SQL database reference. Query CSV, Parquet, JSON files directly without import. Covers window functions, QUALIFY, ASOF joins, pivoting, Pandas/Polars zero-copy integration, Apache Arrow, S3 access, and extensions.

- Skill: `bytesagain/duckdb` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add bytesagain/duckdb`
- Raw SKILL.md: https://api.skillmd.com/api/skills/bytesagain/duckdb/raw
- Safety review: pending (external: skill-scanner PASS, skillspector PASS)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: bytesagain (https://skillmd.com/u/bytesagain)
- Updated: 2026-09-21
- Page: https://skillmd.com/skills/bytesagain/duckdb

---


# DuckDB Reference

In-process SQL database for analytics.

## Commands

| Command | Description |
|---------|-------------|
| `intro` | Overview, comparison |
| `queries` | SQL, file queries, window functions |
| `python` | Pandas, Polars, Arrow, extensions |