sqlalchemy-aurora-data-api

What it is and what it does

This package registers two SQLAlchemy dialects—`mysql+auroradataapi://` and `postgresql+auroradataapi://`—that translate SQLAlchemy operations into HTTP calls to the AWS Aurora Data API. It depends on sqlalchemy and aurora-data-api, the underlying DB-API 2.0 client.

The package solves a specific problem for AWS Lambda and other serverless environments: traditional database drivers maintain stateful TCP connection pools that break across Lambda freeze-thaw cycles, while the Data API uses stateless HTTP tunneling. It eliminates the need to open database ports to Lambda's IP pool and enables role-based authentication via AWS IAM, removing the need for Lambda code to handle credentials directly.

Use it for:

• Run database queries from AWS Lambda functions without managing TCP connection pools or handling database credentials in code.
• Access PostgreSQL or MySQL databases from serverless applications that cannot maintain persistent connections.
• Integrate SQLAlchemy ORM or Core with Aurora Serverless via HTTP without custom connection management.
• Deploy applications on ECS/EKS containers or EC2 instances that need stateless database access via the Data API.
• Avoid opening database ports to AWS Lambda's public IP address pool by tunneling SQL over HTTPS.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Provides a SQLAlchemy dialect for accessing PostgreSQL and MySQL databases via AWS Aurora Serverless Data API, enabling HTTP-based database access without managing TCP connections.

Yes, if you are building on AWS Lambda or another serverless platform with Aurora Serverless and need SQLAlchemy integration. The package has low install friction and no known vulnerabilities. However, dormant maintenance (last release 958 days ago) means you should verify compatibility with your SQLAlchemy version and test thoroughly before production use, especially if you rely on recent SQLAlchemy features.

Install

sqlalchemy-aurora-data-api on PyPI

pip install sqlalchemy-aurora-data-api

uv add sqlalchemy-aurora-data-api

poetry add sqlalchemy-aurora-data-api

Installing sqlalchemy-aurora-data-api

Before you install

Low install friction with two straightforward runtime dependencies. Maintenance is dormant—last release was 958 days ago—but the repository remains active and the package supports modern Python versions through 3.12.

License in practice

Licensed under Apache License 2.0 (permissive), allowing commercial and private use with minimal restrictions beyond attribution and liability disclaimers.

Quickstart

from sqlalchemy import create_engine

engine = create_engine(
    'postgresql+auroradataapi://:@/my_db_name',
    connect_args=dict(
        aurora_cluster_arn='arn:aws:rds:...',
        secret_arn='arn:aws:secretsmanager:...'
    )
)

with engine.connect() as conn:
    for row in conn.execute('SELECT * FROM pg_catalog.pg_tables'):
        print(row)

Requires an AWS Aurora Serverless cluster with Data API enabled, database credentials stored in AWS Secrets Manager, and AWS credentials configured locally or via IAM role.

Verify before relying

• Current compatibility with the latest SQLAlchemy versions (fact sheet does not specify SQLAlchemy version constraints).
• Performance characteristics and latency overhead of HTTP-based queries compared to native TCP connections.
• Whether dormant maintenance status indicates the package is stable or at risk of incompatibility with future AWS API changes.

Package facts

Evidence: sqlalchemy_aurora_data_api-0.5.0-py3-none-any.whl

Tags

More Python Modules packages