Basecut

The product is a CLI tool that subsets, anonymizes, and restores PostgreSQL production data for development, staging, and CI use, solving broken foreign keys, slow manual dumps, seed scripts, and PII exposure in non-production environments. It sells to developers, data and operations roles within engineering teams at B2B software companies that need realistic, current datasets for local development, onboarding, and testing. It is positioned against pg_dump, seed scripts, and shared staging with FK-aware subsetting, auto-detection of sensitive fields, and one-command snapshot create and restore.

Key features

• FK-aware PostgreSQL subsetting
• PII auto-detection and anonymization
• YAML snapshot configuration
• One-command snapshot create
• One-command snapshot restore
• Referential integrity verification
• Scheduled refreshes via CI/cron
• Local and VPC execution modes
• Versioned snapshot packaging
• Schema validation on restore