sqlalchemy/sqlalchemy
The Database Toolkit for Python observed · 2026-08-28
Health v2 · maintenance only
94/100
- Activity 99
- Release rhythm 85
- Longevity 100
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: 32.0
- age_days: 2836
- days_rel: 22
- days_push: 7
- n_releases_24m: 21
Adoption not part of the score
12111 stars · 1756 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 connection pooling and schema management, and an optional ORM built on data mapper patterns. It supports many database backends through dialects and offers both synchronous and asyncio APIs.
Use cases
- map python classes to database tables with an orm
- build sql queries programmatically in python
- connect to postgresql mysql sqlite from python
- introspect and generate database schemas
- manage database connection pooling in a web app
- write async database code with asyncio
When to choose
- you need a mature, feature-rich orm or sql abstraction in python
- you want fine-grained control over generated sql while staying pythonic
- you work with multiple database backends through one api
- you need schema reflection, ddl generation, and complex eager loading
When to avoid
- you want a lightweight query builder with minimal abstraction and prefer raw drivers
- you use a non-python stack
- you need automatic schema migrations out of the box (use alembic alongside)
Facets
library · maturity stable
orm database database-driver serialization databases backend web-development developer-tools python cross-platform sql-expression-language connection-pooling schema-migration asyncio-support database-abstraction
10 sources
- readme: https://github.com/sqlalchemy/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 |
|---|---|---|
| sqlalchemy/sqlalchemy | main | 94 |
For agents
markdown · JSON · MCP: product_card(name="sqlalchemy/sqlalchemy")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem