CAPYSQUASH: CLI or Platform
Use CAPYSQUASH your way - free CLI or full Platform
CAPYSQUASH: CLI or Platform
Use CAPYSQUASH your way: free CLI for solo devs or Platform for teams.
THE OPEN CORE MODEL
CAPYSQUASH gives you flexibility. Start with the free capysquash-cli for local development, or use the CAPYSQUASH Platform for team collaboration and visual workflows. Same powerful technology underneath.
CAPYSQUASH Platform
Visual workflow with team features
Web-based platform with visual dashboards, GitHub automation, and team collaboration. Perfect for teams and individuals who want automation.
capysquash-cli
Free, open-source command-line tool
Fully-featured CLI powered by pgsquash-engine for developers who prefer terminal workflows and local-first development.
The upgrade path is about interface and automation, not features. CLI is powerful. Platform adds web UI, GitHub automation, project history, and analytics. Teams get collaboration features on top.
FEATURE COMPARISON
| Feature | capysquash-cli | CAPYSQUASH Platform |
|---|---|---|
| Core Analysis Engine | ☑ Full power | ☑ Same engine |
| Safety Levels | ☑ All 4 levels | ☑ All 4 levels |
| Docker Validation | ☑ Local | ☑ Cloud |
| AI Analysis | ☑ Optional | ☑ Optional |
| Pattern Detection | ☑ | ☑ |
| TUI Interface | ☑ | ☒ |
| Local-first | ☑ | ☒ |
| Team Collaboration | ☒ | ☑ |
| Multi-project Dashboard | ☒ | ☑ |
| Role-based Access Control | ☒ | ☑ |
| GitHub Integration | Manual | ☑ Automatic |
| Automated PR Comments | ☒ | ☑ |
| API Access | ☒ | ☑ |
| Webhooks | ☒ | ☑ |
| Activity Audit Log | ☒ | ☑ |
| White-label Branding | ☒ | ☑ (Agency+) |
| SSO/SAML | ☒ | ☑ (Enterprise) |
| Priority Support | Community | ☑ (Paid plans) |
WHEN TO USE capysquash-cli
⌨️ TERMINAL-FIRST SCENARIOS
☑ Perfect for:
Terminal Lovers
- You prefer command-line interfaces
- You want local-first workflows
- You're comfortable with shell scripts
- You're working offline or with sensitive data
Learning & Experimentation
- First time trying migration squashing
- Exploring different safety levels
- Understanding how consolidation works
- Testing with sample projects
CI/CD Integration
- You want to run squashing in your pipeline
- You're comfortable with shell scripts
- You need maximum flexibility
- You're already using CLI-based tools
Open Source Projects
- Your project is public
- Contributors use various setups
- You want zero external dependencies
- Community support is sufficient
Example Workflows:
# Quick local squash
pgsquash analyze migrations/
pgsquash squash migrations/ --safety standard
# CI/CD pipeline
pgsquash squash migrations/ --output clean/ --quiet
pgsquash validate migrations/ clean/
# Development with AI analysis
export ANTHROPIC_API_KEY="..."
pgsquash analyze-deep migrations/WHEN TO USE CAPYSQUASH
🌐 WEB UI & AUTOMATION SCENARIOS
☑ Perfect for:
Web Interface Preference
- You prefer visual dashboards over terminals
- You want drag-and-drop file uploads
- You need easy access from any device
- You want beautiful charts and analytics
Automation & History
- Automatic GitHub PR analysis
- Track all squashes with before/after comparisons
- See optimization impact over time
- Get notifications for migration issues
Team Collaboration (when you need it)
- Multiple developers working together
- Share projects and configurations
- Role-based access control
- Activity audit logs
Agency Work
- Managing multiple client projects
- Need professional reporting
- White-label branding required
- Client handoff documentation
Enterprise Requirements
- Compliance and audit trails needed
- SSO/SAML authentication required
- Cross-team collaboration
- SLA guarantees needed
Example Workflows:
- Team Lead: Creates project, sets safety level, invites team
- Developer: Opens PR → Automatic analysis → Results commented
- Manager: Reviews multi-project dashboard → Sees migration health
- Agency: Manages 50 client projects from single dashboard
PERSONA-DRIVEN DECISION GUIDE
The "Vibe Coder" / Indie Hacker
Your Pain: Project is getting slow and messy after months of prototyping.
Use pgsquash-engine if:
- You love terminal workflows
- You want local-first simplicity
- You're comfortable with command-line tools
Use CAPYSQUASH if:
- You prefer web interfaces over terminals
- You want automatic GitHub PR analysis
- You want to track optimization history visually
- You're planning to collaborate with co-founders
Recommendation: Choose based on interface preference, not team size.
The Startup Generalist / Founding Engineer
Your Pain: Need to move fast, track changes, and prepare for team growth.
Use pgsquash-engine if:
- You're deeply technical and CLI-native
- You prefer scripting everything
- Budget is extremely tight
Use CAPYSQUASH if:
- You want web-based workflow
- You need GitHub automation for PRs
- You want to track migration health over time
- You're onboarding non-technical stakeholders
- Team is growing or will grow soon
Recommendation: CAPYSQUASH for velocity and visibility, even solo.
💼 The Agency Developer
Your Pain: Wasting non-billable hours, need professional deliverables.
Use pgsquash-engine if:
- Managing 1-2 clients
- Very price-sensitive
- Comfortable with manual processes
Use CAPYSQUASH if:
- Managing 3+ client projects
- Need professional reporting
- Want white-label branding
- Billing hours for migration cleanup
- Want multi-project dashboard
Recommendation: CAPYSQUASH (Agency plan) for efficiency and professionalism.
The Backend Specialist / "Closet DBA"
Your Pain: Technical sloppiness, redundant SQL, loss of control.
Use pgsquash-engine if:
- You want maximum control
- You prefer local-first tools
- You're fine with manual workflows
- You want to understand every detail
Use CAPYSQUASH if:
- You need to collaborate with frontend devs
- You want API access for custom tooling
- You need audit trails for compliance
- You want to prove ROI to management
Recommendation: Start with pgsquash-engine, add CAPYSQUASH when you need collaboration/automation.
MIGRATION PATH
You can always start with one and add the other later:
pgsquash-engine → CAPYSQUASH
EASY UPGRADE PATH
- Keep using pgsquash-engine locally for development
- Add CAPYSQUASH for:
- Team collaboration
- GitHub automation
- Multi-project management
- Use both together:
- pgsquash-engine for local quick checks
- CAPYSQUASH for production squashing
- API for custom automation
CAPYSQUASH → pgsquash-engine
ALWAYS HAVE THE OPTION
- CAPYSQUASH uses the same engine as pgsquash-engine
- Can always export and run locally
- pgsquash-engine remains free and open-source forever
- No vendor lock-in
PRICING COMPARISON
| pgsquash-engine | CAPYSQUASH | |
|---|---|---|
| Individual | Free forever | Free (3 projects) |
| Small Team | Free forever | $12/mo (Creator) |
| Growing Team | Free forever | $29/mo (Professional) |
| Agency | Free forever | $99/mo (Agency) |
| Enterprise | Free forever | Custom pricing |
pgsquash-engine will always be free and fully-featured. We build a sustainable business by solving team problems, not by crippling individual tools.
QUICK DECISION MATRIX
Choose pgsquash-engine if:
- ☑ You prefer terminal-based workflows
- ☑ You want local-first, offline-capable tools
- ☑ You're comfortable with shell scripts
- ☑ You don't need web UI or automation
- ☑ You're on a tight budget
Choose CAPYSQUASH if:
- ☑ You prefer web interfaces over terminals
- ☑ You want automatic GitHub PR analysis
- ☑ You need project history and analytics
- ☑ You want beautiful dashboards
- ☑ You manage multiple projects
- ☑ You're working with a team (or planning to)
Use Both if:
- ☑ You want the best of both worlds
- ☑ pgsquash-engine for local dev, CAPYSQUASH for production
- ☑ Different workflows for different contexts
- ☑ Maximum flexibility
NEXT STEPS
Ready to start with capysquash-cli?
Ready to try CAPYSQUASH?
Still not sure?
How is this guide?