Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
Get started
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
Documentation
Support
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.