sqlalchemy-aurora-data-api
An AWS Aurora Serverless Data API dialect for SQLAlchemy
Decision gist · record as of 2026-08-14
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.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- 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.
- 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 · maintenance · safety
Apache Software License (permissive) — Licensed under Apache License 2.0 (permissive), allowing commercial and private use with minimal restrictions beyond attribution and liability disclaimers.
last release 2023-12-30 (958 days) · last repo commit 2023-12-30 · 117 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 98,142 downloads/mo, #13,100 on PyPI
Alternatives
Verify before relying
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)- 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.
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 on it.
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
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.
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.
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)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 | Not specified |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 2 packagessqlalchemyaurora-data-api |
| Maintenance | Dormant 958 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 98,142 / month, #13,100 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Intended Audience :: DevelopersLicense :: OSI Approved :: Apache Software LicenseOperating System :: MacOS :: MacOS XOperating System :: POSIXProgramming Language :: PythonProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.8Programming Language :: Python :: 3.9Topic :: Software Development :: Libraries :: Python Modules |
Evidence: sqlalchemy_aurora_data_api-0.5.0-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “sqlalchemy aurora data api”
- sqlalchemy-aurora-data-apiProvides a SQLAlchemy dialect for accessing PostgreSQL and MySQL…
- aurora-data-apiA DB-API 2.0 compatible client for AWS Aurora Serverless that tunnels…
- cdk-aurora-globaldatabaseProvides AWS CDK constructs to deploy Amazon Aurora Global Databases…
Give your agent the search over MCP, or paste the wish link into any chat.
More Python Modules packages
Converts domain names between Unicode and ASCII-compatible encoding (Punycode) according to IDNA 2008 and Unicode Technical Standard 46, with security validation and broader script coverage than the standard library.
Install it if you work with internationalized domain names, need to validate domains, or use HTTP clients that depend on it transitively.
Setuptools is a Python build backend and package management tool that handles building, distributing, and installing Python packages, including support for C/C++ extension modules.
PyYAML parses and emits YAML 1.1 data format, enabling serialization and deserialization of configuration files and Python objects to and from human-readable YAML text.
Pydantic validates Python data structures against type hints, coercing and checking input at runtime to ensure it matches a declared schema.
Provides reusable metadata objects for use with PEP-593 `typing.Annotated` to express common constraints like bounds, collection sizes, and predicates on types.
Install it if you use or build libraries that need to express type constraints in a standardized, inspectable way—or if you want to annotate your own types with…
Provides runtime tools to inspect and introspect Python type annotations, enabling programmatic examination of type hints at execution time.
See also aurora-data-api · sqlalchemy-rdsiam · aws-advanced-python-wrapper · sqlalchemy-jdbcapi · sqlalchemy-firebird · snowflake-sqlalchemy · sqlalchemy-pgspider · iomete-sqlalchemy · databricks-sqlalchemy · sqlalchemy-spanner