---
id: pydynamodb
version: "0.8.2"
license: MIT
license_treatment: permissive
maintenance: active
---

# pydynamodb — Python DB API 2.0 (PEP 249) client for Amazon DynamoDB

License: permissive · Maintenance: active · Downloads: 610.9K/mo

## What it is and what it does

PyDynamoDB bridges Python's DB API 2.0 standard (PEP 249) to Amazon DynamoDB, letting you query and manipulate DynamoDB tables using SQL-like syntax instead of the native DynamoDB API. It implements PartiQL for DML operations (SELECT, INSERT, UPDATE, DELETE) and extends support to DDL operations (CREATE TABLE, ALTER TABLE, DROP TABLE) with MySQL-like syntax, plus utility commands like SHOW TABLES and DESC TABLE.

The package handles automatic type conversion between Python built-in types and DynamoDB's type system, including dates and datetimes, and provides both standard cursor iteration and dict-based result sets for JSON conversion. It includes transaction and batch operation support, and offers a SQLAlchemy dialect for use with ORMs and tools like Superset. Runtime dependencies are boto3 and botocore for AWS communication, tenacity for retry logic, and pyparsing for query parsing.

Use it for:

- Query DynamoDB tables using standard SQL SELECT syntax without learning the native DynamoDB API.
- Build ETL pipelines that read from and write to DynamoDB using familiar DB API 2.0 cursor patterns.
- Integrate DynamoDB with SQLAlchemy-based applications or Superset dashboards via the provided dialect.
- Perform batch inserts and updates with automatic parameter serialization and type conversion.
- Create or alter DynamoDB table schemas using MySQL-like DDL statements from Python code.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

PyDynamoDB is a DB API 2.0 client for Amazon DynamoDB that executes SQL-like queries (PartiQL for DML, MySQL-like syntax for DDL) against DynamoDB tables and provides a SQLAlchemy dialect.

Yes. PyDynamoDB is actively maintained, has no known vulnerabilities, carries a permissive MIT license, and offers low install friction. It is worth installing if you need to query DynamoDB via standard SQL syntax or integrate DynamoDB with DB API 2.0–aware tools like SQLAlchemy. The production-stable classifier and recent activity support reliability for production use.

## Install

pip install pydynamodb
uv add pydynamodb
poetry add pydynamodb

## Installing pydynamodb

Before you install: Low install friction with a pure-Python wheel and four stable runtime dependencies (boto3, botocore, tenacity, pyparsing). Actively maintained with a recent commit on 2026-04-12 and production-stable status.

License in practice: MIT license is permissive; you can use, modify, and distribute this package with minimal restrictions, provided you include the license notice.

Quickstart:

from pydynamodb import connect

cursor = connect(aws_access_key_id="key",
                aws_secret_access_key="secret",
                region_name="us-east-1").cursor()
cursor.execute('SELECT * FROM "table_name"')
print(cursor.fetchall())

AWS credentials (access key ID and secret access key) and a valid DynamoDB table must be accessible in the specified region.

Verify before relying:

- Performance characteristics and query latency for large result sets or complex PartiQL operations.
- Extent of transaction support beyond basic begin() and commit() operations.
- Compatibility scope with Superset SQL Lab and graphing features.

## Package facts

- License: MIT (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 610.9K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

dynamodb sql client, db api 2.0 dynamodb, pydynamodb query, dynamodb python driver, sqlalchemy dynamodb dialect, dynamodb cursor interface, partiql python client, dynamodb, sql-interface, aws

[View on SkillFed](https://skillfed.io/packages/pydynamodb) · [View on PyPI](https://pypi.org/project/pydynamodb/)