---
id: pyodbc
version: "5.3.0"
license: MIT
license_treatment: permissive
maintenance: active
---

# pyodbc — DB API module for ODBC

License: permissive · Maintenance: active · Popularity: top 1,000 on PyPI

## Install

pip install pyodbc
uv add pyodbc
poetry add pyodbc

## Description

# pyodbc

[![Windows build](https://ci.appveyor.com/api/projects/status/github/mkleehammer/pyodbc?branch=master&svg=true&passingText=Windows%20build&failingText=Windows%20build)](https://ci.appveyor.com/project/mkleehammer/pyodbc)
[![Ubuntu build](https://github.com/mkleehammer/pyodbc/actions/workflows/ubuntu_build.yml/badge.svg)](https://github.com/mkleehammer/pyodbc/actions/workflows/ubuntu_build.yml)
[![PyPI](https://img.shields.io/pypi/v/pyodbc?color=brightgreen)](https://pypi.org/project/pyodbc/)

pyodbc is an open source Python module that makes accessing ODBC databases simple.  It
implements the [DB API 2.0](https://www.python.org/dev/peps/pep-0249) specification but is packed with even more Pythonic convenience.

The easiest way to install pyodbc is to use pip:

    python -m pip install pyodbc

On Macs, you should probably install unixODBC first if you don't already have an ODBC
driver manager installed.  For example, using the [homebrew](https://brew.sh/) package manager:

    brew install unixodbc
    python -m pip install pyodbc

Similarly, on Unix you should make sure you have an ODBC driver manager installed before
installing pyodbc.  See the...

## AI interpretation — verify before relying

pyodbc provides a Python interface to ODBC databases, implementing the DB API 2.0 specification for simple, Pythonic database access across Windows, macOS, and Linux.

Verdict: pyodbc is a mature, actively maintained DB API 2.0 implementation with broad platform support and no known vulnerabilities. Medium install friction stems from C++ compilation and system ODBC dependencies, but precompiled wheels and permissive MIT licensing make it a solid choice for ODBC database access.

[View on SkillFed](https://skillfed.io/packages/pyodbc) · [View on PyPI](https://pypi.org/project/pyodbc/)