OopsDB — Prevent data loss from AI errors with automated…

Pitch

Description

Comments

About this project

OopsDB provides automated backups to safeguard against AI-induced data loss. With simple commands, it enables developers to monitor and restore databases effortlessly. Built for popular platforms like Supabase, Postgres, MySQL, and SQLite, OopsDB ensures data integrity while keeping everything local and secure.

OopsDB: The Essential Auto-Backup Solution for Developers

In the fast-paced world of development, safeguarding databases against unintended modifications is crucial. OopsDB offers a solution designed for developers who rely on AI coding tools like Claude Code, Cursor, and Windsurf. With OopsDB, automated backups and one-click restoration protect valuable data, ensuring it remains secure.

The Challenge

Developers often encounter situations where AI tools make critical mistakes, such as executing DROP TABLE users or running DELETE FROM orders without a WHERE clause. These errors can lead to significant data loss and downtime. OopsDB addresses this challenge by providing a reliable backup mechanism.

Key Features

Auto-Backups: Automatically back up your database every 5 minutes (oopsdb watch). Set it up and focus on your work, while OopsDB secures your data.
Manual Snapshots: Create one-time backups before making major changes (oopsdb snapshot). Have peace of mind during risky database migrations.
Interactive Restore: Restore the database to any previous state in seconds by selecting a snapshot (oopsdb restore). This feature is designed to minimize downtime and disruptions.
Safety Snapshots: Every restore operation is preceded by an automatic backup of the current state, ensuring that even reversals can be undone.
Data Security: All backup files are encrypted using AES-256-CBC, guaranteeing that sensitive information is safeguarded.
Local Management: No third-party accounts or cloud services; OopsDB operates entirely on your machine, ensuring complete control over your backups.
Efficient Performance: Streaming backups mean that memory usage remains low even with large databases.

Supported Databases

OopsDB supports various databases, offering dedicated backup and restore tools for each:

Database	Backup Tool	Restore Tool
Supabase	`pg_dump` (with Supabase flags)	`psql`
PostgreSQL (Neon, local, others)	`pg_dump`	`psql`
MySQL / MariaDB	`mysqldump`	`mysql`
SQLite	`sqlite3`	`sqlite3`

Simple Commands

Setting up OopsDB is straightforward:

# Initialize connection to your database
oopsdb init

# Start auto-backup every 5 minutes
oopsdb watch

# Restore database from a specific snapshot
oopsdb restore

How It Works

Initialization: oopsdb init facilitates the connection process and encrypts credentials locally.
Backup Process: oopsdb watch invokes native database tools for regular data dumping, which is encrypted and streamed to disk for efficiency.
Restoration: oopsdb restore presents a list of backups with timestamps, allowing users to select and confirm a restoration of their database.

Security Emphasis

With a commitment to privacy, OopsDB ensures that no data leaves your machine. All credentials and backup files remain encrypted locally, with no telemetry or external accounts required. Users are also encouraged to include .oopsdb/ in their .gitignore to prevent accidental exposure of sensitive information.

Pricing

Free: Local backups, unlimited snapshots, and full encryption with no hidden fees.
Secure ($9/month): For those seeking additional peace of mind, OopsDB offers immutable cloud backups that are resistant to accidental deletion. Encrypted snapshots are stored in tamper-proof cloud storage with write-once retention policies.

Learn more about OopsDB and its features at oopsdb.com. Support for the project can be provided by contributing via Ko-fi.

With OopsDB, developers can focus on creating and innovating without the constant worry of losing their valuable data.