pyodbc

pyodbc is an open source Python module that makes accessing ODBC databases simple. It implements the DB API 2.0 specification but is packed with even more Pythonic convenience.

The easiest way to install is to use pip:

pip install pyodbc

If you are using Mac, you should be using Homebrew for installing pyodbc:

brew install unixodbc
pip install pyodbc

Precompiled binary wheels are provided for most Python versions on Windows and macOS. On other operating systems this will build from source. Note, pyodbc contains C++ extensions so you will need a suitable C++ compiler on your computer to install pyodbc, for all operating systems. See the docs for details.

Documentation

Release Notes

IMPORTANT: Python 2.7 support is being ended. The pyodbc 4.x versions will be the last to support Python 2.7. The pyodbc 5.x versions will only support Python 3.7 and above.