{"id":"ed16f490-87e6-46fb-9cc7-0834d1bd73ba","shortId":"SsMMEK","kind":"skill","title":"duckdb","tagline":"Auto-activate for .duckdb files, duckdb imports. Comprehensive DuckDB expertise: advanced analytical SQL patterns, performance tuning, data engineering (ETL, multi-source reads, cloud storage), client APIs for Python/Node/Rust/Java/R/Go/WASM, extension development, function refer","description":"# DuckDB\n\n## Overview\n\nDuckDB is an in-process analytical database with rich SQL dialect, first-class support for Parquet/CSV/JSON, and client APIs for Python, Node.js, Rust, Java, R, Go, WASM, and more. It excels at OLAP workloads, local data exploration, embedded analytics, and data engineering pipelines across local and cloud data sources.\n\n## References Index\n\nFor detailed guides and patterns, refer to the following documents in `references/`:\n\n- **[Core DuckDB](references/core.md)**\n  - SQL dialect highlights, data import/export, configuration, and key SQL patterns.\n- **[Advanced SQL Patterns](references/sql_patterns.md)**\n  - QUALIFY, COLUMNS(*), EXCLUDE/REPLACE/RENAME, list comprehensions, structs, maps, PIVOT/UNPIVOT, ASOF joins, UNION BY NAME, recursive CTEs, GROUP BY ALL, SAMPLE, string slicing, lambda functions.\n- **[Performance Tuning](references/performance.md)**\n  - EXPLAIN ANALYZE, storage inspection, pushdown optimizations, parallel execution, memory management, Parquet performance, partition pruning, bulk loading, indexing.\n- **[Data Engineering](references/data_engineering.md)**\n  - Multi-source reads (CSV, Parquet, JSON, Excel, SQLite, PostgreSQL, MySQL), httpfs/S3/GCS/Azure, glob patterns, Delta Lake, Iceberg, partitioned output, ETL patterns, cross-database queries, secrets management.\n- **[Python Client](references/python_client.md)**\n  - Connection management, DataFrame integration, relational API, and parameter binding.\n- **[Client Connections](references/connections.md)**\n  - Node.js, Rust, Java/JDBC, R/dbplyr, Go, WASM, ADBC (Arrow), ODBC driver setup and usage.\n- **[Key Function Reference](references/functions.md)**\n  - Aggregates, date/time, string, list, struct, map, spatial, and full-text search functions.\n- **[Extension Development](references/extensions.md)**\n  - Building, testing, and distributing DuckDB C++ extensions.\n- **[CLI](references/cli.md)**\n  - Interactive shell usage, dot-commands, and scripting patterns.\n- **[Configuration & Administration](references/configuration.md)**\n  - Pragmas, SET statements, database files/WAL/checkpointing, catalog inspection, extension management, cloud credentials, .duckdbrc startup config.\n\n---\n\n<workflow>\n\n## Key SQL Dialect Features\n\n- `SELECT * EXCLUDE (col)` -- select all columns except specific ones\n- `SELECT COLUMNS('pattern')` -- select columns matching a regex\n- `PIVOT` / `UNPIVOT` -- built-in pivot support\n- `LIST`, `STRUCT`, `MAP` nested types with full query support\n- `GROUP BY ALL`, `ORDER BY ALL` -- automatic grouping/ordering\n- Friendly SQL: `FROM tbl SELECT col` syntax, implicit `SELECT *`\n\n</workflow>\n\n---\n\n## Quick Start\n\n<example>\n\n```python\nimport duckdb\ncon = duckdb.connect()  # in-memory\nresult = con.sql(\"SELECT 42 AS answer\").fetchall()\n```\n\n```bash\n# CLI\nduckdb mydb.duckdb \"SELECT * FROM read_parquet('data/*.parquet')\"\n```\n\n</example>\n\n---\n\n## Official References\n\n- DuckDB documentation: <https://duckdb.org/docs/>\n- Python API: <https://duckdb.org/docs/api/python/overview>\n- Extensions: <https://duckdb.org/docs/extensions/overview>\n- CLI: <https://duckdb.org/docs/api/cli/overview>\n- Extension template: <https://github.com/duckdb/extension-template>\n\n## Shared Styleguide Baseline\n\n- Use shared styleguides for generic language/framework rules to reduce duplication in this skill.\n- [General Principles](https://github.com/cofin/flow/blob/main/templates/styleguides/general.md)\n- [PostgreSQL](https://github.com/cofin/flow/blob/main/templates/styleguides/databases/postgres_psql.md)\n- Keep this skill focused on tool-specific workflows, edge cases, and integration details.\n\n<guardrails>\n## Guardrails\n\nAdd guardrails instructions here.\n</guardrails>\n\n<validation>\n## Validation\n\nAdd validation instructions here.\n</validation>","tags":["duckdb","flow","cofin","agent-skills","ai-agents","beads","claude-code","codex","cursor","developer-tools","gemini-cli","opencode"],"capabilities":["skill","source-cofin","skill-duckdb","topic-agent-skills","topic-ai-agents","topic-beads","topic-claude-code","topic-codex","topic-cursor","topic-developer-tools","topic-gemini-cli","topic-opencode","topic-plugin","topic-slash-commands","topic-spec-driven-development"],"categories":["flow"],"synonyms":[],"warnings":[],"endpointUrl":"https://skills.sh/cofin/flow/duckdb","protocol":"skill","transport":"skills-sh","auth":{"type":"none","details":{"cli":"npx skills add cofin/flow","source_repo":"https://github.com/cofin/flow","install_from":"skills.sh"}},"qualityScore":"0.455","qualityRationale":"deterministic score 0.46 from registry signals: · indexed on github topic:agent-skills · 11 github stars · SKILL.md body (3,779 chars)","verified":false,"liveness":"unknown","lastLivenessCheck":null,"agentReviews":{"count":0,"score_avg":null,"cost_usd_avg":null,"success_rate":null,"latency_p50_ms":null,"narrative_summary":null,"summary_updated_at":null},"enrichmentModel":"deterministic:skill-github:v1","enrichmentVersion":1,"enrichedAt":"2026-04-24T01:03:26.368Z","embedding":null,"createdAt":"2026-04-23T13:03:59.139Z","updatedAt":"2026-04-24T01:03:26.368Z","lastSeenAt":"2026-04-24T01:03:26.368Z","tsv":"'/cofin/flow/blob/main/templates/styleguides/databases/postgres_psql.md)':406 '/cofin/flow/blob/main/templates/styleguides/general.md)':402 '/docs/':363 '/docs/api/cli/overview':376 '/docs/api/python/overview':368 '/docs/extensions/overview':372 '/duckdb/extension-template':381 '42':343 'across':83 'activ':4 'adbc':214 'add':422,427 'administr':260 'advanc':13,116 'aggreg':225 'analyt':14,44,78 'analyz':147 'answer':345 'api':29,58,201,365 'arrow':215 'asof':128 'auto':3 'auto-activ':2 'automat':319 'baselin':384 'bash':347 'bind':204 'build':241 'built':300 'built-in':299 'bulk':160 'c':246 'case':417 'catalog':267 'class':52 'cli':248,348,373 'client':28,57,194,205 'cloud':26,86,271 'col':282,326 'column':121,285,290,293 'command':255 'comprehens':10,124 'con':335 'con.sql':341 'config':275 'configur':111,259 'connect':196,206 'core':103 'credenti':272 'cross':188 'cross-databas':187 'csv':170 'ctes':134 'data':19,75,80,87,109,163,355 'databas':45,189,265 'datafram':198 'date/time':226 'delta':180 'detail':92,420 'develop':33,239 'dialect':49,107,278 'distribut':244 'document':100,360 'dot':254 'dot-command':253 'driver':217 'duckdb':1,6,8,11,36,38,104,245,334,349,359 'duckdb.connect':336 'duckdb.org':362,367,371,375 'duckdb.org/docs/':361 'duckdb.org/docs/api/cli/overview':374 'duckdb.org/docs/api/python/overview':366 'duckdb.org/docs/extensions/overview':370 'duckdbrc':273 'duplic':394 'edg':416 'embed':77 'engin':20,81,164 'etl':21,185 'excel':70,173 'except':286 'exclud':281 'exclude/replace/rename':122 'execut':153 'expertis':12 'explain':146 'explor':76 'extens':32,238,247,269,369,377 'featur':279 'fetchal':346 'file':7 'files/wal/checkpointing':266 'first':51 'first-class':50 'focus':410 'follow':99 'friend':321 'full':234,310 'full-text':233 'function':34,142,222,237 'general':398 'generic':389 'github.com':380,401,405 'github.com/cofin/flow/blob/main/templates/styleguides/databases/postgres_psql.md)':404 'github.com/cofin/flow/blob/main/templates/styleguides/general.md)':400 'github.com/duckdb/extension-template':379 'glob':178 'go':65,212 'group':135,313 'grouping/ordering':320 'guardrail':421,423 'guid':93 'highlight':108 'httpfs/s3/gcs/azure':177 'iceberg':182 'implicit':328 'import':9,333 'import/export':110 'in-memori':337 'in-process':41 'index':90,162 'inspect':149,268 'instruct':424,429 'integr':199,419 'interact':250 'java':63 'java/jdbc':210 'join':129 'json':172 'keep':407 'key':113,221,276 'lake':181 'lambda':141 'language/framework':390 'list':123,228,304 'load':161 'local':74,84 'manag':155,192,197,270 'map':126,230,306 'match':294 'memori':154,339 'multi':23,167 'multi-sourc':22,166 'mydb.duckdb':350 'mysql':176 'name':132 'nest':307 'node.js':61,208 'odbc':216 'offici':357 'olap':72 'one':288 'optim':151 'order':316 'output':184 'overview':37 'parallel':152 'paramet':203 'parquet':156,171,354,356 'parquet/csv/json':55 'partit':158,183 'pattern':16,95,115,118,179,186,258,291 'perform':17,143,157 'pipelin':82 'pivot':297,302 'pivot/unpivot':127 'postgresql':175,403 'pragma':262 'principl':399 'process':43 'prune':159 'pushdown':150 'python':60,193,332,364 'python/node/rust/java/r/go/wasm':31 'qualifi':120 'queri':190,311 'quick':330 'r':64 'r/dbplyr':211 'read':25,169,353 'recurs':133 'reduc':393 'refer':35,89,96,102,223,358 'references/cli.md':249 'references/configuration.md':261 'references/connections.md':207 'references/core.md':105 'references/data_engineering.md':165 'references/extensions.md':240 'references/functions.md':224 'references/performance.md':145 'references/python_client.md':195 'references/sql_patterns.md':119 'regex':296 'relat':200 'result':340 'rich':47 'rule':391 'rust':62,209 'sampl':138 'script':257 'search':236 'secret':191 'select':280,283,289,292,325,329,342,351 'set':263 'setup':218 'share':382,386 'shell':251 'skill':397,409 'skill-duckdb' 'slice':140 'sourc':24,88,168 'source-cofin' 'spatial':231 'specif':287,414 'sql':15,48,106,114,117,277,322 'sqlite':174 'start':331 'startup':274 'statement':264 'storag':27,148 'string':139,227 'struct':125,229,305 'styleguid':383,387 'support':53,303,312 'syntax':327 'tbl':324 'templat':378 'test':242 'text':235 'tool':413 'tool-specif':412 'topic-agent-skills' 'topic-ai-agents' 'topic-beads' 'topic-claude-code' 'topic-codex' 'topic-cursor' 'topic-developer-tools' 'topic-gemini-cli' 'topic-opencode' 'topic-plugin' 'topic-slash-commands' 'topic-spec-driven-development' 'tune':18,144 'type':308 'union':130 'unpivot':298 'usag':220,252 'use':385 'valid':426,428 'wasm':66,213 'workflow':415 'workload':73","prices":[{"id":"a797fbc4-1c5c-4932-bffb-2e757ada3e15","listingId":"ed16f490-87e6-46fb-9cc7-0834d1bd73ba","amountUsd":"0","unit":"free","nativeCurrency":null,"nativeAmount":null,"chain":null,"payTo":null,"paymentMethod":"skill-free","isPrimary":true,"details":{"org":"cofin","category":"flow","install_from":"skills.sh"},"createdAt":"2026-04-23T13:03:59.139Z"}],"sources":[{"listingId":"ed16f490-87e6-46fb-9cc7-0834d1bd73ba","source":"github","sourceId":"cofin/flow/duckdb","sourceUrl":"https://github.com/cofin/flow/tree/main/skills/duckdb","isPrimary":false,"firstSeenAt":"2026-04-23T13:03:59.139Z","lastSeenAt":"2026-04-24T01:03:26.368Z"}],"details":{"listingId":"ed16f490-87e6-46fb-9cc7-0834d1bd73ba","quickStartSnippet":null,"exampleRequest":null,"exampleResponse":null,"schema":null,"openapiUrl":null,"agentsTxtUrl":null,"citations":[],"useCases":[],"bestFor":[],"notFor":[],"kindDetails":{"org":"cofin","slug":"duckdb","github":{"repo":"cofin/flow","stars":11,"topics":["agent-skills","ai-agents","beads","claude-code","codex","context-driven-development","cursor","developer-tools","gemini-cli","opencode","plugin","slash-commands","spec-driven-development","subagents","tdd","workflow"],"license":"apache-2.0","html_url":"https://github.com/cofin/flow","pushed_at":"2026-04-19T23:22:27Z","description":"Context-Driven Development toolkit for AI agents — spec-first planning, TDD workflow, and Beads integration.","skill_md_sha":"dc148afdc99378a279aaddf10a395e98a578a4fa","skill_md_path":"skills/duckdb/SKILL.md","default_branch":"main","skill_tree_url":"https://github.com/cofin/flow/tree/main/skills/duckdb"},"layout":"multi","source":"github","category":"flow","frontmatter":{"name":"duckdb","description":"Auto-activate for .duckdb files, duckdb imports. Comprehensive DuckDB expertise: advanced analytical SQL patterns, performance tuning, data engineering (ETL, multi-source reads, cloud storage), client APIs for Python/Node/Rust/Java/R/Go/WASM, extension development, function reference, and configuration/administration. Use when: writing DuckDB queries, optimizing performance, building data pipelines, connecting from any language, developing extensions, importing/exporting CSV/Parquet/JSON/Delta/Iceberg, or configuring DuckDB for production analytics workloads. Not for OLTP databases (see postgres/mysql) or traditional data warehouses."},"skills_sh_url":"https://skills.sh/cofin/flow/duckdb"},"updatedAt":"2026-04-24T01:03:26.368Z"}}