pymssql 2.3.8


pip install pymssql

  Latest version

Released: Oct 12, 2025
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 :: 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.3.8 - 2025-10-11 - Mikhail Terekhov

General

  • Build Python 3.14 wheels, thanks to Edgar Ramírez Mondragón (PR #964).

Version 2.3.7 - 2025-07-10 - Mikhail Terekhov

General

  • Allow to specify openssl dependency on macos, thanks to dwt (PR #934).

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
macosx_13_0_x86_64
macosx_14_0_arm64
manylinux2014_aarch64
manylinux2014_x86_64
manylinux_2_17_aarch64
manylinux_2_17_x86_64
musllinux_1_2_aarch64
musllinux_1_2_x86_64
win32
win_amd64

Files in release

pymssql-2.3.8-cp310-cp310-macosx_13_0_x86_64.whl (2.8MiB)
pymssql-2.3.8-cp310-cp310-macosx_14_0_arm64.whl (3.0MiB)
pymssql-2.3.8-cp310-cp310-manylinux2014_aarch64.manylinux_2_17_aarch64.whl (2.3MiB)
pymssql-2.3.8-cp310-cp310-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (2.7MiB)
pymssql-2.3.8-cp310-cp310-musllinux_1_2_aarch64.whl (3.5MiB)
pymssql-2.3.8-cp310-cp310-musllinux_1_2_x86_64.whl (3.3MiB)
pymssql-2.3.8-cp310-cp310-win32.whl (1.3MiB)
pymssql-2.3.8-cp310-cp310-win_amd64.whl (1.9MiB)
pymssql-2.3.8-cp311-cp311-macosx_13_0_x86_64.whl (2.8MiB)
pymssql-2.3.8-cp311-cp311-macosx_14_0_arm64.whl (3.0MiB)
pymssql-2.3.8-cp311-cp311-manylinux2014_aarch64.manylinux_2_17_aarch64.whl (2.3MiB)
pymssql-2.3.8-cp311-cp311-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (2.7MiB)
pymssql-2.3.8-cp311-cp311-musllinux_1_2_aarch64.whl (3.5MiB)
pymssql-2.3.8-cp311-cp311-musllinux_1_2_x86_64.whl (3.3MiB)
pymssql-2.3.8-cp311-cp311-win32.whl (1.3MiB)
pymssql-2.3.8-cp311-cp311-win_amd64.whl (1.9MiB)
pymssql-2.3.8-cp312-cp312-macosx_13_0_x86_64.whl (2.8MiB)
pymssql-2.3.8-cp312-cp312-macosx_14_0_arm64.whl (3.0MiB)
pymssql-2.3.8-cp312-cp312-manylinux2014_aarch64.manylinux_2_17_aarch64.whl (2.4MiB)
pymssql-2.3.8-cp312-cp312-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (2.7MiB)
pymssql-2.3.8-cp312-cp312-musllinux_1_2_aarch64.whl (3.5MiB)
pymssql-2.3.8-cp312-cp312-musllinux_1_2_x86_64.whl (3.3MiB)
pymssql-2.3.8-cp312-cp312-win32.whl (1.2MiB)
pymssql-2.3.8-cp312-cp312-win_amd64.whl (1.9MiB)
pymssql-2.3.8-cp313-cp313-macosx_13_0_x86_64.whl (2.8MiB)
pymssql-2.3.8-cp313-cp313-macosx_14_0_arm64.whl (3.0MiB)
pymssql-2.3.8-cp313-cp313-manylinux2014_aarch64.manylinux_2_17_aarch64.whl (2.4MiB)
pymssql-2.3.8-cp313-cp313-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (2.7MiB)
pymssql-2.3.8-cp313-cp313-musllinux_1_2_aarch64.whl (3.5MiB)
pymssql-2.3.8-cp313-cp313-musllinux_1_2_x86_64.whl (3.3MiB)
pymssql-2.3.8-cp313-cp313-win32.whl (1.2MiB)
pymssql-2.3.8-cp313-cp313-win_amd64.whl (1.9MiB)
pymssql-2.3.8-cp314-cp314-macosx_13_0_x86_64.whl (2.8MiB)
pymssql-2.3.8-cp314-cp314-macosx_14_0_arm64.whl (3.0MiB)
pymssql-2.3.8-cp314-cp314-manylinux2014_aarch64.manylinux_2_17_aarch64.whl (2.4MiB)
pymssql-2.3.8-cp314-cp314-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (2.7MiB)
pymssql-2.3.8-cp314-cp314-musllinux_1_2_aarch64.whl (3.5MiB)
pymssql-2.3.8-cp314-cp314-musllinux_1_2_x86_64.whl (3.3MiB)
pymssql-2.3.8-cp314-cp314-win32.whl (1.3MiB)
pymssql-2.3.8-cp314-cp314-win_amd64.whl (1.9MiB)
pymssql-2.3.8-cp39-cp39-macosx_13_0_x86_64.whl (2.8MiB)
pymssql-2.3.8-cp39-cp39-macosx_14_0_arm64.whl (3.0MiB)
pymssql-2.3.8-cp39-cp39-manylinux2014_aarch64.manylinux_2_17_aarch64.whl (2.3MiB)
pymssql-2.3.8-cp39-cp39-manylinux2014_x86_64.manylinux_2_17_x86_64.whl (2.7MiB)
pymssql-2.3.8-cp39-cp39-musllinux_1_2_aarch64.whl (3.5MiB)
pymssql-2.3.8-cp39-cp39-musllinux_1_2_x86_64.whl (3.3MiB)
pymssql-2.3.8-cp39-cp39-win32.whl (1.3MiB)
pymssql-2.3.8-cp39-cp39-win_amd64.whl (1.9MiB)
pymssql-2.3.8.tar.gz (180.8KiB)
No dependencies