SQLAlchemy Documentation

Getting Started

New to SQLAlchemy? Start here:

Tutorials

New users of SQLAlchemy, as well as veterans of older SQLAlchemy release series, should start with the SQLAlchemy Unified Tutorial, which covers everything an Alchemist needs to know when using the ORM or just Core.

Migration Notes

Users coming SQLAlchemy version 2.0 will want to read:

Users transitioning from 1.x versions of SQLAlchemy, such as version 1.4, will want to transition to version 2.0 overall before making any additional changes needed for the much smaller transition from 2.0 to 2.1. Key documentation for the 1.x to 2.x transition:

An index of all changelogs and migration documentation is at:

Dialect Documentation

The dialect is the system SQLAlchemy uses to communicate with various types of DBAPIs and databases. This section describes notes, options, and usage patterns regarding individual dialects.

PostgreSQL | MySQL and MariaDB | SQLite | Oracle | Microsoft SQL Server

More Dialects …

Supplementary