SQLAlchemy

Database Abstraction Library

sqlalchemy Permissive license MIT Active ★ 12,079 v2.0.52 released 2026-08-11

Install

sqlalchemy on PyPI

pip

pip install sqlalchemy

uv

uv add sqlalchemy

poetry

poetry add sqlalchemy

Package facts

License	MIT (permissive)
Python support	supports the current Python release (>=3.7)
Install friction	low — pure-Python wheel
Runtime dependencies	3 — importlib-metadata, greenlet, typing-extensions
Maintenance	actively maintained — 2 days since the last release
Last repo commit	2026-08-13
First released	2006-02-14
Popularity	one of the 100 most-downloaded packages on PyPI (30-day window, as of 2026-08-13)
Known vulnerabilities	none known (OSV.dev, checked 2026-08-13)

Evidence: sqlalchemy-2.0.52-py3-none-any.whl

Development Status :: 5 - Production/StableIntended Audience :: DevelopersOperating System :: OS IndependentProgramming Language :: PythonProgramming Language :: Python :: 3Programming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Programming Language :: Python :: 3.15Programming Language :: Python :: 3.7Programming Language :: Python :: 3.8Programming Language :: Python :: 3.9Programming Language :: Python :: Implementation :: CPythonProgramming Language :: Python :: Implementation :: PyPyTopic :: Database :: Front-Ends

About SQLAlchemy

from the package's own PyPI description — quoted content, verbatim

SQLAlchemy

.. |PyPI| image:: https://img.shields.io/pypi/v/sqlalchemy :target: https://pypi.org/project/sqlalchemy :alt: PyPI

.. |Python| image:: https://img.shields.io/pypi/pyversions/sqlalchemy :target: https://pypi.org/project/sqlalchemy :alt: PyPI - Python Version

.. |Downloads| image:: https://static.pepy.tech/badge/sqlalchemy/month :target: https://pepy.tech/project/sqlalchemy :alt: PyPI - Downloads

The Python SQL Toolkit and Object Relational Mapper

Introduction

SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL. SQLAlchemy provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language.

Major SQLAlchemy features include:

An industrial strength ORM, built from the core on the identity map, unit of work, and data mapper patterns. These patterns allow transparent persistence of objects using a declarative configuration system. Domain models can be constructed and...

Read as markdown · JSON record · Source repository · Homepage · Docs

AI interpretation — verify before relying

AI-generated interpretation of the package facts above; every digit, version, license, or vulnerability id it cites is grounded in the facts already shown on this page

SQLAlchemy is a Python SQL toolkit and Object Relational Mapper that provides both a high-level ORM for transparent object persistence and a Core SQL construction layer for direct database abstraction and query building.

Low friction install with three lightweight runtime dependencies (importlib-metadata, greenlet, typing-extensions). Active maintenance with a release just 2 days ago and sustained development since 2006; supports Python 3.7–3.15 and PyPy.

Distributed under the MIT license (permissive), imposing no restrictions on commercial or proprietary use provided the license text is retained.

Usage

pip install sqlalchemy==2.0.52

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.orm import declarative_base, Session

Base = declarative_base()
engine = create_engine('sqlite:///:memory:')
Base.metadata.create_all(engine)

Requires a database driver (e.g., psycopg2 for PostgreSQL, pymysql for MySQL) installed separately; greenlet is a compiled dependency.

Verdict: SQLAlchemy 2.0.52 is a mature, actively maintained, top-100 PyPI package with zero known vulnerabilities, permissive licensing, and low install friction. It is production-stable and suitable for projects requiring robust database abstraction, ORM capabilities, or direct SQL expression building.

Needs verification

Whether greenlet's compiled nature poses friction on specific platforms or architectures beyond the generic 'low' classification
Performance characteristics or known limitations when used with specific database backends not mentioned in the fact sheet

python orm databasesql toolkit object mapperdatabase abstraction layersqlalchemy query builderpython sql persistencerelational database mappingdeclarative database models