Database Dumps

Browse, query and download daily snapshots of the Deadlock API database. Files are provided as Parquet (data) and SQL (schema) for offline analysis, research, or community projects.

Bucket URLhttps://s3-cache.deadlock-api.com/db-snapshot/
# pip install duckdb
import duckdb

DUCKLAKE_URL = "ducklake:https://s3-cache.deadlock-api.com/db-snapshot/public/db_snapshot.ducklake"

with duckdb.connect() as con:
    con.execute("""
        INSTALL ducklake; LOAD ducklake;
        INSTALL httpfs; LOAD httpfs;
        CREATE OR REPLACE SECRET deadlock_s3 (
            TYPE S3, KEY_ID '', SECRET '',
            ENDPOINT 's3-cache.deadlock-api.com', URL_STYLE 'path', USE_SSL true
        );
    """)
    con.execute(f"ATTACH '{DUCKLAKE_URL}' AS db (READ_ONLY)")
    con.execute("USE db.main")

    # Tables are now queryable directly:
    con.sql("SHOW TABLES").show()
    con.sql("SELECT count(*) FROM heroes").show()
NameSizeLast ModifiedActions