apache-airflow-providers-mysql

What it is and what it does

This is an Apache Airflow provider package that adds MySQL database integration to Airflow workflows. It supplies operators, hooks, and sensors that let you define, schedule, and monitor MySQL queries and commands as tasks within Airflow DAGs. The package abstracts away connection management and provides a declarative interface for common database operations.

The package depends on Apache Airflow >=2.11.0 and bundles support for multiple MySQL client libraries (mysqlclient, mysql-connector-python, aiomysql, pymysql) to accommodate different deployment environments and use cases. It is actively maintained as part of the Apache Airflow ecosystem and supports Python 3.10 through 3.14.

Use it for:

• Schedule and execute SQL queries on MySQL databases as part of larger data pipelines.
• Monitor MySQL table changes or query results and trigger downstream Airflow tasks based on conditions.
• Orchestrate ETL workflows that extract data from MySQL, transform it, and load it into other systems.
• Run periodic database maintenance tasks (backups, cleanup, schema updates) on a schedule.
• Integrate MySQL operations with other Airflow providers to build multi-system workflows.

Worth the install?

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

Integrates Apache Airflow with MySQL databases, providing operators, hooks, and sensors to query, execute, and monitor MySQL tasks within Airflow workflows.

Yes. This is a production-stable, actively maintained provider from the Apache Airflow project with no known vulnerabilities. Install it if you need to orchestrate MySQL tasks within Airflow. The low install friction and permissive Apache-2.0 license make it a straightforward choice for Airflow users with MySQL databases.

Install

apache-airflow-providers-mysql on PyPI

pip install apache-airflow-providers-mysql

uv add apache-airflow-providers-mysql

poetry add apache-airflow-providers-mysql

Installing apache-airflow-providers-mysql

Before you install

Low install friction with a pure-Python wheel. Requires Apache Airflow >=2.11.0 and several MySQL client libraries (mysqlclient, mysql-connector-python, aiomysql, pymysql). Actively maintained with recent releases; last commit 2026-08-14.

License in practice

Licensed under Apache-2.0 (permissive). Safe for commercial and proprietary use with minimal restrictions; you may use, modify, and distribute subject to license attribution.

Quickstart

pip install apache-airflow-providers-mysql

from airflow.providers.mysql.operators.mysql import MySqlOperator
from airflow import DAG

with DAG('my_mysql_dag') as dag:
    task = MySqlOperator(
        task_id='run_query',
        sql='SELECT * FROM table',
        mysql_conn_id='mysql_default'
    )

Requires Apache Airflow >=2.11.0 already installed and a configured MySQL connection in Airflow.

Verify before relying

• Whether all seven MySQL client libraries are required simultaneously or if the provider auto-selects based on environment.
• Performance characteristics and connection pooling behavior across the different MySQL drivers.
• Async support scope and limitations with aiomysql.

Package facts

Evidence: apache_airflow_providers_mysql-6.6.1-py3-none-any.whl

Keywords: airflow-provider, mysql, airflow, integration

Tags

More Monitoring packages