← All docs

Aiven for PostgreSQL

Aiven provides managed PostgreSQL with multi-cloud support and advanced monitoring.

Connection

Use the Service URI from the Aiven Console overview page. SSL is required.

Setup

# Connection string from Aiven Console
migrationpilot analyze migration.sql \
  --database-url "postgresql://avnadmin:pass@pg-abc-project.aivencloud.com:12345/defaultdb?sslmode=require"

Tips

  • Aiven supports PostgreSQL 13-17 across AWS, GCP, and Azure
  • Use Aiven's query statistics to identify high-traffic tables
  • Connection pooling is available via PgBouncer — use the direct URI for schema queries
  • Aiven enforces SSL by default — include sslmode=require in your connection string