Yet another MS SQLServer database driver


Keywords
SQLServer
License
MIT
Install
pip install minitds==0.5.3

Documentation

minitds

Yet another Python MS SQLServer database driver.

Support platform

  • Python 3.5+

Support database

We test with MS SQLServer 2019 on Ubuntu. But we think it works with the following versions.

  • MS SQLServer 2012, 2014, 2016, 2017, 2019
  • Microsoft Azure SQL Database

Installation

$ pip install minitds

Example

Query:

import minitds
conn = minitds.connect(host='localhost',
                    user='sa',
                    password='secret',
                    database='database_name')
cur = conn.cursor()
cur.execute('select foo, bar from baz')
for r in cur.fetchall():
   print(r[0], r[1])
conn.close()

Execute Procedure:

import minitds
conn = minitds.connect(host='localhost',
                    user='sa',
                    password='secret',
                    database='database_name')
cur = conn.cursor()
cur.callproc('something_proc', [123, 'ABC'])
conn.close()

Restrictions

  • Support connecting through SQL Server Authentication only.