---
id: apache-airflow-providers-postgres
version: "7.0.1"
license: Apache-2.0
license_treatment: permissive
maintenance: active
---

# apache-airflow-providers-postgres — Provider package apache-airflow-providers-postgres for Apache Airflow

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

## What it is and what it does

This is an Apache Airflow provider package that adds PostgreSQL connectivity to Airflow DAGs. It supplies operators, hooks, and sensors that let you define and orchestrate PostgreSQL tasks—queries, stored procedures, data transfers—as part of Airflow workflows. The package wraps multiple PostgreSQL client libraries (psycopg, psycopg2-binary, and asyncpg) to support both synchronous and asynchronous database operations.

It is designed for teams running Airflow who need to integrate PostgreSQL into their data pipelines. Installation is straightforward on top of an existing Airflow setup (>=2.11.0), and it supports Python 3.10 through 3.14. The package is actively maintained as part of the Apache Airflow ecosystem and carries no known security vulnerabilities.

Use it for:

- Execute SQL queries or stored procedures on PostgreSQL as scheduled Airflow tasks within a DAG.
- Monitor PostgreSQL tables for data changes and trigger downstream tasks using Airflow sensors.
- Transfer data between PostgreSQL and other systems (S3, Azure, etc.) using cross-provider integrations.
- Build ETL pipelines that extract, transform, and load data into PostgreSQL as part of Airflow orchestration.
- Integrate PostgreSQL with OpenLineage for data lineage tracking in Airflow workflows.

## Worth the install?

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

Integrates PostgreSQL databases with Apache Airflow, providing operators, hooks, and sensors to orchestrate database tasks and queries within Airflow workflows.

Yes. This is a production-stable, actively maintained provider for a common use case (PostgreSQL + Airflow). Install friction is low, licensing is permissive, no vulnerabilities are known, and it integrates cleanly with Airflow's ecosystem. Install it if you are running Airflow and need to orchestrate PostgreSQL tasks.

## Install

pip install apache-airflow-providers-postgres
uv add apache-airflow-providers-postgres
poetry add apache-airflow-providers-postgres

## Installing apache-airflow-providers-postgres

Before you install: Low friction install as a pure-Python wheel. Active maintenance with a release 6 days old; the parent Airflow project has 46490 stars and receives regular commits. Requires Airflow >=2.11.0 and modern Python (3.10–3.14).

License in practice: Licensed under Apache-2.0 (permissive), allowing use in commercial and proprietary projects with minimal restrictions.

Quickstart:

pip install apache-airflow-providers-postgres

from airflow.providers.postgres.operators.postgres import PostgresOperator
from airflow import DAG

with DAG('my_dag') as dag:
    task = PostgresOperator(
        task_id='run_query',
        postgres_conn_id='my_postgres',
        sql='SELECT * FROM my_table'
    )

Requires an existing Apache Airflow installation (>=2.11.0) and a configured PostgreSQL connection in Airflow.

Verify before relying:

- Whether asyncpg support is used by default or requires explicit opt-in via extras.
- Specific operators, sensors, and hooks available beyond basic query execution.
- Support for advanced features like connection pooling or transaction management.

## Package facts

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

## Tags

airflow postgres integration, postgresql airflow provider, airflow database tasks, postgres operators airflow, airflow sql orchestration, postgresql dag tasks, airflow postgres hooks, airflow-provider, postgres-integration, data-orchestration

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