apache-airflow-providers-common-sql
Provider package apache-airflow-providers-common-sql for Apache Airflow
Decision gist · record as of 2026-08-14
Yes—if you are running Apache Airflow and need to execute SQL queries or build SQL-based workflows. This is a foundational provider package actively maintained by Apache, with no security issues, low install friction, and permissive licensing. Install it only if you have Airflow >=2.11.0 already in place; it is not useful standalone.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires Apache Airflow >=2.11.0 and Python >=3.10 to be installed first; designed as a provider extension, not a standalone tool.
- Low friction installation as a pure Python wheel.
- Actively maintained with a recent release (6 days old) and backed by the Apache Airflow project's active repository.
License · maintenance · safety
Apache-2.0 (permissive) — Licensed under Apache License 2.0 (permissive), allowing commercial use, modification, and distribution with minimal restrictions—standard for Apache Foundation projects.
last release 2026-08-08 (6 days) · last repo commit 2026-08-14 · 46,475 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 45,861,310 downloads/mo, #613 on PyPI
Alternatives
Verify before relying
pip install apache-airflow-providers-common-sql
from airflow.providers.common.sql.operators.sql import SQLExecuteQueryOperator
task = SQLExecuteQueryOperator(
task_id='run_query',
sql='SELECT * FROM table',
conn_id='my_database'
)- Specific SQL dialects or database systems supported beyond the generic SQL abstraction layer.
- Whether the package includes pre-built operators for specific databases or only common utilities.
- Performance characteristics or limitations when handling large result sets or complex queries.
What it is and what it does
This is a provider package for Apache Airflow that supplies reusable SQL operators, hooks, and helper functions for common SQL workflow patterns. It sits between Airflow's core and database-specific providers (like Amazon Redshift or Apache Iceberg), offering shared SQL parsing, connection management, and query execution logic that multiple database providers can build on. The package depends on sqlparse for SQL statement parsing, more-itertools for utility functions, and methodtools for caching, and integrates with Airflow's provider ecosystem to enable SQL-based data pipeline tasks.
You install it on top of an existing Airflow installation to unlock SQL-centric operators and utilities in the airflow.providers.common.sql namespace. It is actively maintained by the Apache Airflow project, supports Python 3.10 through 3.14, and can be extended with optional dependencies (pandas, polars, sqlalchemy, datafusion) to support specialized data formats and database systems. No known vulnerabilities are recorded.
Use it for
- Execute parameterized SQL queries within Airflow DAGs without writing database-specific operator code.
- Share SQL connection and query execution logic across multiple database provider integrations.
- Parse and validate SQL statements before execution in a workflow context.
- Build custom SQL-based operators that inherit common connection and error-handling patterns.
- Integrate with optional data tools (pandas, polars, sqlalchemy) for result transformation in SQL tasks.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes—if you are running Apache Airflow and need to execute SQL queries or build SQL-based workflows.
This is a foundational provider package actively maintained by Apache, with no security issues, low install friction, and permissive licensing. Install it only if you have Airflow >=2.11.0 already in place; it is not useful standalone.
Install
apache-airflow-providers-common-sql on PyPI
Before you install
Low friction installation as a pure Python wheel. Actively maintained with a recent release (6 days old) and backed by the Apache Airflow project's active repository. Requires Apache Airflow >=2.11.0 and modern Python (3.10+).
Requires Apache Airflow >=2.11.0 and Python >=3.10 to be installed first; designed as a provider extension, not a standalone tool.
License in practice
Licensed under Apache License 2.0 (permissive), allowing commercial use, modification, and distribution with minimal restrictions—standard for Apache Foundation projects.
Quickstart
pip install apache-airflow-providers-common-sql
from airflow.providers.common.sql.operators.sql import SQLExecuteQueryOperator
task = SQLExecuteQueryOperator(
task_id='run_query',
sql='SELECT * FROM table',
conn_id='my_database'
)Verify before relying
- Specific SQL dialects or database systems supported beyond the generic SQL abstraction layer.
- Whether the package includes pre-built operators for specific databases or only common utilities.
- Performance characteristics or limitations when handling large result sets or complex 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 | 5 packagesapache-airflowapache-airflow-providers-common-compatsqlparsemore-itertoolsmethodtools |
| Maintenance | Actively maintained 6 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 45,861,310 / month, #613 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_common_sql-2.1.0-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 sql provider”
- apache-airflow-providers-common-sqlProvides common SQL operators, hooks, and utilities for Apache…
- apache-airflow-providers-sqliteIntegrates SQLite databases with Apache Airflow as a provider…
- apache-airflow-providers-exasolIntegrates Exasol database with Apache Airflow, providing operators…
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 airflow-clickhouse-plugin · apache-airflow-providers-apache-drill · apache-airflow-providers-microsoft-mssql · apache-airflow-providers-mysql · apache-airflow-providers-postgres · apache-airflow-providers-oracle · apache-airflow-providers-jdbc · apache-airflow-providers-teradata · apache-airflow-providers-exasol · apache-airflow-providers-odbc