CAPYSQUASH

Welcome to CAPYSQUASH

Powerful Postgres migration management for individuals and teams

WELCOME TO CAPYSQUASH

Autopilot for Your Postgres Migrations: Transform 287 Files into 12 with One Click

Experience the magic of visual migration optimization that just works. CAPYSQUASH turns complex PostgreSQL migration management into a streamlined, one-click process - no database PhD required.

Built on pgsquash-engine, an advanced open-source PostgreSQL migration technology, CAPYSQUASH combines mathematical precision with beautiful simplicity. Choose your experience: capysquash-cli for powerful command-line workflows, or CAPYSQUASH Platform for visual team collaboration.

CHOOSE YOUR CAPYSQUASH EXPERIENCE

CAPYSQUASH Platform

The visual autopilot that makes migration optimization feel like magic. Connect your repo and watch cleanup happen automatically while you focus on building features.

  • ✨ One-Click Autopilot - Connect GitHub, hit "Optimize," and watch 287 files become 12 instantly
  • 🎨 Visual Streamlined Interface - Real-time migration cleanup with beautiful analytics and progress tracking
  • 🔌 Smart Plugin Detection - Auto-optimizes for Supabase, Clerk, Neon, Auth0 - zero configuration needed
  • 🚀 GitHub Automation - PR analysis, scheduled cleanups, team notifications, and workflow integration
  • 👥 Team Collaboration - Share results, track progress, and manage projects across your organization
  • 📊 ROI Analytics - Watch deployment time drop from hours to minutes with detailed impact metrics
  • 🛡️ Zero-Risk Validation - Docker-based schema validation ensures 100% equivalence, every time
  • 🔐 Enterprise Security - SSO, audit logs, compliance features, and dedicated support

Get Started with CAPYSQUASH →

capysquash-cli

The official CLI tool powered by pgsquash-engine - parser-grade accuracy that understands your migrations better than any human could.

  • 🧠 PostgreSQL's Actual Parser - Uses pg_query_go (PostgreSQL's C parser) for 100% accurate SQL analysis
  • ⚡ Blazing Performance - Optimizes 1000+ migrations in under 60 seconds with streaming processing
  • 🔌 Platform Intelligence - Built-in knowledge of Supabase, Clerk, Neon, Auth0, NextAuth patterns
  • 🛡️ Mathematical Safety - Docker validation proves schema equivalence with absolute certainty
  • 🎯 Configurable Safety - Four safety levels from paranoid (15% reduction) to aggressive (95% reduction)
  • 🔧 Developer-First - CLI + HTTP API perfect for terminal wizards, CI/CD, and automation
  • 🆓 Truly Open Source - MIT license, no limits, no enterprise tiers - just freedom to innovate
  • 🤖 AI-Enhanced - Optional semantic analysis for function equivalency and dead code detection

Install capysquash-cli →

✨ WHY DEVELOPERS CHOOSE CAPYSQUASH

THE AUTOPADVANTAGE

287 → 12

Files optimized with one click

15 min → 45 sec

Deployment time transformation

0% Breakage

Perfect schema equivalence guaranteed

The Magic Behind the Curtain

It Just Works: No configuration, no learning curve, no database PhD required. Connect your repository and watch the magic happen.

Traditional Migration Pain:

  • ☒ Manual file organization and dependency tracking nightmares
  • ☒ Complex merge conflicts and coordination headaches
  • ☒ Hours wasted understanding migration relationships
  • ☒ Constant risk of breaking production with manual changes

CAPYSQUASH Autopilot:

  • ☑ Zero Configuration - Auto-detects Supabase, Clerk, Neon patterns instantly
  • ☑ Visual Dependency Mapping - See exactly what will be optimized before you commit
  • ☑ One-Click Transformation - Convert hundreds of messy files into clean, optimized sets
  • ☑ Built-in Safety Net - Docker validation guarantees nothing breaks, ever

Platform Intelligence: Built-in Expertise

CAPYSQUASH automatically detects and optimizes for your modern stack - no configuration required:

# Zero configuration - we detect everything automatically
[plugins] Auto-detected: supabase, clerk, neon
[plugins] Found 23 RLS policies to preserve
[plugins] Detected 7 auth schema patterns
[plugins] Ready for optimization in 3.2 seconds

Supported Out of the Box:

  • 🟣 Supabase - Auth schema, RLS policies, realtime functions, storage buckets
  • 🔵 Clerk - JWT v2 tables, authentication patterns, organization claims
  • 🟢 Neon - Serverless PostgreSQL optimizations and branching patterns
  • 🟡 Auth0 - Custom authentication table patterns and user management
  • ⚪ NextAuth - Session management schemas and adapter patterns

SEE THE AUTOPILOT IN ACTION

1
Connect your GitHub repository (30 seconds flat)
2
Watch auto-detection identify your entire stack (instant)
3
Click "Optimize" and see the transformation (under 10 minutes)
4
Deploy with absolute confidence - validation built-in (always safe)

Not sure which to start with? Try the free capysquash-cli to experience the power, then upgrade to CAPYSQUASH Platform for team automation and visual workflow.

THE MIGRATION CHALLENGE WE SOLVE

Rapid development creates migration chaos. Every schema change generates another file. Before you know it, you have hundreds of migration files cluttering your project and slowing down your entire development pipeline.

The Real-World Pain:

  • Slow Deployments: Minutes wasted replaying 150-300 migrations in production
  • Team Friction: Constant merge conflicts in migration files block progress
  • Lost Context: New developers can't understand schema evolution without hours of investigation
  • Repository Bloat: Slow clones, wasted storage, and reduced developer productivity

The CAPYSQUASH Solution:

CAPYSQUASH intelligently consolidates your migrations using PostgreSQL's actual parser (pg_query_go) for 100% accurate SQL analysis. Docker-based validation ensures zero schema drift. Whether you choose the free capysquash-cli or the CAPYSQUASH Platform, you get the same powerful pgsquash-engine technology

QUICK START

FOR TEAMS & ORGANIZATIONS (CAPYSQUASH Platform)

GET STARTED IN 3 STEPS

1

SIGN UP

Create your free account at capysquash.dev

2

CREATE ORGANIZATION

Set up your team workspace and invite members

3

CONNECT & ANALYZE

Link your repos and start analyzing migrations

FOR INDIVIDUAL DEVELOPERS (capysquash-cli)

CLI SETUP IN 2 MINUTES

1

INSTALL

brew install capysquash/tap/capysquash-cli

Or with Go:

go install github.com/CAPYSQUASH/capysquash-cli/cmd/capysquash@latest
2

ANALYZE & SQUASH

capysquash analyze migrations/
capysquash squash --safety=standard

EXPLORE THE DOCS

CAPYSQUASH

Easy to use modern and secure platform with 3rd party service integrations, easy workflows, advanced collaboration and compliance

API Authentication

Complete API authentication and access guide

API Reference

Comprehensive REST API for enterprise integration

Complete Supabase Guide

Master Supabase migration optimization with auth schemas, RLS policies, and storage patterns

Getting Started

Installation and setup guides

Core Concepts

Understand how squashing works and why it's safe

Neon PostgreSQL Guide

Optimize for serverless Neon with branching, connection pooling, and edge SQL

PostgreSQL Parser Deep Dive

Explore the sophisticated parsing technology that enables 100% accuracy

KEY FEATURES

SAFE BY DEFAULT

Docker-based validation ensures zero schema drift. Every squash is verified against your actual database.

LIGHTNING FAST

Clean up 287 migrations to 12 in under 10 minutes. Dramatically speed up CI/CD pipelines.

SMART ANALYSIS

Intelligent migration analysis identifies safe consolidation opportunities automatically.

FLEXIBLE SAFETY

Choose from conservative, standard, or aggressive safety levels based on your needs.

NEXT STEPS

Teams & Organizations:

Individual Developers:

Developers & Library Users:

Need help? Check out our GitHub Discussions or Contact Support.

How is this guide?

On this page

WELCOME TO CAPYSQUASHCHOOSE YOUR CAPYSQUASH EXPERIENCE✨ WHY DEVELOPERS CHOOSE CAPYSQUASHThe Magic Behind the CurtainPlatform Intelligence: Built-in ExpertiseTHE MIGRATION CHALLENGE WE SOLVEQUICK STARTFOR TEAMS & ORGANIZATIONS (CAPYSQUASH Platform)FOR INDIVIDUAL DEVELOPERS (capysquash-cli)EXPLORE THE DOCSKEY FEATURESNEXT STEPS