---
id: dagster-postgres
version: "0.29.17"
license: Apache-2.0
license_treatment: permissive
maintenance: active
---

# dagster-postgres — A Dagster integration for postgres

License: permissive · Maintenance: active · Downloads: 11.7M/mo

## What it is and what it does

dagster-postgres is an integration layer that allows Dagster—a cloud-native data pipeline orchestrator—to use PostgreSQL as its backing database for storing asset definitions, run history, event logs, and execution state. Rather than using Dagster's default in-memory or SQLite storage, this package lets you connect to a production PostgreSQL instance, making it suitable for multi-user environments, persistent storage across restarts, and integration with existing database infrastructure.

The package depends on dagster (the core orchestration framework) and psycopg2-binary (the PostgreSQL driver). It's designed for teams running Dagster in production who need reliable, scalable state management backed by a dedicated relational database. Installation is straightforward with low friction, and the package is actively maintained with no known security vulnerabilities.

Use it for:

- Store Dagster run history and asset lineage in a shared PostgreSQL database for multi-user team environments
- Persist pipeline state across application restarts without losing execution history or asset metadata
- Integrate Dagster with existing PostgreSQL infrastructure and monitoring tools already in place
- Enable audit trails and compliance reporting by centralizing all orchestration events in a queryable database
- Scale Dagster deployments beyond single-machine limits by offloading state to a dedicated database server

## Worth the install?

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

Connects Dagster data pipelines to PostgreSQL for asset storage, state management, and run tracking.

Yes, if you are already using Dagster and need persistent, production-grade state storage. The low install friction, active maintenance, permissive license, and zero known vulnerabilities make it a safe choice. Install only if you have a PostgreSQL instance available and require multi-user or persistent storage; Dagster's default storage is sufficient for local development.

## Install

pip install dagster-postgres
uv add dagster-postgres
poetry add dagster-postgres

## Installing dagster-postgres

Before you install: Low friction install with two runtime dependencies (dagster and psycopg2-binary). The package is actively maintained with a recent release and no known vulnerabilities.

License in practice: Apache 2.0 licensed, permissive terms allow commercial and private use with minimal restrictions.

Quickstart:

pip install dagster-postgres

import dagster_postgres
from dagster import Definitions

# Configure PostgreSQL as Dagster's backend in your definitions
# See Dagster docs for storage configuration details

Requires Python 3.10 or later (up to 3.14). PostgreSQL server must be accessible and configured separately.

Verify before relying:

- Specific PostgreSQL version compatibility requirements
- Whether this package handles schema migrations automatically or requires manual setup
- Performance characteristics for large-scale asset graphs or high-frequency runs

## Package facts

- License: Apache-2.0 (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 11.7M/month (top 5,000 on PyPI)
- Known vulnerabilities: none known

## Tags

dagster postgres integration, postgresql data pipeline storage, dagster database backend, postgres asset storage, dagster run state persistence, postgresql orchestration storage, data-orchestration, postgres-integration, state-management

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