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.

The wheels of pymssql are built against the latest release of FreeTDS and could be found on PyPI Project.



  • Unicode friendly

  • Python 3 friendly

  • Works on most popular operating systems

  • Written in Cython for performance

  • Includes a supported and documented low-level module (_mssql) that you can use instead of the DB-API

  • Supports stored procedures with both return values and output parameters

  • Supports bulk copy

  • A comprehensive test suite

  • Compatible with cooperative multi-tasking systems (gevent, etc.)

  • Can be used to connect to Azure


pymssql is licensed under the terms of the GNU LGPL license.


Indices and tables