pydynamodb

PyDynamoDB

PyDynamoDB is a Python DB API 2.0 (PEP 249) client for Amazon DynamoDB. SQLAlchemy dialect supported as well.

Objectives

PyDynamoDB implement the DB API 2.0 interfaces based on PartiQL supported by AWS DynamoDB. Although PartiQL can only support DML operations (INSERT, UPDATE, DELETE, SELECT), PyDynamoDB extended the capabilities to support DDL as well. Now you are able to use MySQL-like statements to CREATE/ALTER/DROP tables. Besides DDL statements, some of utility statements are allowed to execute (Such as, List and Describe Table). PyDynamodb provide parameters and result_set converter to make you easily manipulate operations with Python built-in types. Transaction is also partially supported with DB standard operations, like begin() and commit().

Features

Compatible with DB API 2.0 Specification
PartiQL for DML operations (INSERT, UPDATE, DELETE, SELECT)
Limit supported in SELECT statement
Extra type conversion and string functions supported in SELECT statement
Column alias supported in SELECT statement
MySQL-Like statements for DDL operations (CREATE TABLE, ALTER TABLE, DROP TABLE)
MySQL-Like statements for Utility operations (LIST/SHOW TABLES, DESC TABLE)
Auto data type conversion for parameters and result set (Including date and datetime)
Transaction and Batch operations
SQLAlchemy dialect provided
Compatible for Superset SQL Lab and graphing

Requirements

Python
- CPython 3.8 3.9 3.10 3.11 3.12

Dependencies

Boto3 (Python SDK for AWS Services)
- boto3 >= 1.21.0
- botocore >= 1.24.7
Tenacity (Retry Utility for API calling)
- tenacity >= 4.1.0
SQLAlchemy (The ORM Toolkit for Python, only required if using PyDynamoDB Dialect)
- SQLAlchemy >= 1.0.0
Pyparsing (The approach to creating and executing simple grammars)
- pyparsing >= 3.0.0

Installation

pip install pydynamodb

Guidances

To get more documentation, please visit: PyDynamoDB WIKI.

Basic usage

from pydynamodb import connect

cursor = connect(aws_access_key_id="aws_access_key_id",
                aws_secret_access_key="aws_secret_access_key",
                region_name="region_name").cursor()
cursor.execute('SELECT * FROM "ddb_table_name"')
print(cursor.fetchall())

Cursor iteration

from pydynamodb import connect

cursor = connect(aws_access_key_id="aws_access_key_id",
                aws_secret_access_key="aws_secret_access_key",
                region_name="region_name").cursor()
cursor.execute('SELECT * FROM "ddb_table_name"')
rows = cursor.fetchall()
for row in rows:
    print(row)

Query with parameters

PyDynamoDB is able to serialize the parameters which passed to DDB and deserialize the response to Python built-in types.

from pydynamodb import connect
from datetime import date, datetime
cursor = connect(aws_access_key_id="aws_access_key_id",
                aws_secret_access_key="aws_secret_access_key",
                region_name="region_name").cursor()
cursor.execute("""INSERT INTO "ddb_table_name" VALUE {
                    'partition_key' = ?, 'sort_key' = ?, 'col_str' = ?,
                    'col_num' = ?, 'col_byte' = ?, 'col_ss' = ?,
                    'col_ns' = ?, 'col_bs' = ?, 'col_list' = ?,
                    'col_map' = ?, 'col_nested' = ?,
                    'col_date' = ?, 'col_datetime' = ?
                }""", ["pkey_value", "skey_value", "str", 100, b"ABC", # String, Number, Bytes
                        {"str", "str"}, {100, 100}, {b"A", b"B"}, # String/Numnber/Bytes Set
                        ["str", 100, b"ABC"],  # List
                        {"key1": "val", "key2": "val"}, # Map
                        ["str", 100, {"key1": "val"}], # Nested Structure
                        date(2022, 10, 18), datetime(2022, 10, 18, 13, 55, 34), # Date and Datetime Type
                    ])

cursor.execute('SELECT * FROM "ddb_table_name" WHERE partition_key = ?', ["key_value"])
print(cursor.fetchall())

License

PyDynamoDB is distributed under the MIT license.

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pydynamodb-0.7.4.tar.gz (47.4 kB view details)

Uploaded Oct 1, 2025 Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

The dropdown lists show the available interpreters, ABIs, and platforms. Enable javascript to be able to filter the list of wheel files.

pydynamodb-0.7.4-py3-none-any.whl (60.9 kB view details)

Uploaded Oct 1, 2025 Python 3

File details

Details for the file pydynamodb-0.7.4.tar.gz.

File metadata

Download URL: pydynamodb-0.7.4.tar.gz
Upload date: Oct 1, 2025
Size: 47.4 kB
Tags: Source
Uploaded using Trusted Publishing? No
Uploaded via: twine/6.2.0 CPython/3.9.23

File hashes

Hashes for pydynamodb-0.7.4.tar.gz
Algorithm	Hash digest
SHA256	`b515bc7321e930a61f440694b78c02cc5490da0c854224862418cf292eb85bc1`
MD5	`66bb216aa5ad2c2d07237fa5d8f10084`
BLAKE2b-256	`291ee00250230f7c7ff34e63fe1f19b1f402379d7a2a6ec11fb658b18beda868`

See more details on using hashes here.

File details

Details for the file pydynamodb-0.7.4-py3-none-any.whl.

File metadata

Download URL: pydynamodb-0.7.4-py3-none-any.whl
Upload date: Oct 1, 2025
Size: 60.9 kB
Tags: Python 3
Uploaded using Trusted Publishing? No
Uploaded via: twine/6.2.0 CPython/3.9.23

File hashes

Hashes for pydynamodb-0.7.4-py3-none-any.whl
Algorithm	Hash digest
SHA256	`f27a725506677754462aa03129e23ffad8e0e1fdf3ca876c95c5fa608750fba5`
MD5	`e7cb122c5c603ff8266cc65a84de7dbe`
BLAKE2b-256	`9affc464f21cf95a37a280c48a4edf20767fc42498fbca616327bed8edac71b9`