pymssql 2.4.1


pip install pymssql

  Latest version

Released: Sep 07, 2026
Navigation
Meta
Author: Damien Churchill
Maintainer: Mikhail Terekhov
Requires Python: >=3.9
Classifiers

Development Status
  • 5 - Production/Stable

Intended Audience
  • Developers

Programming Language
  • Python
  • Python :: 3.9
  • Python :: 3.10
  • Python :: 3.11
  • Python :: 3.12
  • Python :: 3.13
  • Python :: 3.14
  • Python :: 3.15
  • Python :: Implementation :: CPython

Topic
  • Database
  • Database :: Database Engines/Servers
  • Software Development :: Libraries :: Python Modules

Operating System
  • Microsoft :: Windows
  • POSIX
  • Unix

pymssql - DB-API interface to Microsoft SQL Server

https://github.com/pymssql/pymssql/workflows/Wheels/badge.svg http://img.shields.io/pypi/dm/pymssql.svg http://img.shields.io/pypi/v/pymssql.svg

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.

Detailed information on pymssql is available on the website:

pymssql.readthedocs.io

New development is happening on GitHub at:

github.com/pymssql/pymssql

There is a Google Group for discussion at:

groups.google.com

Getting started

pymssql wheels are available from PyPi. To install it run:

pip install -U pip
pip install pymssql

Most of the times this should be all what’s needed. The official pymssql wheels bundle a static copy of FreeTDS and have SSL support so they can be used to connect to Azure.

Basic example

conn = pymssql.connect(server, user, password, "tempdb")
cursor = conn.cursor(as_dict=True)

cursor.execute('SELECT * FROM persons WHERE salesrep=%s', 'John Doe')
for row in cursor:
    print("ID=%d, Name=%s" % (row['id'], row['name']))

conn.close()

Recent Changes

Version 2.4.1 - 2026-09-07 - Mikhail Terekhov

General

  • Fix socket resource leak on failed connections (#1002), thanks to gintsmurans.

  • Enable free-threaded Python 3.14 wheel builds (#1004).

  • Add wheels for Python 3.15 (PR #1016), thanks to edgarrmondragon.

Version 2.4.0 - 2026-08-31 - Mikhail Terekhov

General

  • Update license information in pyproject.toml, thanks to ecederstrand (PR #1003).

  • Update win-iconv to 0.0.10.

  • Fix datetime conversion for BCP operations and build on Windows (PR #1015).

  • Update to latest OpenSSL version on Windows (currently 4.0.2).

  • Update FreeTDS to 1.5.19 for wheels.

2.4.1 Sep 07, 2026
2.4.0 Sep 01, 2026
2.3.13 Feb 14, 2026
2.3.12 Feb 11, 2026
2.3.11 Dec 30, 2025
2.3.10 Nov 30, 2025
2.3.9 Nov 07, 2025
2.3.8 Oct 12, 2025
2.3.7 Jul 11, 2025
2.3.6 Jun 28, 2025
2.3.5 Jun 25, 2025
2.3.4 Apr 02, 2025
2.3.3 Apr 01, 2025
2.3.2 Nov 21, 2024
2.3.1 Aug 25, 2024
2.3.0 Apr 06, 2024
2.2.11 Dec 04, 2023
2.2.10 Oct 26, 2023
2.2.9 Oct 14, 2023
2.2.8 Jul 30, 2023
2.2.7 Nov 16, 2022
2.2.6 Nov 13, 2022
2.2.5 Apr 13, 2022
2.2.4 Jan 24, 2022
2.2.3 Dec 21, 2021
2.2.2 Jul 24, 2021
2.2.1 Apr 16, 2021
2.2.1.dev0 Apr 06, 2021
2.2.0 Apr 09, 2021
2.1.5 Sep 17, 2020
2.1.4 Aug 28, 2018
2.1.4rc1 Aug 14, 2018
2.1.3 Jun 22, 2016
2.1.2 Feb 10, 2016
2.1.1 Nov 25, 2014
2.1.0 Feb 26, 2014
2.0.1 Oct 27, 2013
2.0.0 Oct 25, 2013
1.0.3 Oct 11, 2013
1.0.2 Apr 28, 2009
1.0.1 Feb 05, 2009
1.0.0 Jan 30, 2009
2.1.1.win32 Nov 25, 2014
2.1.1.win Nov 25, 2014
2.1.0.win32 Feb 28, 2014
2.0.1.win32 Oct 28, 2013
2.0.0.win32 Oct 26, 2013
1.0.2.win32 Apr 28, 2009
1.0.1.win32 Feb 05, 2009
1.0.0.win32 Jan 30, 2009

Wheel compatibility matrix

Platform CPython 3.9 CPython 3.10 CPython 3.11 CPython 3.12 CPython 3.13 CPython 3.14 CPython 3.15 CPython (additional flags: t) 3.14 CPython (additional flags: t) 3.15
macosx_14_0_arm64
macosx_15_0_x86_64
manylinux_2_27_aarch64
manylinux_2_27_x86_64
manylinux_2_28_aarch64
manylinux_2_28_x86_64
musllinux_1_2_aarch64
musllinux_1_2_x86_64
win_amd64

Files in release

pymssql-2.4.1-cp310-cp310-macosx_14_0_arm64.whl (3.1MiB)
pymssql-2.4.1-cp310-cp310-macosx_15_0_x86_64.whl (2.9MiB)
pymssql-2.4.1-cp310-cp310-manylinux_2_27_aarch64.manylinux_2_28_aarch64.whl (2.9MiB)
pymssql-2.4.1-cp310-cp310-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (3.0MiB)
pymssql-2.4.1-cp310-cp310-musllinux_1_2_aarch64.whl (3.5MiB)
pymssql-2.4.1-cp310-cp310-musllinux_1_2_x86_64.whl (3.3MiB)
pymssql-2.4.1-cp310-cp310-win_amd64.whl (2.2MiB)
pymssql-2.4.1-cp311-cp311-macosx_14_0_arm64.whl (3.1MiB)
pymssql-2.4.1-cp311-cp311-macosx_15_0_x86_64.whl (2.9MiB)
pymssql-2.4.1-cp311-cp311-manylinux_2_27_aarch64.manylinux_2_28_aarch64.whl (2.9MiB)
pymssql-2.4.1-cp311-cp311-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (3.0MiB)
pymssql-2.4.1-cp311-cp311-musllinux_1_2_aarch64.whl (3.5MiB)
pymssql-2.4.1-cp311-cp311-musllinux_1_2_x86_64.whl (3.3MiB)
pymssql-2.4.1-cp311-cp311-win_amd64.whl (2.2MiB)
pymssql-2.4.1-cp312-cp312-macosx_14_0_arm64.whl (3.0MiB)
pymssql-2.4.1-cp312-cp312-macosx_15_0_x86_64.whl (2.9MiB)
pymssql-2.4.1-cp312-cp312-manylinux_2_27_aarch64.manylinux_2_28_aarch64.whl (2.9MiB)
pymssql-2.4.1-cp312-cp312-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (3.1MiB)
pymssql-2.4.1-cp312-cp312-musllinux_1_2_aarch64.whl (3.6MiB)
pymssql-2.4.1-cp312-cp312-musllinux_1_2_x86_64.whl (3.3MiB)
pymssql-2.4.1-cp312-cp312-win_amd64.whl (2.2MiB)
pymssql-2.4.1-cp313-cp313-macosx_14_0_arm64.whl (3.0MiB)
pymssql-2.4.1-cp313-cp313-macosx_15_0_x86_64.whl (2.9MiB)
pymssql-2.4.1-cp313-cp313-manylinux_2_27_aarch64.manylinux_2_28_aarch64.whl (2.9MiB)
pymssql-2.4.1-cp313-cp313-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (3.1MiB)
pymssql-2.4.1-cp313-cp313-musllinux_1_2_aarch64.whl (3.6MiB)
pymssql-2.4.1-cp313-cp313-musllinux_1_2_x86_64.whl (3.3MiB)
pymssql-2.4.1-cp313-cp313-win_amd64.whl (2.2MiB)
pymssql-2.4.1-cp314-cp314-macosx_14_0_arm64.whl (3.0MiB)
pymssql-2.4.1-cp314-cp314-macosx_15_0_x86_64.whl (2.9MiB)
pymssql-2.4.1-cp314-cp314-manylinux_2_27_aarch64.manylinux_2_28_aarch64.whl (2.9MiB)
pymssql-2.4.1-cp314-cp314-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (3.1MiB)
pymssql-2.4.1-cp314-cp314-musllinux_1_2_aarch64.whl (3.6MiB)
pymssql-2.4.1-cp314-cp314-musllinux_1_2_x86_64.whl (3.3MiB)
pymssql-2.4.1-cp314-cp314-win_amd64.whl (2.3MiB)
pymssql-2.4.1-cp314-cp314t-macosx_14_0_arm64.whl (3.1MiB)
pymssql-2.4.1-cp314-cp314t-macosx_15_0_x86_64.whl (2.9MiB)
pymssql-2.4.1-cp314-cp314t-manylinux_2_27_aarch64.manylinux_2_28_aarch64.whl (2.9MiB)
pymssql-2.4.1-cp314-cp314t-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (3.1MiB)
pymssql-2.4.1-cp314-cp314t-musllinux_1_2_aarch64.whl (3.6MiB)
pymssql-2.4.1-cp314-cp314t-musllinux_1_2_x86_64.whl (3.3MiB)
pymssql-2.4.1-cp314-cp314t-win_amd64.whl (2.3MiB)
pymssql-2.4.1-cp315-cp315-macosx_14_0_arm64.whl (3.0MiB)
pymssql-2.4.1-cp315-cp315-macosx_15_0_x86_64.whl (2.9MiB)
pymssql-2.4.1-cp315-cp315-manylinux_2_27_aarch64.manylinux_2_28_aarch64.whl (2.9MiB)
pymssql-2.4.1-cp315-cp315-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (3.1MiB)
pymssql-2.4.1-cp315-cp315-musllinux_1_2_aarch64.whl (3.6MiB)
pymssql-2.4.1-cp315-cp315-musllinux_1_2_x86_64.whl (3.3MiB)
pymssql-2.4.1-cp315-cp315-win_amd64.whl (2.3MiB)
pymssql-2.4.1-cp315-cp315t-macosx_14_0_arm64.whl (3.1MiB)
pymssql-2.4.1-cp315-cp315t-macosx_15_0_x86_64.whl (2.9MiB)
pymssql-2.4.1-cp315-cp315t-manylinux_2_27_aarch64.manylinux_2_28_aarch64.whl (2.9MiB)
pymssql-2.4.1-cp315-cp315t-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (3.1MiB)
pymssql-2.4.1-cp315-cp315t-musllinux_1_2_aarch64.whl (3.6MiB)
pymssql-2.4.1-cp315-cp315t-musllinux_1_2_x86_64.whl (3.3MiB)
pymssql-2.4.1-cp315-cp315t-win_amd64.whl (2.3MiB)
pymssql-2.4.1-cp39-cp39-macosx_14_0_arm64.whl (3.1MiB)
pymssql-2.4.1-cp39-cp39-macosx_15_0_x86_64.whl (2.9MiB)
pymssql-2.4.1-cp39-cp39-manylinux_2_27_aarch64.manylinux_2_28_aarch64.whl (2.9MiB)
pymssql-2.4.1-cp39-cp39-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (3.0MiB)
pymssql-2.4.1-cp39-cp39-musllinux_1_2_aarch64.whl (3.5MiB)
pymssql-2.4.1-cp39-cp39-musllinux_1_2_x86_64.whl (3.3MiB)
pymssql-2.4.1-cp39-cp39-win_amd64.whl (2.2MiB)
pymssql-2.4.1.tar.gz (203.3KiB)
No dependencies