Aurora MySQL (Data API)

https://aws.amazon.com/rds/aurora/

Amazon Aurora MySQL 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.

Tracking issue

Last confirmed: 2026-07-28

Installation

Required packages: mysqlclientsqlalchemy-aurora-data-api

Drivers

mysqlclientRecommended

mysql-connector-python

PyPI Package: mysqlclient

mysql://{username}:{password}@{host}/{database}

Recommended driver. May fail with caching_sha2_password auth.

Supported Features

JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation

Feature Score: 59/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

Resources

Official Documentation

Help improve this documentation by editing the engine spec:

Edit aurora.py