Neon
Neon is serverless PostgreSQL with branching, autoscaling, and instant provisioning.
Connection
Use the connection string from your Neon dashboard. Neon supports connection pooling via PgBouncer.
Setup
# Connection string from Neon dashboard migrationpilot analyze migration.sql \ --database-url "postgresql://user:pass@ep-abc-123.us-east-2.aws.neon.tech/mydb?sslmode=require" # Test on a Neon branch first neonctl branches create --name migration-test migrationpilot analyze migration.sql \ --database-url "postgresql://user:pass@ep-branch-456.us-east-2.aws.neon.tech/mydb"
Tips
- •Neon branches let you test migrations on a copy of production data before deploying
- •Use the pooled connection string for analysis to avoid connection limits
- •Neon autoscaler may affect table size estimates — use a branch of production for accurate context
- •Neon supports PostgreSQL 14-17