Amazon Aurora PostgreSQL via the Data API for serverless connectivity.
Known Incompatibilities
SQLAlchemy 2.0
Neither our fork (preset-io/sqlalchemy-aurora-data-api, dormant since 2021) nor the more active community fork (cloud-utils/sqlalchemy-aurora-data-api) has resolved SQLAlchemy 2.0 compatibility.
Last confirmed: 2026-07-28
Installation
Required packages: psycopg2sqlalchemy-aurora-data-api
Connection String
postgresql+auroradataapi://{aws_access_id}:{aws_secret_access_key}@/{database_name}?aurora_cluster_arn={aurora_cluster_arn}&secret_arn={secret_arn}®ion_name={region_name}| Parameter | Description |
|---|---|
| username | Database username |
| password | Database password |
| host | For localhost: localhost or 127.0.0.1. For AWS: endpoint URL |
| port | Default 5432 |
| database | Database name |
| aws_access_id | AWS Access Key ID |
| aws_secret_access_key | AWS Secret Access Key |
| database_name | Database name |
| aurora_cluster_arn | Aurora cluster ARN |
| secret_arn | Secrets Manager ARN for credentials |
| region_name | AWS region (e.g., us-east-1) |
Connection Examples
Basic connection
postgresql://{username}:{password}@{host}:{port}/{database}With SSL required
postgresql://{username}:{password}@{host}:{port}/{database}?sslmode=requireSupported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Feature Score: 104/201
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Extended Time Grains:
FIVE_SECONDSTHIRTY_SECONDSFIVE_MINUTESTEN_MINUTESFIFTEEN_MINUTESTHIRTY_MINUTESHALF_HOURSIX_HOURSWEEK_STARTING_SUNDAYWEEK_STARTING_MONDAYWEEK_ENDING_SATURDAYWEEK_ENDING_SUNDAYQUARTER_YEAR
Notes
The psycopg2 library comes bundled with Superset Docker images.