Microsoft Python Driver for SQL Server

Microsoft Python Driver for SQL Server

mssql-python is a Python driver for Microsoft SQL Server and the Azure SQL family of databases. It leverages Direct Database Connectivity (DDBC) that enables direct connections to SQL Server without requiring an external driver manager. Designed to comply with the DB API 2.0 specification, this driver also introduces Pythonic enhancements for improved usability and functionality. It supports a full range of database operations, including connection management, query execution, and transaction handling.

The driver is compatible with all the Python versions >= 3.10

Documentation | Release Notes | Roadmap

Note: This project is currently in Public Preview, meaning it is still under active development. We are working on core functionalities and gathering more feedback before GA. Please use with caution and avoid production environments.

Installation

Windows: mssql-python can be installed with pip

pip install mssql-python

MacOS: mssql-python can be installed with pip

# For Mac, OpenSSL is a pre-requisite - skip if already present brew install openssl pip install mssql-python

... continue reading