apache-airflow-providers-postgres

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 on this page — 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

apache-airflow-providers-postgres on PyPI

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

Evidence: apache_airflow_providers_postgres-7.0.1-py3-none-any.whl

Keywords: airflow-provider, postgres, airflow, integration

Tags

More Monitoring packages