---
id: pymssql
version: "2.3.13"
license: GNU LESSER GENERAL PUBLIC LICENSE Version 2.1, February 1999 Copyright (C) 1991, 1999 Free Software Foundation, Inc. 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA Everyone is permitted… (full text in the JSON record)
license_treatment: copyleft
maintenance: active
---

# pymssql — DB-API interface to Microsoft SQL Server for Python. (new Cython-based version)

License: copyleft · Maintenance: active · Popularity: top 1,000 on PyPI

## Install

pip install pymssql
uv add pymssql
poetry add pymssql

## Description

pymssql - DB-API interface to Microsoft SQL Server
==================================================

.. image:: https://github.com/pymssql/pymssql/workflows/Wheels/badge.svg
        :target: https://github.com/pymssql/pymssql/actions?query=workflow%3A%22Wheels%22

.. image:: http://img.shields.io/pypi/dm/pymssql.svg
        :target: https://pypi.python.org/pypi/pymssql/

.. image:: http://img.shields.io/pypi/v/pymssql.svg
        :target: https://pypi.python.org/pypi/pymssql/

A simple database interface for `Python`_ that builds on top of `FreeTDS`_ to
provide a Python DB-API (`PEP-249`_) interface to `Microsoft SQL Server`_.

.. _Microsoft SQL Server: http://www.microsoft.com/sqlserver/
.. _Python: http://www.python.org/
.. _PEP-249: http://www.python.org/dev/peps/pep-0249/
.. _FreeTDS: http://www.freetds.org/

Detailed information on pymssql is available on the website:

`pymssql.readthedocs.io <https://pymssql.readthedocs.io/en/stable/>`_

New development is happening on GitHub at:

`github.com/pymssql/pymssql <https://github.com/pymssql/pymssql>`_

There is a Google Group for discussion at:

`groups.google.com...

## AI interpretation — verify before relying

pymssql provides a Python DB-API interface to Microsoft SQL Server, built on FreeTDS, enabling SQL queries and connection management via standard Python database operations.

Verdict: pymssql is a stable, actively maintained DB-API driver for SQL Server with broad Python version support (3.9–3.14) and prebuilt wheels reducing install friction. LGPL 2.1 licensing permits commercial use without modification. No known vulnerabilities and top-1000 popularity make it a reliable choice for SQL Server integration, though deployment requires an accessible SQL Server instance.

[View on SkillFed](https://skillfed.io/packages/pymssql) · [View on PyPI](https://pypi.org/project/pymssql/)