apache-airflow-providers-sqlite

What it is and what it does

This is an Apache Airflow provider package that adds SQLite database support to Airflow workflows. It enables users to define tasks that execute SQL queries against SQLite databases and manage SQLite connections within the Airflow DAG framework. The package is built on top of apache-airflow-providers-common-sql, which provides the shared SQL execution infrastructure.

As a provider package, it integrates with Airflow's plugin system to expose SQLite operators, hooks, and connection types. It is maintained as part of the Apache Airflow project and supports current Python versions (3.10 through 3.14). Installation is straightforward via pip on top of an existing Airflow installation meeting the minimum version requirement.

Use it for:

• Execute SQL queries on SQLite databases as part of scheduled Airflow DAGs.
• Manage SQLite connections and credentials through Airflow's connection UI.
• Build data pipelines that read from or write to SQLite tables.
• Integrate SQLite data operations with other Airflow provider tasks in a single workflow.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Integrates SQLite databases with Apache Airflow as a provider package, enabling SQLite connection management and SQL task execution within Airflow workflows.

Yes, if you run Apache Airflow and need to orchestrate SQLite database tasks. The package is actively maintained, has no known vulnerabilities, installs with low friction, and is part of the official Airflow ecosystem. Install only if you have an existing Airflow deployment meeting version >=2.11.0.

Install

apache-airflow-providers-sqlite on PyPI

pip install apache-airflow-providers-sqlite

uv add apache-airflow-providers-sqlite

poetry add apache-airflow-providers-sqlite

Installing apache-airflow-providers-sqlite

Before you install

Low install friction with a pure-Python wheel. Active maintenance with recent release (68 days ago) and a large upstream repository. Requires apache-airflow >=2.11.0 and apache-airflow-providers-common-sql >=1.32.0.

License in practice

Apache-2.0 permissive license allows commercial and private use with minimal restrictions; standard for Apache Airflow ecosystem packages.

Quickstart

pip install apache-airflow-providers-sqlite

from airflow.providers.sqlite.operators.sqlite import SqliteOperator

task = SqliteOperator(
    task_id='query_sqlite',
    sql='SELECT * FROM table',
    sqlite_conn_id='sqlite_default'
)

Requires apache-airflow >=2.11.0 and Python >=3.10; SQLite database file or connection must be configured in Airflow.

Verify before relying

• Whether this package includes hooks, sensors, or transfer operators beyond basic SQL execution.
• Support for SQLite-specific features like connection pooling or transaction management.

Package facts

Evidence: apache_airflow_providers_sqlite-4.3.3-py3-none-any.whl

Keywords: airflow-provider, sqlite, airflow, integration

Tags

More Monitoring packages