skills.rest
goodluckz
goodluckzCOMMUNITY
Explore all skills by this author →
GitHub

DuckDB Backup

Back up DuckDB databases using file-based and native ATTACH+COPY methods.

1|Updated Dec 23, 2025
Search Tags:#automation#database#data protection#backup#scripting#duckdb
One-click install
npx skills add https://github.com/goodluckz/claude-code-config --skill duckdb-backup
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: DuckDB Backup
Source: https://github.com/goodluckz/claude-code-config/tree/main/plugins/duckdb-backup
Command: npx skills add https://github.com/goodluckz/claude-code-config --skill duckdb-backup

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides a robust solution for backing up DuckDB databases, ensuring data safety and recoverability through multiple methods and automated processes.

Core Features & Use Cases

  • Dual Backup Methods: Supports fast file-based copying (cp) for local backups and native ATTACH+COPY for more flexible, cloud-ready backups.
  • Automated Timestamping: Automatically adds YYYYMMDD-HHMMSS timestamps to backup filenames for easy versioning and management.
  • Use Case: Schedule daily backups of your critical awsntp.duckdb database to a remote storage location, ensuring you can restore it in case of data loss or corruption.

Quick Start

Use the duckdb-backup skill to create a file-based backup of your database located at data/awsntp.duckdb to data/backup-20251223.duckdb.

Frequently Asked Questions about DuckDB Backup

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

FAQPage Schema
How do I backup a DuckDB database to remote storage?▼

DuckDB database backup supports remote storage through the native ATTACH+COPY method, providing a flexible, cloud-ready approach to securely copy your database files to a remote location.

What is the best way to automate DuckDB backups with timestamping?▼

Automating DuckDB backups uses scripts that automatically append YYYYMMDD-HHMMSS timestamps to filenames, creating reliable versioning for your backups and allowing you to schedule daily data protection tasks.

Can I use file-based copying for local DuckDB database backups?▼

File-based copying (cp) is supported for local DuckDB database backups, providing a fast way to duplicate your database file directly on your local storage system for data protection.

Does DuckDB backup support retention policies and verification?▼

DuckDB backup supports both retention policies and backup verification, ensuring reliable data protection by confirming backup integrity and automatically managing your stored backup versions.

How do I restore a DuckDB database from a backup file?▼

Restoring a DuckDB database from a backup file involves using the native ATTACH+COPY method to copy the timestamped backup file back to your active database location, ensuring data recoverability after loss or corruption.

Related Skills

Explore More Software Engineering Skills→
duckdbduckdb
527

read-file

Read CSV, JSON, and Parquet files from local paths or S3 and GCS.

Official
Basic
JansenAnalyticsJansenAnalytics
5

backup-restore

Automate database and file system backups with retention and verification.

Community
Advanced
nq-rdlnq-rdl

attach-db

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

Official
Advanced
chatermchaterm
50

cloud-backup

Manage cloud backups across AWS S3, Alibaba Cloud OSS, and Azure Blob Storage.

Community
Intermediate