SkillsAdd

smithery.ai

db-backup

Create a backup of the SQLite database

First seen Mar 21, 2026

Installation

$ npx skills add https://smithery.ai
View on skills.sh ↗ Website ↗

Similar popular skills

Related neighbors and high-traction skills in the same topics — useful to compare before installing.

azure-storage Same topic
microsoft/azure-skills

Azure Storage Services including Blob Storage, File Shares, Queue Storage, Table Storage, and D…

567.1K installs
azure-kusto Same topic
microsoft/azure-skills

Query and analyze data in Azure Data Explorer (Kusto/ADX) using KQL for log analytics, telemetr…

566.2K installs
supabase-postgres-best-practices Same topic
supabase/agent-skills

Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill …

391.6K installs
prisma-database-setup Same topic
prisma/skills

Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, Mon…

269.8K installs
prisma-client-api Same topic
prisma/skills

Prisma Client API reference covering model queries, filters, operators, and client methods. Use…

269.3K installs
prisma-cli Same topic
prisma/skills

Prisma ORM CLI commands reference covering init, generate, migrate, db, dev, complete, studio, …

267K installs

Also in this package

Other skills from smithery.ai · top by installs.

npx skills add https://smithery.ai
smithery-ai-cli 7.8K frontend-design 6.2K skill-creator 2.5K ck:ui-ux-pro-max 1.3K pdf 1.2K xlsx 966 pptx 894 docx 884 webapp-testing 1 web-design-reviewer 657

Browse all from smithery.ai

More details

Agent compatibility

Declared targets from SKILL.md / docs. Unmarked agents are not listed — the skill may still install via the CLI.

Claude Code Not declared
Cursor Not declared
Codex Not declared
GitHub Copilot Not declared
Windsurf Not declared
Gemini CLI Not declared
Cline Not declared
OpenCode Not declared

Skill metadata

Parsed from SKILL.md frontmatter.

Allowed toolsBash(make sqlite-backup), Bash(make sqlite-restore *)

Package contents

Files included with this skill beyond the listing page.

  • skill md SKILL.md 1,377 B
  • docs SUMMARY.md 55 B

History

  1. First seen on skills.sh
  2. First recorded snapshot · 1 installs

SKILL.md

SQLite Database Backup

Create and manage backups of the SQLite database.

Create Backup

make sqlite-backup

This runs go run ./cmd/server backup (VACUUM INTO) with BACKUP_DIR=./backups:

  • Format: backupYYYYMMDDHHMMSSmmm.db
  • Location: ./backups/backup20260130104530123.db
  • Retention: the newest BACKUP_KEEP files (default 30); older ones are deleted

Restore from Backup

make sqlite-restore BACKUP_FILE=./backups/backup_20260130_104530123.db

⚠️ WARNING: This will overwrite the current database at ./data/budget.db

Best Practices

  1. Before major changes: Always backup before migrations or bulk updates
  2. Regular backups: Schedule periodic backups for production
  3. Test restores: Verify backup integrity by testing restore process
  4. Keep multiple versions: Maintain at least 3-5 recent backups

Backup Location

All backups are stored in ./backups/ directory (created automatically).

Database Location

  • Development: ./data/budget.db
  • Docker: Persisted in Docker volume at ./data/

See Also

  • /db-shell - Open interactive SQLite shell
  • make sqlite-stats - View database statistics