skills.rest
vathymut
vathymutCOMMUNITY
Explore all skills by this author →
Website𝕏@vathymutGitHub

attach-db

Attach DuckDB database files and manage session state via a SQL state file.

Updated Apr 19, 2026
Search Tags:#data science#DuckDB#schema exploration#session state management#database attachment
One-click install
npx skills add https://github.com/vathymut/copilot-skills --skill attach-db-vathymut
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: attach-db
Source: https://github.com/vathymut/copilot-skills/tree/main/.github/skills/attach-db
Command: npx skills add https://github.com/vathymut/copilot-skills --skill attach-db-vathymut

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

Manages the connection of DuckDB database files, ensuring ready access for subsequent queries, and maintains a SQL state file for session restoration.

Core Features & Use Cases

  • Database Attachment: Attaches DuckDB database files for query purposes.
  • Schema Exploration: Explores the database schema, including tables and row counts.
  • State File Management: Creates and manages a state file for storing the database session state.
  • Use Case: Ideal for data scientists who want to quickly attach and explore DuckDB databases during their analysis process.

Quick Start

Run the 'attach-db skill with the database path as an argument: attach-db <path-to-database.duckdb>.

Frequently Asked Questions about attach-db

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

FAQPage Schema
How do I attach a DuckDB database for query execution?▼

To attach a DuckDB database, provide the database file path as an argument. This connects the database file and manages the session state, ensuring the database is ready for subsequent query execution.

What is DuckDB session state management and why is it needed?▼

DuckDB session state management stores your database session configuration in a shared SQL state file. This ensures ready access for subsequent queries and allows you to restore your database session during analysis.

Can I explore database schema and row counts after attaching a DuckDB file?▼

Yes, schema exploration is supported after attaching a DuckDB file. You can explore the database schema, including viewing available tables and their respective row counts, directly within your data science workflow.

What is the best way to manage DuckDB connections in a data science workflow?▼

The best way to manage DuckDB connections is using a Skill that handles file path resolution, database schema exploration, and session state management via a shared SQL state file for seamless analysis.

Do I need any dependencies to attach and manage DuckDB databases?▼

No external dependencies are required to attach and manage DuckDB databases. The Skill operates independently using its internal scripts to handle file path resolution and database attachment.

Related Skills

Explore More Data & Analytics Skills→
nq-rdlnq-rdl

attach-db

Attach a DuckDB database file to shared state for query workflows.

Official
Advanced
chrishuffman5chrishuffman5

query

Execute SQL queries on DuckDB databases with file-based data sources.

Community
Intermediate
LiorCohenLiorCohen
39

postgresql

Deploy PostgreSQL environments and automate schema management and query execution.

Community
Advanced
clawdataclawdata
24

duckdb

Query local DuckDB warehouses with SQL and ingest CSV, Parquet, and JSON files.

Official
Intermediate