apache-airflow-providers-microsoft-mssql

What it is and what it does

This is an Apache Airflow provider package that bridges Airflow orchestration with Microsoft SQL Server databases. It supplies operators, hooks, and sensors—the building blocks for Airflow DAGs—that let you query MSSQL and execute database operations as part of your data pipelines. The package depends on apache-airflow (>=2.11.0), apache-airflow-providers-common-sql, apache-airflow-providers-common-compat, pymssql for the actual database connection, and methodtools.

You install it on top of an existing Airflow deployment and then import its operators into your DAG definitions. It is maintained as part of the Apache Airflow project and supports Python 3.10, 3.11, 3.12, 3.13, 3.14. The package is production-stable and receives regular updates; no known security vulnerabilities are recorded.

Use it for:

• Schedule and execute SQL queries against MSSQL databases on a recurring basis within Airflow DAGs.
• Orchestrate multi-step data pipelines that read from or write to MSSQL as one step among many.
• Monitor MSSQL query execution as part of a larger Airflow monitoring workflow.
• Integrate MSSQL data tasks with data lineage tracking via the optional openlineage extra.

Worth the install?

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

Integrates Microsoft SQL Server (MSSQL) with Apache Airflow, providing operators, hooks, and sensors to query and execute MSSQL databases within Airflow workflows.

Yes. This is a production-stable, actively maintained Apache project with no known vulnerabilities, low install friction, and permissive licensing. Install it if you run Airflow and need to orchestrate MSSQL tasks. Verify beforehand that your Airflow version meets >=2.11.0 and that pymssql is available for your Python version.

Install

apache-airflow-providers-microsoft-mssql on PyPI

pip install apache-airflow-providers-microsoft-mssql

uv add apache-airflow-providers-microsoft-mssql

poetry add apache-airflow-providers-microsoft-mssql

Installing apache-airflow-providers-microsoft-mssql

Before you install

Low install friction; pure Python wheel with no compiled dependencies. Maintenance is active—the parent Apache Airflow project has 46490 stars and receives regular updates. Last commit 2026-08-14, release 53 days old.

License in practice

Apache-2.0 (permissive): you may use, modify, and distribute this package freely in commercial and private projects, provided you include a copy of the license and do not hold the ASF liable.

Quickstart

pip install apache-airflow-providers-microsoft-mssql

from airflow.providers.microsoft.mssql.operators.mssql import MSSQLOperator
from airflow import DAG

with DAG('mssql_example') as dag:
    task = MSSQLOperator(
        task_id='query_mssql',
        sql='SELECT * FROM table',
        mssql_conn_id='mssql_default'
    )

Requires apache-airflow >=2.11.0 and a configured MSSQL connection; pymssql >=2.3.5 (or >=2.3.13 for Python >=3.14) must be installed.

Verify before relying

• Whether this package includes sensors for polling MSSQL query results or only operators for direct execution.
• Support for MSSQL-specific features such as stored procedures, transactions, or bulk operations.
• Whether the openlineage extra enables data lineage tracking for MSSQL queries.

Package facts

Evidence: apache_airflow_providers_microsoft_mssql-4.7.0-py3-none-any.whl

Keywords: airflow-provider, microsoft.mssql, airflow, integration

Tags

More Monitoring packages