zzzeek/sqlalchemy
THIS IS NOT THE OFFICIAL REPO - PLEASE SUBMIT PRs ETC AT: http://github.com/sqlalchemy/sqlalchemy observed · 2026-08-28
Health v2 · maintenance only
77/100
- Activity 99
- Release rhythm 35
- Longevity 100
Flags: no_releases
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: n/a
- age_days: 4848
- days_rel: n/a
- days_push: 7
- n_releases_24m: 0
Adoption not part of the score
3454 stars · 862 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded
SQLAlchemy is the Python SQL toolkit and Object Relational Mapper, providing both a Core SQL expression language with schema management and connection pooling, and an optional ORM built on identity map, unit of work, and data mapper patterns. It supports many database backends via dialects, including asyncio support and typed declarative mappings.
Use cases
- map python classes to database tables with an orm
- build type-safe sql queries in python without writing raw sql
- manage database schema metadata and generate ddl
- connect to postgresql, mysql, sqlite, or oracle from python
- reflect an existing database schema into python objects
- use async database access in a python web app
- pool and manage database connections efficiently
When to choose
- you need a mature, battle-tested orm or sql abstraction in python
- you want fine-grained control over generated sql while keeping pythonic ergonomics
- your application needs to work across multiple database backends
- you need schema introspection, reflection, or ddl generation
When to avoid
- you want a lightweight query builder with no orm layer and prefer raw sql drivers
- you are using a non-python stack
- you need a schema migration tool only - use alembic, which builds on sqlalchemy, instead
Facets
library · maturity stable
orm database database-driver serialization databases backend web-development developer-tools python cross-platform sql-expression-language connection-pooling schema-management asyncio data-mapper unit-of-work dbapi
10 sources
- readme: https://github.com/zzzeek/sqlalchemy · fetched 2026-08-28 · 4cab00c710b0
- homepage: https://www.sqlalchemy.org · fetched 2026-08-29 · 12dd3644edcb
- site_page: https://www.sqlalchemy.org/features.html · fetched 2026-08-29 · 1aed45833c2f
- site_page: https://docs.sqlalchemy.org · fetched 2026-08-29 · 89c3a9f507dc
- site_page: https://docs.sqlalchemy.org/intro.html · fetched 2026-08-29 · 863869270304
- site_page: https://docs.sqlalchemy.org/orm/quickstart.html · fetched 2026-08-29 · e3f07adbaa7d
- site_page: https://www.sqlalchemy.org/docs/21/changelog/migration_21.html · fetched 2026-08-29 · 5349ee2ca4e5
- site_page: https://www.sqlalchemy.org/docs/21 · fetched 2026-08-29 · 79a6378ec549
- site_page: https://www.sqlalchemy.org/library.html · fetched 2026-08-29 · 2610adc06d4b
- site_page: https://www.sqlalchemy.org/changelog/CHANGES_2_1_0b3 · fetched 2026-08-29 · c2456e854992
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| zzzeek/sqlalchemy | main | 77 |
For agents
markdown · JSON · MCP: product_card(name="zzzeek/sqlalchemy")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem