---
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
š„ 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
š 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:
- Upload & Auto-Detect - Upload migrations, we instantly detect your stack (Supabase, Clerk, Neon, etc.)
- Analyze & Validate - Smart consolidation with Docker validation ensures zero breakage
- Download & Deploy - Get optimized migrations with detailed reports and recommendations
PRICING
| Plan | Price | Best For |
|---|---|---|
| Free | $0/mo | Individual developers, trying out |
| Creator | $12/mo | Solo developers with multiple projects |
| Professional | $29/mo | Small teams (5-10 people) |
| Agency | $99/mo | Agencies managing client projects |
| Enterprise | Custom | Large organizations with compliance needs |
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?