CAPYSQUASH Ecosystem: Choose Your Tool

Three ways to use CAPYSQUASH: library, CLI, or Platform.

The CAPYSQUASH ecosystem offers flexibility for every workflow:

• pgsquash-engine: Core library for building custom tools
• capysquash-cli: Official CLI for terminal workflows
• CAPYSQUASH Platform: SaaS for team collaboration

All powered by the same parser-grade technology.

🎯 Quick Decision Guide

Use pgsquash-engine (Library) if you:

• ☑ Building custom tools that need programmatic migration optimization
• ☑ Integrating into existing systems and workflows
• ☑ Need full control over the optimization process
• ☑ Want to embed migration optimization in your application
• ☑ Prefer Go libraries over CLI tools

Use capysquash-cli if you:

• ☑ Love the terminal and prefer command-line workflows
• ☑ Work solo or on small teams
• ☑ Need local development speed and offline capability
• ☑ Are integrating into CI/CD pipelines
• ☑ Want a ready-to-use tool without writing code
• ☑ Prefer open-source CLI tools with MIT license

Use CAPYSQUASH Platform if you:

• ☑ Have a team that needs collaboration
• ☑ Want visual workflow with real-time progress
• ☑ Need GitHub automation and PR analysis
• ☑ Require enterprise features like SSO and audit logs
• ☑ Want scheduled automation and notifications
• ☑ Need analytics and reporting on optimization impact

📊 Feature Comparison Matrix

🛠️ Technical Capabilities Comparison

Core Engine Features (Identical)

Both solutions share the same powerful optimization engine:

# Same core capabilities in both
capysquash analyze migrations/           # Migration analysis
capysquash squash migrations/            # Consolidation
capysquash validate original/ squashed/  # Schema validation

Note: You can use either capysquash or pgsquash - both commands work identically.

Shared Technical Foundation:

• PostgreSQL's actual parser (pg_query_go) for 100% accuracy
• 5-phase consolidation process (Parse → Track → Analyze → Consolidate → Validate)
• Docker-based validation with mathematical equivalence proof
• 4 safety levels with clear tradeoffs
• Plugin system for third-party service patterns

Platform-Only Enhancements

CAPYSQUASH adds enterprise-grade capabilities on top of the engine:

1. Automated GitHub Integration

# capysquash-cli: Manual setup
git clone repo
cd repo
capysquash analyze migrations/
git add optimized/
git commit -m "Optimize migrations"
git push

# CAPYSQUASH Platform: Automatic
# Install GitHub App (one-time)
# Automatic PR analysis on every push
# Scheduled cleanups
# Team notifications

2. Real-time Analytics Dashboard

# pgsquash-engine: Basic stats
Optimization complete:
- Files reduced: 287 → 12 (96%)
- Time saved: 15 minutes → 45 seconds
- Size reduced: 2.3GB → 120MB

# CAPYSQUASH Platform: Comprehensive analytics
📊 Optimization Impact Dashboard:
- ROI: $47,000 saved in developer time (6 months)
- Team productivity: +34% deployment velocity
- Migration health score: 94/100
- Technical debt reduction: 78%

3. Enterprise Security & Compliance

# pgsquash-engine: Basic security
# Local processing, no data exposure
# Manual access control

# CAPYSQUASH Platform: Enterprise security
🔒 Security Features:
- SSO/SAML integration with Okta, Azure AD
- SOC2 Type II compliance
- GDPR data protection
- End-to-end encryption
- Audit logs for all activities
- Multi-factor authentication

💰 Pricing Comparison

capysquash-cli

Cost: $0 (Free forever, open-source)

• ☑ No usage limits
• ☑ All core features included
• ☑ Community support
• ☑ MIT license
• ☑ Self-hosted

CAPYSQUASH Platform

Cost: Subscription-based (5 tiers)

ROI Calculation:

• Average team saves 10-15 hours/week on migration management
• At $100/hour developer rate = $1,000-1,500/week savings
• Platform pays for itself 3-5x over

🚀 Use Case Scenarios

Scenario 1: Solo Developer Building SaaS

Situation: Individual developer building a B2B SaaS with Supabase

Recommendation: Start with the free capysquash-cli

# Perfect workflow for solo developer
capysquash analyze supabase/migrations/
capysquash squash supabase/migrations/ --safety=standard
capysquash validate original/ optimized/
# Deploy optimized migrations

Upgrade Path: Move to CAPYSQUASH Platform when hiring first team members

Scenario 2: Startup Team of 5 Developers

Situation: Fast-growing startup with active development and frequent deployments

Recommendation: CAPYSQUASH Platform (Professional plan)

Benefits:

• Team collaboration: Share optimization results
• GitHub automation: Automatic PR analysis
• Analytics: Track optimization impact
• Support: Priority help for critical issues

Scenario 3: Enterprise with 50+ Developers

Situation: Large enterprise with multiple teams, compliance requirements, and security policies

Recommendation: CAPYSQUASH Platform (Business or Enterprise)

Critical Requirements:

• SSO/SAML: Integration with corporate identity
• Audit logs: Compliance and governance
• Multi-project: Organize by team/product
• SLA: Guaranteed uptime and support
• Custom domains: Brand as internal tool

Scenario 4: Open Source Project

Situation: Public open source project with community contributors

Recommendation: capysquash-cli (free & open-source)

Advantages:

• Free forever: No cost for community project
• Transparent: Open source code visible to contributors
• No vendor lock-in: Full control over infrastructure
• Community support: Leverage existing community

🔄 Migration Path: Engine to Platform

Step 1: Start with capysquash-cli

# Initial setup with capysquash-cli
brew install capysquash-cli
capysquash analyze migrations/
capysquash squash migrations/ --safety=conservative

Step 2: Evaluate Platform Needs

Signs it's time to upgrade:

• Team growing beyond 3 people
• Manual GitHub integration becoming tedious
• Need for analytics and reporting
• Enterprise security requirements
• Want for automated workflows

Step 3: Seamless Migration

# Export existing configurations
capysquash export-config > capysquash.config.json

# Import into CAPYSQUASH Platform
# 1. Sign up for CAPYSQUASH account
# 2. Import configuration
# 3. Connect repositories
# 4. Set up team members

Data Migration: All migration history and configurations transfer seamlessly

🎯 Decision Framework

Technical Requirements Assessment

Business Impact Analysis

Calculate Your ROI:

# Time savings calculation
Weekly migration management time: 8 hours
Developer hourly rate: $100
Weekly cost: $800
Monthly cost: $3,200
Annual cost: $38,400

# Platform investment
Professional plan: $99/month = $1,188/year
Net savings: $37,212/year (97% ROI)

📈 Success Stories

Company A: Startup (10 developers)

Before capysquash:

• 45 minutes average deployment time
• 3-4 migration conflicts per week
• Manual review process

After CAPYSQUASH Platform:

• 3 minutes deployment time (93% faster)
• Zero migration conflicts (6 months running)
• Automated PR analysis and approval

ROI: $124,000 saved in first year

Company B: Enterprise (200 developers)

Before capysquash:

• 2 hours deployment time for complex services
• Compliance audit preparation: 40 hours/quarter
• Multiple tools for different environments

After CAPYSQUASH Platform:

• 8 minutes deployment time (93% faster)
• Automated compliance reporting
• Unified platform across all teams

ROI: $1.2M saved in first year

🎚️ Feature Deep Dive

CLI Experience Comparison

####capysquash CLI

# Rich command-line interface
capysquash analyze migrations/ --verbose --output=json
capysquash squash migrations/ --safety=aggressive --validate
capysquash validate original/ optimized/ --approach=two_containers
capysquash api-server --port=8080 --auth-secret=your-key

# Detailed output
[2024-01-15 10:23:45] Starting analysis...
[2024-01-15 10:23:45] Found 47 migrations, 234 statements
[2024-01-15 10:23:46] Built dependency graph with 89 nodes
[2024-01-15 10:23:47] Detected 12 consolidation opportunities
[2024-01-15 10:23:48] Analysis complete in 2.3 seconds

CAPYSQUASH Platform CLI

# Platform CLI with cloud integration
capysquash login                          # Authenticate with platform
capysquash project create my-app          # Create cloud project
capysquash migrate analyze                # Cloud-powered analysis
capysquash migrate optimize               # Platform optimization
capysquash deploy --env=production        # Managed deployment

# Integrated with platform features
capysquash analytics show                 # View optimization impact
capysquash team invite user@company.com   # Team management
capysquash schedule set "0 2 * * 1"       # Weekly cleanup

API Experience Comparison

capysquash-api (Self-Hosted REST API)

# Self-hosted API server (separate repository)
curl -X POST http://localhost:8080/analyze \
  -H "Content-Type: application/json" \
  -d '{"migrations": [...], "options": {"safetyLevel": "standard"}}'

# Response: Analysis results only
{
  "success": true,
  "analysis": {
    "optimizationOpportunities": [...],
    "statistics": {...}
  }
}

Note: capysquash-api is maintained as a separate repository for self-hosting. See capysquash-api documentation.

CAPYSQUASH Platform API

# Cloud API with platform features
curl -X POST https://api.capysquash.dev/v1/analyze \
  -H "Authorization: Bearer $CAPYSQUASH_TOKEN" \
  -H "X-Project-ID: proj_123" \
  -d '{"migrations": [...], "options": {"safetyLevel": "standard"}}'

# Response: Analysis + platform features
{
  "success": true,
  "analysis": {...},
  "project": {
    "id": "proj_123",
    "name": "my-app",
    "team": "engineering"
  },
  "analytics": {
    "estimatedSavings": "$2,340",
    "complexityScore": "medium"
  },
  "workflow": {
    "autoApprove": false,
    "requiredReviewers": ["senior-dev"],
    "notifyTeam": true
  }
}

🎯 Making the Decision

Final Recommendation Framework

Choose pgsquash-engine if:

• You're working alone or in a small team
• You prefer terminal-based workflows
• You need full control over infrastructure
• Budget is a primary concern
• You're building open source projects

Choose CAPYSQUASH Platform if:

• You have 4+ team members
• You want automated GitHub integration
• You need enterprise security features
• Analytics and reporting are important
• You want priority support and SLAs

Hybrid Approach

Many successful teams use both:

1. Development: pgsquash-engine for local development and quick testing
2. CI/CD: CAPYSQUASH Platform for automated optimization and deployment
3. Analytics: Platform dashboards for tracking optimization impact
4. Collaboration: Platform for team coordination and review

Next Steps

For pgsquash-engine:

• Installation Guide
• CLI Commands Reference
• Configuration Options

For CAPYSQUASH Platform:

• Getting Started Guide
• Platform Features
• Pricing Plans

Ready to choose? Both options start with the same powerful optimization engine. Try pgsquash-engine today or explore CAPYSQUASH Platform to see which fits your needs best.