Database Backup & Pitr Platform

Automated database backups with point-in-time recovery

View the interactive project page →

Database Backup & PITR Platform

Part of the worlds-biggest-software-project initiative.

An AI-native, multi-database backup and point-in-time recovery platform that unifies continuous WAL archiving, intelligent scheduling, and natural-language restore across clouds.

Database Backup & PITR Platform delivers automated database backups with point-in-time recovery for PostgreSQL, MySQL, and MongoDB across self-hosted, Kubernetes, and multi-cloud deployments. It is built for database administrators, platform engineers, and regulated-industry teams who need auditable, low-RPO recovery without the operational burden of stitching together CLI tools or accepting vendor lock-in.


Why Database Backup & PITR Platform?

  • Cloud-native PITR services like AWS Backup and Google Cloud Spanner PITR are tightly coupled to a single ecosystem and offer no hybrid or on-premises option.
  • Battle-tested open-source tools (pgBackRest, WAL-G, Barman) are CLI-only with steep learning curves and no modern UI or dashboard.
  • Managed offerings such as Supabase gate PITR behind paid tiers (from $25/month) and require additional compute add-ons; PlanetScale Postgres limits PITR to 5-minute resolution.
  • Most tools focus on a single engine; only Percona Everest and WAL-G span multiple databases, and neither offers unified multi-cloud management with a polished restore UX.
  • No incumbent uses AI to optimise backup schedules, detect anomalous write patterns, or translate natural-language restore intent into precise WAL replay timestamps.

Key Features

Continuous Backup and Recovery

  • Automated backup scheduling with configurable frequency and retention windows (minimum 7-day retention)
  • Point-in-time recovery to any point within retention window at second-level granularity
  • WAL-based continuous archiving to cloud object storage (S3, GCS, Azure Blob)
  • Full and incremental backup types with intelligent scheduling
  • Backup validation and integrity testing with synthetic restores to shadow instances

Multi-Database and Multi-Cloud Support

  • Multi-database support across PostgreSQL, MySQL, and MongoDB
  • Cloud object storage integration with S3, GCS, and Azure Blob targets
  • Failover storage support with automatic fallback if primary storage fails
  • Kubernetes-native operator for cloud-native deployments
  • Cross-cloud backup portability for export/import between AWS, GCP, and Azure (backlog)

Operations and Compliance

  • Web dashboard for monitoring backup health, retention status, and restore initiation
  • Encryption at rest and in transit meeting AES-256 standards
  • Role-based access control and audit logging for compliance
  • Configurable retention policies per backup generation or database
  • Logging and audit trails aligned with GDPR, SOC 2, and HIPAA requirements

AI-Powered Resilience

  • Natural-language PITR queries (e.g. "restore before the table truncation")
  • Anomaly detection on write patterns triggering protective snapshots
  • Cost forecasting and optimisation recommendations for retention policies
  • Ransomware detection with immutable snapshot isolation
  • Zero-downtime restore via database branching to create isolated copies from backup

AI-Native Advantage

AI shifts backup from a static schedule to an adaptive, intent-driven system. The platform analyses query patterns and data-change velocity to recommend backup frequencies that balance RPO/RTO against cost, and detects unusual write patterns — potential ransomware, bulk deletes, or schema corruption — to trigger out-of-schedule snapshots automatically. Natural-language restore requests are translated into precise WAL replay timestamps, and restore integrity is validated continuously by replaying recent WAL to shadow instances without human intervention.


Tech Stack & Deployment

The platform targets self-hosted, Kubernetes-native, and multi-cloud deployments via a Kubernetes operator and CLI. Backups stream to S3, GCS, Azure Blob, or SFTP using WAL archiving as the foundational mechanism for continuous Postgres-style PITR. Industry-standard RPO/RTO metrics drive scheduling, and integrations are designed around the standard PostgreSQL, MySQL, and MongoDB wire protocols.


Market Context

The database backup and recovery market is estimated at over $5 billion globally in 2025, growing at approximately 10–13% CAGR (research.md). Cloud-native services typically charge $0.02–$0.10/GB/month, while managed offerings such as Supabase include PITR from $25/month. Primary buyers are database administrators and platform engineers managing self-hosted or multi-cloud databases, startup CTOs seeking automated backup without operational overhead, and regulated-industry engineers needing auditable recovery evidence.


Project Status

This project is in the research and specification phase.
Contributions, feedback, and domain expertise are welcome.


Contributing

We welcome contributions from developers, domain experts, and potential users. See CONTRIBUTING.md for guidelines.

Important: All contributions must be your own original work or clearly attributed open-source material with a compatible licence. Copyright infringement and licence violations will not be tolerated and will result in immediate removal of the offending contribution. If you are unsure whether a piece of code, text, or other material is safe to contribute, open an issue and ask before submitting.


Licence

Licence to be determined. See discussion for context.