---
id: sqlalchemy-aurora-data-api
version: "0.5.0"
license: Apache Software License
license_treatment: permissive
maintenance: dormant
---

# sqlalchemy-aurora-data-api — An AWS Aurora Serverless Data API dialect for SQLAlchemy

License: permissive · Maintenance: dormant · Downloads: 98.1K/mo

## 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 above — 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

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

- License: Apache Software License (permissive)
- Python support: unspecified
- Install friction: low
- Maintenance: dormant
- Downloads: 98.1K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

sqlalchemy aurora data api, aws rds data api dialect, serverless database sqlalchemy, aurora http endpoint, lambda database access, stateless database connection, aws rds data api python, aws-lambda, serverless-database, aurora-data-api

[View on SkillFed](https://skillfed.io/packages/sqlalchemy-aurora-data-api) · [View on PyPI](https://pypi.org/project/sqlalchemy-aurora-data-api/)