pymssql 2.4.6


pip install pymssql

  Latest version

Released: Oct 27, 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.6 - 2026-10-26 - Mikhail Terekhov

General

  • Switch to MacOS-14 for building wheels

  • bulk-copy(): fix case of temp tables (fixes #1021), thanks amgcc

Version 2.4.5 - 2026-10-19 - Mikhail Terekhov

General

  • Add native Windows arm64 wheel builds, thanks to knightmare2600

  • bulk-copy(): preserve supplied identity values (fixes #814)

  • bulk_copy(): encode Unicode for nvarchar bulk copy (fix #725,#917)

2.4.6 Oct 27, 2026
2.4.5 Oct 20, 2026
2.4.4 Oct 10, 2026
2.4.3 Oct 06, 2026
2.4.2 Sep 27, 2026
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_15_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
win_arm64

Files in release

pymssql-2.4.6-cp310-cp310-macosx_15_0_arm64.whl (3.1MiB)
pymssql-2.4.6-cp310-cp310-macosx_15_0_x86_64.whl (2.9MiB)
pymssql-2.4.6-cp310-cp310-manylinux_2_27_aarch64.manylinux_2_28_aarch64.whl (2.9MiB)
pymssql-2.4.6-cp310-cp310-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (3.1MiB)
pymssql-2.4.6-cp310-cp310-musllinux_1_2_aarch64.whl (4.3MiB)
pymssql-2.4.6-cp310-cp310-musllinux_1_2_x86_64.whl (4.0MiB)
pymssql-2.4.6-cp310-cp310-win_amd64.whl (2.2MiB)
pymssql-2.4.6-cp310-cp310-win_arm64.whl (1.8MiB)
pymssql-2.4.6-cp311-cp311-macosx_15_0_arm64.whl (3.1MiB)
pymssql-2.4.6-cp311-cp311-macosx_15_0_x86_64.whl (2.9MiB)
pymssql-2.4.6-cp311-cp311-manylinux_2_27_aarch64.manylinux_2_28_aarch64.whl (2.9MiB)
pymssql-2.4.6-cp311-cp311-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (3.1MiB)
pymssql-2.4.6-cp311-cp311-musllinux_1_2_aarch64.whl (4.3MiB)
pymssql-2.4.6-cp311-cp311-musllinux_1_2_x86_64.whl (4.0MiB)
pymssql-2.4.6-cp311-cp311-win_amd64.whl (2.2MiB)
pymssql-2.4.6-cp311-cp311-win_arm64.whl (1.8MiB)
pymssql-2.4.6-cp312-cp312-macosx_15_0_arm64.whl (3.1MiB)
pymssql-2.4.6-cp312-cp312-macosx_15_0_x86_64.whl (2.9MiB)
pymssql-2.4.6-cp312-cp312-manylinux_2_27_aarch64.manylinux_2_28_aarch64.whl (3.0MiB)
pymssql-2.4.6-cp312-cp312-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (3.1MiB)
pymssql-2.4.6-cp312-cp312-musllinux_1_2_aarch64.whl (4.3MiB)
pymssql-2.4.6-cp312-cp312-musllinux_1_2_x86_64.whl (4.0MiB)
pymssql-2.4.6-cp312-cp312-win_amd64.whl (2.2MiB)
pymssql-2.4.6-cp312-cp312-win_arm64.whl (1.8MiB)
pymssql-2.4.6-cp313-cp313-macosx_15_0_arm64.whl (3.1MiB)
pymssql-2.4.6-cp313-cp313-macosx_15_0_x86_64.whl (2.9MiB)
pymssql-2.4.6-cp313-cp313-manylinux_2_27_aarch64.manylinux_2_28_aarch64.whl (3.0MiB)
pymssql-2.4.6-cp313-cp313-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (3.1MiB)
pymssql-2.4.6-cp313-cp313-musllinux_1_2_aarch64.whl (4.3MiB)
pymssql-2.4.6-cp313-cp313-musllinux_1_2_x86_64.whl (4.0MiB)
pymssql-2.4.6-cp313-cp313-win_amd64.whl (2.2MiB)
pymssql-2.4.6-cp313-cp313-win_arm64.whl (1.8MiB)
pymssql-2.4.6-cp314-cp314-macosx_15_0_arm64.whl (3.1MiB)
pymssql-2.4.6-cp314-cp314-macosx_15_0_x86_64.whl (2.9MiB)
pymssql-2.4.6-cp314-cp314-manylinux_2_27_aarch64.manylinux_2_28_aarch64.whl (3.0MiB)
pymssql-2.4.6-cp314-cp314-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (3.1MiB)
pymssql-2.4.6-cp314-cp314-musllinux_1_2_aarch64.whl (4.3MiB)
pymssql-2.4.6-cp314-cp314-musllinux_1_2_x86_64.whl (4.0MiB)
pymssql-2.4.6-cp314-cp314-win_amd64.whl (2.3MiB)
pymssql-2.4.6-cp314-cp314-win_arm64.whl (1.8MiB)
pymssql-2.4.6-cp314-cp314t-macosx_15_0_arm64.whl (3.1MiB)
pymssql-2.4.6-cp314-cp314t-macosx_15_0_x86_64.whl (2.9MiB)
pymssql-2.4.6-cp314-cp314t-manylinux_2_27_aarch64.manylinux_2_28_aarch64.whl (3.0MiB)
pymssql-2.4.6-cp314-cp314t-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (3.1MiB)
pymssql-2.4.6-cp314-cp314t-musllinux_1_2_aarch64.whl (4.3MiB)
pymssql-2.4.6-cp314-cp314t-musllinux_1_2_x86_64.whl (4.0MiB)
pymssql-2.4.6-cp314-cp314t-win_amd64.whl (2.3MiB)
pymssql-2.4.6-cp314-cp314t-win_arm64.whl (1.8MiB)
pymssql-2.4.6-cp315-cp315-macosx_15_0_arm64.whl (3.1MiB)
pymssql-2.4.6-cp315-cp315-macosx_15_0_x86_64.whl (2.9MiB)
pymssql-2.4.6-cp315-cp315-manylinux_2_27_aarch64.manylinux_2_28_aarch64.whl (3.0MiB)
pymssql-2.4.6-cp315-cp315-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (3.1MiB)
pymssql-2.4.6-cp315-cp315-musllinux_1_2_aarch64.whl (4.3MiB)
pymssql-2.4.6-cp315-cp315-musllinux_1_2_x86_64.whl (4.0MiB)
pymssql-2.4.6-cp315-cp315-win_amd64.whl (2.3MiB)
pymssql-2.4.6-cp315-cp315-win_arm64.whl (1.8MiB)
pymssql-2.4.6-cp315-cp315t-macosx_15_0_arm64.whl (3.1MiB)
pymssql-2.4.6-cp315-cp315t-macosx_15_0_x86_64.whl (2.9MiB)
pymssql-2.4.6-cp315-cp315t-manylinux_2_27_aarch64.manylinux_2_28_aarch64.whl (3.0MiB)
pymssql-2.4.6-cp315-cp315t-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (3.1MiB)
pymssql-2.4.6-cp315-cp315t-musllinux_1_2_aarch64.whl (4.3MiB)
pymssql-2.4.6-cp315-cp315t-musllinux_1_2_x86_64.whl (4.0MiB)
pymssql-2.4.6-cp315-cp315t-win_amd64.whl (2.3MiB)
pymssql-2.4.6-cp315-cp315t-win_arm64.whl (1.8MiB)
pymssql-2.4.6-cp39-cp39-macosx_15_0_arm64.whl (3.1MiB)
pymssql-2.4.6-cp39-cp39-macosx_15_0_x86_64.whl (2.9MiB)
pymssql-2.4.6-cp39-cp39-manylinux_2_27_aarch64.manylinux_2_28_aarch64.whl (2.9MiB)
pymssql-2.4.6-cp39-cp39-manylinux_2_27_x86_64.manylinux_2_28_x86_64.whl (3.1MiB)
pymssql-2.4.6-cp39-cp39-musllinux_1_2_aarch64.whl (4.3MiB)
pymssql-2.4.6-cp39-cp39-musllinux_1_2_x86_64.whl (4.0MiB)
pymssql-2.4.6-cp39-cp39-win_amd64.whl (2.2MiB)
pymssql-2.4.6-cp39-cp39-win_arm64.whl (1.8MiB)
pymssql-2.4.6.tar.gz (208.0KiB)
No dependencies