Clonit

Clonit is a CLI tool for snapshotting, sanitizing, sharing, and subsetting databases. It wraps native database tools (PostgreSQL first, MySQL supported) to give you a complete workflow for capturing production snapshots, stripping sensitive data, and distributing clean copies to development and CI environments.

Clonit is standalone-first — every core operation works locally with no cloud connection. Clonit Cloud is an optional extension that adds team collaboration, cross-device access, and snapshot sharing.

Key features

Build & load snapshots

Capture with native pg_dump directory format and configurable parallel jobs; restore with pg_restore or psql.

Relational subsetting

Extract a referentially-intact slice of a database by following foreign-key relationships, so dev datasets stay small but valid.

Sanitize sensitive data

A full pipeline: restore to a temporary database, apply transformations, and dump the sanitized result.

AI sanitization analysis

Detect sensitive columns with an LLM and auto-generate sanitization SQL — locally or, with the cloud, server-side per organization.

Push / pull storage

Move snapshots to and from S3 and Cloudflare R2 with retry, checksums, and resume — using your own buckets.

Ephemeral sanitization

Test sanitization queries in isolated Docker containers with real-time progress.

Web UI

A browser-based interface for managing targets, snapshots, analysis, and cloud features.

Encrypted at rest

Sensitive fields such as connection URLs and credentials are AES-GCM encrypted in the local metadata store.

Where to go next

Quick StartCapture and load your first snapshot in five minutes.

InstallationInstall Clonit and verify your setup.

ConfigurationConfig file, environment variables, and defaults.

Command ReferenceEvery command, flag, and example.

ArchitecturePackage layout, design decisions, and data flow.

Clonit CloudSign in, connect your agent, and share snapshots with your team.