| title | Microsoft Python Driver for SQL Server - mssql-python | |
|---|---|---|
| description | This guide provides an overview to get started with the Microsoft Python Driver for SQL Server - mssql-python | |
| author | dlevy-msft-sql | |
| ms.author | dlevy | |
| ms.reviewer | vanto, randolphwest | |
| ms.date | 03/14/2026 | |
| ms.service | sql | |
| ms.subservice | connectivity | |
| ms.topic | get-started | |
| ms.custom |
|
mssql-python is a Python driver for Microsoft SQL family of databases. It uses Direct Database Connectivity (DDBC) that enables direct connections to SQL Server without requiring an external driver manager. Designed to comply with the Python Database API Specification 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 Python version 3.10 and higher.
Use the mssql-python driver to connect to a SQL database from Python code. This series of articles provides step-by-step guidance for installing and using the Microsoft Python Driver for SQL.
- Quickstart: Connect with the mssql-python driver for Python
- Quickstart: Connect to a SQL database from a Jupyter Notebook
- Quickstart: Repeatable deployments with the mssql-python driver for Python
- Quickstart: Rapid prototyping with the mssql-python driver for Python
- Quickstart: Bulk copy with the mssql-python driver for Python
Microsoft fully supports mssql-python. While Microsoft is the primary maintainer, community contributions are encouraged.
Tip
To request new functionality, file an issue in the mssql-python GitHub repository or visit other Python community resources.
[!div class="nextstepaction"] Quickstart: Connect with the mssql-python driver for Python
