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.1

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.1
File	Size	Uploaded
omop_alchemy-1.2.1.tar.gz	694.5 kB	Oct 6, 2026	Details

Built distribution (wheel)

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

Total release size: 974.3 kB

Release files / omop_alchemy-1.2.1.tar.gz

Download URL	omop_alchemy-1.2.1.tar.gz
Size	694.5 kB
Tags	Source
SHA-256 checksum How to use checksums	`b79c0a5c845ef1bd7530171718f7a7fed7336e7f585488016af2fa4ffb17327f`
BLAKE2b-256 checksum How to use checksums	`879460f7843da2ba55c3d3b6adc6be79c55a69d271e8baa3509f8c89033cf569`
Upload date	Oct 6, 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/77253d28ea72ba0b170fd20b9a027a76b9af545e

Workflow

Publishing configuration: github.com/AustralianCancerDataNetwork/omop-alchemy/blob/77253d28ea72ba0b170fd20b9a027a76b9af545e/.github/workflows/publish.yml
Publishing logs: github.com/AustralianCancerDataNetwork/omop-alchemy/actions/runs/37426857024/attempts/1

Artifact

Subject: omop_alchemy-1.2.1.tar.gz
SHA-256 checksum: b79c0a5c845ef1bd7530171718f7a7fed7336e7f585488016af2fa4ffb17327f Verifying attestations

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

Download URL	omop_alchemy-1.2.1-py3-none-any.whl
Size	279.8 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`25e6831979fe96c18fe3a76daa26561ac2de32e64c8ac16931b7af110cc882cf`
BLAKE2b-256 checksum How to use checksums	`3526b1d08996d96baf25af14c06d89c9738d634ba31272a3b58f9c3455076d06`
Upload date	Oct 6, 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/77253d28ea72ba0b170fd20b9a027a76b9af545e

Workflow

Publishing configuration: github.com/AustralianCancerDataNetwork/omop-alchemy/blob/77253d28ea72ba0b170fd20b9a027a76b9af545e/.github/workflows/publish.yml
Publishing logs: github.com/AustralianCancerDataNetwork/omop-alchemy/actions/runs/37426857024/attempts/1

Artifact

Subject: omop_alchemy-1.2.1-py3-none-any.whl
SHA-256 checksum: 25e6831979fe96c18fe3a76daa26561ac2de32e64c8ac16931b7af110cc882cf Verifying attestations