apache-airflow-providers-postgres
Provider package apache-airflow-providers-postgres for Apache Airflow
Decision gist · record as of 2026-08-14
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.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires an existing Apache Airflow installation (>=2.11.0) and a configured PostgreSQL connection in Airflow.
- 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.
License · maintenance · safety
Apache-2.0 (permissive) — Licensed under Apache-2.0 (permissive), allowing use in commercial and proprietary projects with minimal restrictions.
last release 2026-08-08 (6 days) · last repo commit 2026-08-14 · 46,490 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 2,461,824 downloads/mo, #3,054 on PyPI
Alternatives
Verify before relying
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'
)- 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.
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 on it.
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
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).
Requires an existing Apache Airflow installation (>=2.11.0) and a configured PostgreSQL connection in Airflow.
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'
)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 the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 6 packagesapache-airflowapache-airflow-providers-common-compatapache-airflow-providers-common-sqlpsycopgpsycopg2-binaryasyncpg |
| Maintenance | Actively maintained 6 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 2,461,824 / month, #3,054 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 5 - Production/StableEnvironment :: ConsoleEnvironment :: Web EnvironmentFramework :: Apache AirflowFramework :: Apache Airflow :: ProviderIntended Audience :: DevelopersIntended Audience :: System AdministratorsProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Topic :: System :: Monitoring |
Evidence: apache_airflow_providers_postgres-7.0.1-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “airflow postgres integration”
- apache-airflow-providers-postgresIntegrates PostgreSQL databases with Apache Airflow, providing…
- apache-airflow-providers-pgvectorIntegrates pgvector operations into Apache Airflow workflows,…
- airflow-clickhouse-pluginProvides Apache Airflow operators and hooks to execute SQL queries…
Give your agent the search over MCP, or paste the wish link into any chat.
More Monitoring packages
Wraps any iterable to display a real-time progress bar in the terminal or Jupyter notebook, showing iteration count, elapsed time, and estimated time remaining.
Provides generated Python code for OpenTelemetry semantic conventions, enabling standardized attribute naming and constant definitions for instrumentation and telemetry collection.
Install it if you are using OpenTelemetry and want to follow semantic conventions correctly.
Provides the reference implementation of the OpenTelemetry API for collecting and exporting traces, metrics, and logs from Python applications.
Provides the abstract API and interfaces for OpenTelemetry instrumentation in Python, defining how to emit traces, metrics, and logs without tying code to a specific SDK implementation.
Exports OpenTelemetry observability data to an OpenTelemetry Collector using Protobuf-encoded messages over HTTP.
Install it if you are using OpenTelemetry in Python and need to send data to a Collector over HTTP.
Provides automatic instrumentation commands and programmatic APIs to inject distributed tracing into Python applications without code changes, detecting and instrumenting packages used by your program.
Install it if you need distributed tracing without code changes and have compatible instrumented packages in your environment.
See also apache-airflow-providers-oracle · apache-airflow-providers-teradata · apache-airflow-providers-common-sql · apache-airflow-providers-snowflake · apache-airflow-providers-mysql · apache-airflow-providers-pgvector · apache-airflow-providers-presto · apache-airflow-providers-microsoft-mssql · apache-airflow-providers-google · apache-airflow-providers-amazon