setting-up-duckdb

Name: setting-up-duckdb
Availability: InStock
Author: hernamesbarbara

Set up and configure DuckDB databases for analytics workloads.

Updated Nov 25, 2025

Search Tags:#automation #analytics #database #extensions #project-setup #duckdb

Ready to run

npx skills add https://github.com/hernamesbarbara/promptkit --skill setting-up-duckdb

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: setting-up-duckdb
Source: https://github.com/hernamesbarbara/promptkit/tree/main/.claude/skills/setting-up-duckdb
Command: npx skills add https://github.com/hernamesbarbara/promptkit --skill setting-up-duckdb

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires duckdb, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill helps set up and configure DuckDB databases for analytics workloads. It handles database creation, extension management, configuration tuning, and project initialization with best practices.

Core Features & Use Cases

Database creation: Create persistent or in-memory databases with sensible defaults.
Settings & extensions: Configure memory, threads, and install/load common extensions (parquet, json, httpfs, etc.).
Project scaffolding: Initialize a DuckDB project structure with best practices and gitignore hints.
Use Case: Spin up a local analytics environment and connect to data sources via a recommended DuckDB path.

Quick Start

Use this skill to create a new DuckDB database and apply essential configurations.

Frequently Asked Questions about setting-up-duckdb

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I set up a DuckDB database for analytics?▼

Set up a DuckDB database by creating a persistent or in-memory instance, configuring memory and thread settings, installing extensions like parquet and json, and initializing your project structure with best practices for analytics workloads.

What extensions should I install in DuckDB?▼

Common DuckDB extensions for analytics include parquet for columnar data, json for structured formats, and httpfs for remote data sources. Install and load them during database initialization based on your data source requirements.

Can I use DuckDB for both in-memory and file-based databases?▼

Yes, DuckDB supports both in-memory databases for temporary analytics and persistent file-based deployments. Choose based on your workload: in-memory for speed, file-based for durability and data retention across sessions.

How do I configure DuckDB connection settings?▼

Configure DuckDB connections by setting memory allocation, thread count, and loading required extensions during database creation. Apply these settings during project initialization to optimize for your analytics workload.

What's the best way to initialize a DuckDB project structure?▼

Initialize a DuckDB project with recommended directory layouts, gitignore configuration to protect database files, proper extension management, and connection setup. This ensures reproducibility and follows analytics best practices.

Why should I configure DuckDB settings upfront?▼

Configuring memory, threads, and extensions during setup prevents runtime bottlenecks and connection failures. Early tuning ensures your DuckDB instance performs reliably for analytics queries against various data sources.