Installing the GitHub App
Set up the CAPYSQUASH GitHub App for your repositories
INSTALLING THE GITHUB APP
Automatically analyze migrations in pull requests by installing the CAPYSQUASH GitHub App.
PREREQUISITES
WHAT YOU NEED
- ☑ Active CAPYSQUASH organization (Creator plan or higher)
- ☑ Admin access to GitHub organization or repository
- ☑ At least one project created in CAPYSQUASH
⚠️ Note: GitHub integration is not available on the Free plan. Upgrade to Creator, Professional, Agency, or Enterprise.
INSTALLATION STEPS
INSTALL IN 3 STEPS
GO TO ORGANIZATION SETTINGS
Navigate to your organization integrations page:
Dashboard → [Your Organization] → Settings → Integrations → GitHub
INSTALL GITHUB APP
Click "Install GitHub App" button
- ► Redirected to GitHub authorization page
- ► Choose organization or personal account
- ► Select repositories (all or specific ones)
- ► Grant permissions and install
CONFIGURE PROJECTS
Link CAPYSQUASH projects to GitHub repositories:
- ► Return to CAPYSQUASH dashboard
- ► Go to each project's settings
- ► Link to GitHub repository
- ► Configure analysis rules
PERMISSION SCOPES
The GitHub App requires these permissions:
Repository Permissions
| Permission | Access | Purpose |
|---|---|---|
| Pull requests | Read & Write | Post analysis comments |
| Contents | Read | Read migration files |
| Checks | Read & Write | Create status checks |
| Metadata | Read | Repository information |
Organization Permissions
| Permission | Access | Purpose |
|---|---|---|
| Members | Read (optional) | Organization-wide install |
Webhook Events
The app subscribes to:
pull_request(opened, synchronize, reopened)pull_request_review_comment(for manual triggers)
💡 Security: The app only reads migration files from configured paths. It never writes to your repository or accesses other files.
INSTALLATION OPTIONS
Option 1: All Repositories
Install on all current and future repositories:
Pros:
- Automatic for new repositories
- One-time setup
- Consistent across organization
Cons:
- Broader access
- May analyze non-relevant repos
Best for: Organizations with consistent migration practices
Option 2: Specific Repositories
Install only on selected repositories:
Pros:
- More control
- Limited access scope
- Only relevant repos
Cons:
- Manual selection for new repos
- Must update as you add repos
Best for: Organizations with mixed tech stacks or selective needs
MULTIPLE ORGANIZATIONS
You can install the GitHub App on multiple GitHub organizations:
- Each GitHub org has separate installation
- Link each to the same or different CAPYSQUASH organization
- Manage installations independently
- Usage counts toward your CAPYSQUASH plan limit
Example setup:
GitHub Org: acme-frontend → CAPYSQUASH Org: ACME Inc
GitHub Org: acme-backend → CAPYSQUASH Org: ACME Inc
GitHub Org: client-projects → CAPYSQUASH Org: Agency TeamVERIFYING INSTALLATION
After installation, verify everything is connected:
1. Check Integration Status
In CAPYSQUASH:
Organization → Settings → Integrations → GitHubYou should see:
- ☑ Connected status
- GitHub organization/account name
- List of installed repositories
- Installation date
2. Test with a PR
Create a test PR with a migration file:
# In your repo
git checkout -b test-CAPYSQUASH
echo "CREATE TABLE test (id INT);" > migrations/test.sql
git add migrations/test.sql
git commit -m "test: CAPYSQUASH integration"
git push origin test-CAPYSQUASH
# Open PR on GitHub
gh pr create --title "Test CAPYSQUASH" --body "Testing GitHub App"Within 30 seconds, CAPYSQUASH should:
- Post a comment on the PR
- Create a status check
- Show analysis results
3. Check Webhook Deliveries
In GitHub:
Settings → GitHub Apps → CAPYSQUASH → Advanced → Recent DeliveriesYou should see successful webhook deliveries.
TROUBLESHOOTING
App Not Showing in CAPYSQUASH
Problem: GitHub redirect completed but app not showing in dashboard
Solutions:
- Wait 30 seconds and refresh
- Check if installation was for correct GitHub account
- Verify you have admin access to CAPYSQUASH organization
- Try disconnecting and reinstalling
Repositories Not Listed
Problem: Installed app but repositories don't appear
Solutions:
- Go to GitHub → Settings → Applications → CAPYSQUASH
- Click "Configure"
- Verify repositories are selected
- Save changes
- Refresh CAPYSQUASH dashboard
Installation Failed
Problem: Error during GitHub authorization
Solutions:
- Check you have admin access to GitHub org/repo
- Try in incognito/private browser window
- Clear cookies and try again
- Check GitHub status page for outages
- Contact support if persists
Permission Denied
Problem: App installed but can't access repositories
Solutions:
- Verify your GitHub role has sufficient permissions
- Check organization's third-party application policy
- Ask GitHub org admin to approve the app
- Reinstall with correct permissions
UPDATING PERMISSIONS
If CAPYSQUASH updates permission requirements:
- You'll see a notification in dashboard
- Click "Update Permissions" button
- Redirected to GitHub to approve new permissions
- Confirm and save
Note: App won't work properly until permissions are updated.
REPOSITORY SELECTION
Adding Repositories Later
Add more repositories after initial install:
- Go to CAPYSQUASH → Organization → Integrations → GitHub
- Click "Manage Repositories"
- Redirected to GitHub configuration
- Select additional repositories
- Save changes
Removing Repositories
Remove repositories from the app:
- Same process as adding
- Deselect repositories to remove
- CAPYSQUASH will stop analyzing PRs for those repos
- Historical data is preserved
ORGANIZATION VS PERSONAL ACCOUNT
GitHub Organization Install
When:
- Working in a team
- Company/startup repositories
- Multiple collaborators
Benefits:
- Central management
- Team visibility
- Organization-wide policies
Personal Account Install
When:
- Personal projects
- Solo developer
- Side projects
Benefits:
- Simpler setup
- Direct control
- Lower plan requirements
Note: Both work the same way in CAPYSQUASH
NEXT STEPS
📁 REPOSITORY SETUP
Configure migration paths and analysis rules
🔄 PR WORKFLOW
Learn how analysis works in pull requests
SUPPORT
Need help with installation?
- 📧 Email: support@CAPYSQUASH.dev
- 💬 Discord: Join community
- 📖 Docs: Check troubleshooting guide
- 🎫 Support: Open ticket in dashboard
How is this guide?