skills.rest
fattits30-dev
fattits30-devCOMMUNITY
Explore all skills by this author →
GitHub

database-backup-restore

Automate SQLite database backups and restore with checksum validation.

1|Updated Oct 8, 2025
Search Tags:#automation#database#data protection#sqlite#disaster recovery#restore#backup
One-click install
npx skills add https://github.com/fattits30-dev/Justice-Companion --skill database-backup-restore
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-backup-restore
Source: https://github.com/fattits30-dev/Justice-Companion/tree/main/.claude/skills/database-backup-restore
Command: npx skills add https://github.com/fattits30-dev/Justice-Companion --skill database-backup-restore

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires better-sqlite3, tsx.

What problem does it solve?

This Skill eliminates the risk of data loss and complex recovery by automating SQLite database backups and providing safe restoration procedures. It ensures data integrity and offers point-in-time recovery, saving you from manual, error-prone processes.

Core Features & Use Cases

  • Automated Backups: Creates scheduled and event-triggered backups (e.g., before migrations, on app start).
  • Safe Restoration: Restores databases with checksum validation and automatically creates a safety backup of the current state.
  • Disaster Recovery & GDPR Export: Supports point-in-time recovery and user data exports in machine-readable formats for GDPR compliance.
  • Use Case: Before a major database migration, Claude automatically creates a validated backup. If the migration fails, it can instantly restore the database to its pre-migration state, saving hours of manual recovery and ensuring data integrity.

Quick Start

Create a manual backup with a description

pnpm db:backup manual "Before major refactor"

List all available backups

pnpm db:backup:list

Restore from a specific backup file

pnpm db:restore justice-2025-10-21-1400.db