duckdb avatar

Install Duckdb

This handles DuckDB extension installation and updates through a clean command line interface. You can install from core or community repos with the name@repo syntax, or pass --update to refresh everything at once. It checks if DuckDB is installed first and gives you platform specific install commands if not. The update mode is thorough: it checks the CLI version against the latest stable release and prompts you to upgrade before updating extensions. Nice touch that it batches all the SQL statements into a single DuckDB call instead of spawning processes for each extension. Saves you from writing the same boilerplate SQL every time you need to add spatial or parquet support to a project.

skills.sh installs
1K
GitHub stars
616
last updated
Aug 21, 2026

Install

$ npx -y skills add duckdb/duckdb-skills --skill install-duckdb --agent claude-code

Installs into .claude/skills of the current project.

Files

Arguments: $@

Each extension argument has the form name or name@repo.

  • name → INSTALL name;
  • name@repo → INSTALL name FROM repo;

Step 1 — Locate DuckDB

DUCKDB=$(command -v duckdb)

If not found, tell the user:

DuckDB is not installed. Install it first with one of:

  • macOS: brew install duckdb
  • Linux: curl -fsSL https://install.duckdb.org | sh
  • Windows: winget install DuckDB.cli

Then re-run /duckdb-skills:install-duckdb.

Stop if DuckDB is not found.

Step 2 — Check for --update flag

If --update is present in $@, remove it from the argument list and set mode to update. Otherwise mode is install.

Step 3 — Build and run statements

Install mode:

Parse each remaining argument:

  • If it contains @, split on @ → INSTALL <name> FROM <repo>;
  • Otherwise → INSTALL <name>;

Run all in a single DuckDB call:

"$DUCKDB" :memory: -c "INSTALL <ext1>; INSTALL <ext2> FROM <repo2>; ..."

Update mode:

First, check if the DuckDB CLI itself is up to date:

Sponsors

Details

Repository
github.com/duckdb/duckdb-skills
Category
Databases
First seen
Jun 3, 2026

More from duckdb/duckdb-skills

All 6

Recommended

More Databases
1neo4j-contrib avatarneo4j-getting-started-skillneo4j-contrib/neo4j-skillsOrchestrates zero-to-running-app in 8 stages — prerequisites → context → provision → model → load → explore → query → build. Each stage reads its own reference 928skills.sh installs
2mindrally avatarmongodb-developmentmindrally/skillsMongoDB development guidelines with Payload CMS, Mongoose, aggregation pipelines, and TypeScript best practices.916skills.sh installs
3sickn33 avatardatabase-architectsickn33/antigravity-awesome-skillsdatabase architect826skills.sh installs
4aaronontheweb avatardatabase-performanceaaronontheweb/dotnet-skillsDatabase access patterns for performance. Separate read/write models, avoid N+1 queries, use AsNoTracking, apply row limits, and never do application-side joins700skills.sh installs
5pluginagentmarketplace avatarmongoose-mongodbpluginagentmarketplace/custom-plugin-nodejsWork with MongoDB in Node.js using Mongoose ODM for schema design, CRUD operations, relationships, and advanced queries699skills.sh installs
6mindrally avatarconvexmindrally/skillsGuidelines for developing with Convex backend-as-a-service platform, covering queries, mutations, actions, and real-time data patterns677skills.sh installs