Setup & Installation
npx skills add https://github.com/duckdb/duckdb-skills --skill attach-db
https://github.com/duckdb/duckdb-skills/tree/main/skills/attach-db
View on GitHubWhat This Skill Does
Attaches a DuckDB database file to your current project session. It explores the schema, collects table names, column definitions, and row counts, then writes a shared state file so future queries restore the connection automatically via `duckdb -init`.
Instead of manually writing ATTACH statements and checking schemas every session, this skill writes and maintains the state file once so every subsequent query just works.
When to use it
- Attaching an existing analytics database before running ad-hoc queries
- Loading a project-specific DuckDB file without retyping the path each session
- Inspecting table structure and row counts on a new database you just received
- Sharing a state file across multiple duckdb-skills in the same project
- Setting up a persistent session alias for a database stored outside the project root