CAPYSQUASH

CAPYSQUASH Platform: One-Click Migration Magic

Experience the magic of visual migration optimization - transform hundreds of messy files into a clean, optimized set with a single click

CAPYSQUASH Platform: Visual Migration Optimization

Experience streamlined visual migration optimization - transform hundreds of messy files into a clean, optimized set in minutes.

CAPYSQUASH makes PostgreSQL migration optimization feel effortless. No configuration files, no learning curve, no database PhD required. Just upload your migrations and watch the magic happen.

💡 Why "One-Click" in Marketing? While the workflow has a few simple steps (upload → analyze → download), the complex analysis itself happens with one button press. Compared to hours of manual work, it feels like magic.

WHY CAPYSQUASH?

CAPYSQUASH is the complete ecosystem for PostgreSQL migration optimization:

  • pgsquash-engine: The core technology - open-source library and engine (MIT license) that powers everything
  • capysquash-cli: The official CLI tool - free, powerful command-line interface for developers
  • CAPYSQUASH Platform: The SaaS product - visual dashboards, team collaboration, and enterprise automation

All three share the same parser-grade technology. Use the CLI for local development, the Platform for team workflows.

ONE-CLICK MAGIC

  • Visual Optimization - See your migration cleanup happen in real-time
  • 🎯 Zero Configuration - No setup, no learning curve, just connect and optimize
  • 🔌 Smart Auto-Detection - Recognizes Supabase, Clerk, Neon patterns instantly
  • Instant Results - Transform 287 files into 12 in under 10 minutes
  • 🛡️ Safety Built-In - Docker validation ensures nothing ever breaks
  • 🎨 Beautiful Interface - Migration management that doesn't hurt your eyes

EFFORTLESS AUTOMATION

  • 🚀 GitHub Magic - Install once, optimize every PR automatically
  • Set & Forget - Schedule cleanups while you focus on building
  • 📡 Smart Notifications - Get alerts only when you need them
  • 🤖 AI Insights - Suggestions that actually make sense for your code
  • 🔄 CI/CD Bliss - One line of code, infinite optimization power
  • 📊 Impact Tracking - Watch your deployment times plummet in real-time

TEAM HAPPINESS

  • 👥 Share the Magic - Team members can see and use optimized migrations
  • 💬 Activity Tracking - Monitor team optimization activity and progress
  • 📁 Organize Effortlessly - Group by project, team, or environment
  • 🔄 Real-time Updates - See what your team is optimizing right now
  • 📈 Celebrate Wins - Track how much time you're saving together
  • 🎯 Migration Health - Know exactly when it's time to optimize

PEACE OF MIND

  • 🛡️ End-to-End Encryption - All data encrypted in transit (TLS 1.3) and at rest (AES-256)
  • 🔐 Multi-Factor Authentication - Enhanced security with 2FA/MFA via Clerk
  • 📋 Activity Audit Trails - Complete audit logs for all user actions
  • 🏢 SSO/SAML (🚧 Coming Q1 2026) - Via Clerk Enterprise integration
  • 🔒 SOC 2 & GDPR (📅 Planned) - Pursuing formal compliance certifications
  • 🌐 Custom Domains & White-Label (🚧 Coming Q1 2026) - Brand as your own

PLATFORM CAPABILITIES

🗂️ Projects

Organize your migrations by application, environment, or client.

  • Unlimited projects (paid plans) with custom colors and icons
  • Database connections - Store and manage credentials securely (Neon, Supabase, AWS RDS, Azure)
  • Default safety levels per project with auto-squash settings
  • Team access control with role-based permissions
  • Archive/unarchive and favorites for better organization
  • Project metadata including provider, environment tagging, and descriptions

Learn more about Projects →

👥 Organizations

Team workspaces with enterprise-grade collaboration.

  • Invite team members via Clerk Dashboard (paid plans) with role-based access control
  • Roles managed through Clerk: Admin, Member, Viewer permissions
  • Shared billing with unified subscription management
  • Activity audit trail with complete logs for all actions
  • Custom branding (🚧 Coming Q1 2026) with logos and domains
  • Organization settings for default safety levels and notifications

💡 Team Management: Team invitations are handled through the Clerk Dashboard. Once invited, members automatically access your CAPYSQUASH organization.

Learn more about Organizations →

🚀 GitHub Integration

Automate migration analysis directly in pull requests.

  • Automatic PR analysis on open/update with real-time processing
  • Rich PR comments with file reduction stats, warnings, and recommendations
  • Full monorepo support with path-based project detection
  • One-click installation from GitHub Marketplace
  • Webhook signature verification for security
  • Manual triggers from dashboard for specific PRs

Learn more about GitHub Integration →

🔌 API Access

Integrate with your CI/CD pipeline programmatically.

  • Comprehensive REST API for complete platform automation
  • API key management with scopes, expiration dates, and usage tracking
  • Smart rate limiting with quota management
  • Webhook support for analysis completion and usage alerts
  • Full OpenAPI documentation with interactive explorer
  • Secure authentication with organization-level secrets

Learn more about the API →

📊 Analytics & Reporting

Track optimization impact across your organization.

  • Comprehensive dashboards with file reduction, time savings, and usage metrics
  • Visual analytics including charts for operations breakdown and project comparisons
  • Export options for data via API access
  • Activity tracking with complete audit logs for security and compliance
  • Custom reports (🚧 In Development) with ROI calculations and branded PDFs

🔔 Smart Notifications

Flexible event-based notification system.

  • Custom notification rules with conditional logic and event triggers
  • Multi-channel delivery: Email, Slack webhooks, in-app notifications
  • Usage alerts at 80% and 100% of plan limits
  • Team targeting by role, user, or custom email addresses
  • Webhook integration for custom automation workflows

🔐 Enterprise Security

Enterprise-grade security features with compliance roadmap.

  • End-to-end encryption with AES-256 at rest and TLS 1.3 in transit
  • Role-based access control with organization isolation and fine-grained permissions
  • Activity audit trails with complete logs for all user actions
  • MFA via Clerk for enhanced account security
  • SSO/SAML (🚧 Coming Q1 2026) via Clerk Enterprise - Okta, Auth0, Azure AD
  • SOC 2 & GDPR (📅 Planned) - Pursuing formal compliance certifications
  • Data retention policies with export and deletion capabilities

WHO IS IT FOR?

Startups & Growing Teams

Your pain: Team friction, merge conflicts, onboarding struggles.

The solution:

  • Onboard new engineers in minutes with shared projects
  • Avoid migration merge conflicts with automated analysis
  • De-risk deployments with validation checks
  • Track team activity with audit logs

Perfect when:

  • Team grows beyond 3-5 people
  • Multiple developers touching migrations
  • Need stability and confidence
  • Want to move fast without breaking things

💼 Agencies

Your pain: Managing multiple client projects, non-billable hours, unprofessional deliverables.

The solution:

  • Multi-project dashboard to manage all clients from one view
  • Professional reporting and analytics
  • Automated cleanup saves billable hours
  • Clean handoffs with professional documentation

Perfect when:

  • Managing 3+ client projects
  • Need professional reporting
  • Want to reduce non-billable time
  • Client satisfaction is critical

🏢 Enterprises

Your pain: Compliance requirements, security audits, cross-team collaboration.

The solution:

  • Enterprise-grade security - Protect your data with confidence
  • Single sign-on - Easy access with your identity provider
  • End-to-end encryption - All data encrypted in transit and at rest
  • Compliance audit trails - Complete audit logs for security and compliance
  • Custom deployment options - Flexible deployment options for your organization

Perfect when:

  • Compliance is mandatory
  • Need enterprise security
  • Cross-team collaboration
  • Custom integrations required

HOW IT WORKS

Ready to Get Started?

See our Platform Quickstart Guide for a detailed step-by-step walkthrough from signup to your first optimized migration.

The CAPYSQUASH workflow in 3 phases:

  1. Upload & Auto-Detect - Upload migrations, we instantly detect your stack (Supabase, Clerk, Neon, etc.)
  2. Analyze & Validate - Smart consolidation with Docker validation ensures zero breakage
  3. Download & Deploy - Get optimized migrations with detailed reports and recommendations

PRICING

PlanPriceBest For
Free$0/moIndividual developers, trying out
Creator$12/moSolo developers with multiple projects
Professional$29/moSmall teams (5-10 people)
Agency$99/moAgencies managing client projects
EnterpriseCustomLarge organizations with compliance needs

View detailed pricing →

FREE PLAN INCLUDES:

  • ☑ 3 projects
  • ☑ 10 analyses per month
  • ☑ Basic features
  • ☑ Community support

USE CAPYSQUASH YOUR WAY

CAPYSQUASH gives you flexibility: use the free CLI locally or the Platform for team features.

Development workflow:

# Developer uses capysquash-cli locally for quick checks
capysquash analyze migrations/

# Opens PR → CAPYSQUASH Platform automatically analyzes
# Team reviews results in CAPYSQUASH dashboard

# Production squashing uses CAPYSQUASH Platform for audit trail

The best of both worlds:

  • Free capysquash-cli for local development speed
  • CAPYSQUASH Platform for team collaboration and automation
  • Same powerful pgsquash-engine technology underneath

GETTING STARTED

NEXT STEPS


Questions? Join our Discord or email hello@capysquash.dev

How is this guide?

On this page