CAPYSQUASH

---

CAPYSQUASH documentation page.

---

Title: 'CAPYSQUASH Platform: One-Click Migration Magic' Description: '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

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

Sign Up Free

Read Setup Guide

NEXT STEPS


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

How is this guide?

On this page