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 from older versions of SQLAlchemy, especially those transitioning from the 1.x style of working, will want to review this documentation.

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