apache-airflow-providers-odbc
Provider package apache-airflow-providers-odbc for Apache Airflow
Decision gist · record as of 2026-08-14
Yes. This is a stable, actively maintained provider package for a common use case—ODBC database integration in Airflow. Install friction is low, the license is permissive, there are no known vulnerabilities, and it supports current Python versions. Install it if you need to orchestrate ODBC database tasks in Airflow; skip it if you don't use Airflow or don't need ODBC connectivity.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 system ODBC driver configured for your target database.
- Low friction installation as a pure Python wheel.
- Actively maintained with recent releases; requires Apache Airflow 2.11.0 or later and pyodbc 5.0.0+ (5.2.0+ for Python 3.13+).
License · maintenance · safety
Apache-2.0 (permissive) — Apache License 2.0 (permissive) — you can use, modify, and distribute this package freely in commercial and private projects with minimal restrictions.
last release 2026-06-07 (68 days) · last repo commit 2026-08-14 · 46,490 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 1,982,575 downloads/mo, #3,386 on PyPI
Alternatives
Verify before relying
pip install apache-airflow-providers-odbc
from airflow.providers.odbc.operators.odbc import ODBCOperator
task = ODBCOperator(
task_id='query_odbc_db',
sql='SELECT * FROM table',
odbc_conn_id='my_odbc_connection'
)- Which specific ODBC-compatible databases are officially tested or recommended.
- Whether the package includes connection pooling or retry logic beyond pyodbc's native capabilities.
- Performance characteristics for large result sets or long-running queries.
What it is and what it does
This is an Apache Airflow provider package that adds ODBC database support to Airflow workflows. It wraps pyodbc to deliver operators and hooks that let you define Airflow tasks that execute SQL queries against any ODBC-compatible database—SQL Server, PostgreSQL via ODBC, MySQL, and others—on a schedule or as part of a larger DAG. The package integrates with Airflow's connection management and common SQL provider framework, so you configure your ODBC connection once in Airflow and reference it by name in your tasks.
Installation is straightforward: it's a pure Python wheel with low friction, depending only on Apache Airflow, two common Airflow provider packages, and pyodbc itself. The package is actively maintained, supports Python 3.10 through 3.14, and carries no known security vulnerabilities. It's aimed at data engineers and system administrators building scheduled data pipelines that need to read from or write to ODBC databases.
Use it for
- Schedule daily SQL queries against a corporate SQL Server database and load results into a data warehouse.
- Build a multi-step ETL pipeline where one task extracts data via ODBC and passes it to downstream transformation tasks.
- Monitor database health by running periodic ODBC queries and alerting on anomalies.
- Synchronize data between an ODBC source and a cloud data lake on a fixed schedule.
- Integrate legacy database systems (accessible only via ODBC) into modern Airflow-based data workflows.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
This is a stable, actively maintained provider package for a common use case—ODBC database integration in Airflow. Install friction is low, the license is permissive, there are no known vulnerabilities, and it supports current Python versions. Install it if you need to orchestrate ODBC database tasks in Airflow; skip it if you don't use Airflow or don't need ODBC connectivity.
Install
apache-airflow-providers-odbc on PyPI
Before you install
Low friction installation as a pure Python wheel. Actively maintained with recent releases; requires Apache Airflow 2.11.0 or later and pyodbc 5.0.0+ (5.2.0+ for Python 3.13+).
Requires an existing Apache Airflow installation (2.11.0+) and a system ODBC driver configured for your target database.
License in practice
Apache License 2.0 (permissive) — you can use, modify, and distribute this package freely in commercial and private projects with minimal restrictions.
Quickstart
pip install apache-airflow-providers-odbc
from airflow.providers.odbc.operators.odbc import ODBCOperator
task = ODBCOperator(
task_id='query_odbc_db',
sql='SELECT * FROM table',
odbc_conn_id='my_odbc_connection'
)Verify before relying
- Which specific ODBC-compatible databases are officially tested or recommended.
- Whether the package includes connection pooling or retry logic beyond pyodbc's native capabilities.
- Performance characteristics for large result sets or long-running queries.
Package facts
| License | Apache-2.0 permissive |
| Python support | Supports the current Python release >=3.10 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 4 packagesapache-airflowapache-airflow-providers-common-compatapache-airflow-providers-common-sqlpyodbc |
| Maintenance | Actively maintained 68 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 1,982,575 / month, #3,386 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_odbc-4.12.3-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 odbc database provider”
- apache-airflow-providers-odbcProvides ODBC database connectivity operators and hooks for Apache…
- apache-airflow-providers-jdbcProvides Apache Airflow integration for executing queries and…
- apache-airflow-providers-common-sqlProvides common SQL operators, hooks, and utilities for Apache…
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-microsoft-mssql · apache-airflow-providers-apache-drill · apache-airflow-providers-ydb · apache-airflow-providers-jdbc · apache-airflow-providers-common-sql · airflow-clickhouse-plugin · apache-airflow-providers-sqlite · apache-airflow-providers-informatica · apache-airflow-providers-mysql · apache-airflow-providers-apache-impala