OMOP Alchemy

OMOP Alchemy provides a canonical, typed, SQLAlchemy-first representation of the OHDSI OMOP Common Data Model (CDM).

It is designed to support fluency for research-ready analytics, validation, and exploration of OMOP data using modern Python tooling, without imposing ETL conventions or execution-time side effects.

Design goals

OMOP Alchemy is intentionally:

Declarative
Defines tables, columns, relationships, and constraints
Typed and inspectable
Models are fully typed and introspectable for validation, tooling, and IDE support.
Backend-agnostic
Layered abstractions for adding in new supported backend behaviours.

Core features

SQLAlchemy ORM models for OMOP CDM tables
Explicit foreign key and relationship definitions
Lightweight mapper versions to provide simple model validation against CDM for use in ETL loops without side-effects or performance hit that can come from relationship instantiation within the runtime
Read-only View classes for safe navigation and analytics that include complex multi-table objects such as conditions with their modifiers, episodes with their events
Domain validation helpers for OMOP concept integrity

from omop_alchemy.cdm.model.vocabulary.concept import ConceptView

concept = session.get(ConceptView, 320128)  # Lung cancer
concept.domain.domain_id                    # "Condition"
concept.vocabulary.vocabulary_id            # "SNOMED"
concept.is_standard                         # True

Status

The core API under cdm/ should be considered stable as of the 1.x release.

The toolkit API is experimental and carries no compatibility guarantees. Feedback and issues are welcome.

Some additional background

This work builds on earlier research and tooling presented at the 2023 OHDSI APAC Symposium

see background paper.

Configuration

OMOP Alchemy reads all database connection and schema settings from oa-configurator. No .env files or ENGINE environment variables are needed.

Run once after installation:

omop-config init
omop-config configure omop_alchemy

See Configuration for full details.

Metadata

Release files for omop-alchemy 1.2.2

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for omop-alchemy 1.2.2
File	Size	Uploaded
omop_alchemy-1.2.2.tar.gz	697.0 kB	Oct 8, 2026	Details

Built distribution (wheel)

Table of built distributions (wheels) for omop-alchemy 1.2.2
File	Interpreter	ABI	Platform	Reset
omop_alchemy-1.2.2-py3-none-any.whl 280.7 kB Oct 8, 2026	Python 3	none	any	Details

Total release size: 977.6 kB

Release files / omop_alchemy-1.2.2.tar.gz

Download URL	omop_alchemy-1.2.2.tar.gz
Size	697.0 kB
Tags	Source
SHA-256 checksum How to use checksums	`c886e8afd9bc1f50a6473b695431e1690a88e63498c98f62ea69174eebbd6466`
BLAKE2b-256 checksum How to use checksums	`23b7d5a374d6907acdbf31a99bd2213b5b18a011bcf3e9a650ab5dab6876d3ac`
Upload date	Oct 8, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/7.0.0 CPython/3.13.14`

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/AustralianCancerDataNetwork/omop-alchemy
Publishing commit: github.com/AustralianCancerDataNetwork/omop-alchemy/tree/13e8c92c73bd079164f51bf456c1c2f789be7fe7

Workflow

Publishing configuration: github.com/AustralianCancerDataNetwork/omop-alchemy/blob/13e8c92c73bd079164f51bf456c1c2f789be7fe7/.github/workflows/publish.yml
Publishing logs: github.com/AustralianCancerDataNetwork/omop-alchemy/actions/runs/37860030290/attempts/1

Artifact

Subject: omop_alchemy-1.2.2.tar.gz
SHA-256 checksum: c886e8afd9bc1f50a6473b695431e1690a88e63498c98f62ea69174eebbd6466 Verifying attestations

Release files / omop_alchemy-1.2.2-py3-none-any.whl

Download URL	omop_alchemy-1.2.2-py3-none-any.whl
Size	280.7 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`3a67a3b4ca99ce7aa4af201f4df851db4d4a23542658cfc2beb0f846743d20a6`
BLAKE2b-256 checksum How to use checksums	`5b16d9cf8c1fa1a27372fefd1d962acf5282d3542c18a8624a0594762c32f310`
Upload date	Oct 8, 2026
Uploaded using Trusted Publishing? What is trusted publishing?	Yes
Uploaded via	`twine/7.0.0 CPython/3.13.14`

Provenance

Identity

Publishing platform: GitHub Actions
Publishing repository: github.com/AustralianCancerDataNetwork/omop-alchemy
Publishing commit: github.com/AustralianCancerDataNetwork/omop-alchemy/tree/13e8c92c73bd079164f51bf456c1c2f789be7fe7

Workflow

Publishing configuration: github.com/AustralianCancerDataNetwork/omop-alchemy/blob/13e8c92c73bd079164f51bf456c1c2f789be7fe7/.github/workflows/publish.yml
Publishing logs: github.com/AustralianCancerDataNetwork/omop-alchemy/actions/runs/37860030290/attempts/1

Artifact

Subject: omop_alchemy-1.2.2-py3-none-any.whl
SHA-256 checksum: 3a67a3b4ca99ce7aa4af201f4df851db4d4a23542658cfc2beb0f846743d20a6 Verifying attestations