apache-airflow-providers-microsoft-mssql
Provider package apache-airflow-providers-microsoft-mssql for Apache Airflow
Decision gist · record as of 2026-08-14
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.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- 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.
- 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.
License · maintenance · safety
Apache-2.0 (permissive) — 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.
last release 2026-06-22 (53 days) · last repo commit 2026-08-14 · 46,490 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 4,195,069 downloads/mo, #2,364 on PyPI
Alternatives
Verify before relying
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'
)- 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.
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 on it.
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
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.
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.
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'
)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
| 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-sqlapache-airflow-providers-common-compatpymssqlmethodtools |
| Maintenance | Actively maintained 53 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 4,195,069 / month, #2,364 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_microsoft_mssql-4.7.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 mssql provider”
- apache-airflow-providers-microsoft-mssqlIntegrates Microsoft SQL Server (MSSQL) with Apache Airflow,…
- apache-airflow-providers-apache-hiveIntegrates Apache Hive with Apache Airflow, enabling Hive query…
- apache-airflow-providers-common-ioProvides common I/O utilities and operators for Apache Airflow…
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-common-sql · apache-airflow-providers-mysql · apache-airflow-providers-odbc · apache-airflow-providers-oracle · apache-airflow-providers-microsoft-azure · apache-airflow-providers-exasol · airflow-clickhouse-plugin · apache-airflow-providers-jdbc · apache-airflow-providers-ydb · apache-airflow-providers-postgres