advanced-alchemy
Ready-to-go SQLAlchemy concoctions.
Decision gist · record as of 2026-08-14
Yes. Advanced Alchemy is actively maintained, has low install friction, carries no known vulnerabilities, and is MIT-licensed. It's well-suited for web frameworks (FastAPI, Litestar, Starlette) where reducing repository boilerplate is valuable. Install it if you're building a data-driven web application and want structured, tested patterns for database access; skip it if you prefer minimal abstractions over SQLAlchemy or are not using one of its supported frameworks.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires SQLAlchemy and a database driver; async operations require an async-compatible database driver and event loop.
- Low friction install with a pure-Python wheel.
- Maintenance is active with a release within the last 75 days.
License · maintenance · safety
MIT (permissive) — MIT license is permissive; you can use this in commercial and proprietary projects with minimal restrictions, provided you include the license notice.
last release 2026-05-31 (75 days)
0 known vulnerabilities (OSV.dev, 2026-08-14) · 451,970 downloads/mo, #6,583 on PyPI
Alternatives
Verify before relying
pip install advanced-alchemy
from advanced_alchemy.repository import SQLAlchemyRepository
from sqlalchemy.orm import Session
repo = SQLAlchemyRepository(session=session, model=YourModel)
await repo.create(data={"field": "value"})- Whether composite primary key support works across all database backends listed in the fact sheet.
- Performance characteristics of bulk operations compared to raw SQLAlchemy queries.
- Dogpile caching integration requirements and configuration details.
What it is and what it does
Advanced Alchemy is a companion library that wraps SQLAlchemy to provide higher-level abstractions for common database patterns. It offers sync and async repository classes that handle CRUD operations and optimized bulk inserts/updates, eliminating boilerplate code for typical web application data access layers. The library integrates directly with popular frameworks like Litestar, FastAPI, Starlette, and Sanic, and includes utilities for audit columns, composite primary keys, and read/write replica routing.
The package is built on top of SQLAlchemy, alembic, greenlet, and typing utilities. It targets developers building web applications who want to reduce repetitive repository and service layer code while maintaining full SQLAlchemy flexibility. The library supports modern Python versions (3.9 through 3.14) and is actively maintained, with an MIT license allowing use in any project type.
Use it for
- Build a FastAPI or Litestar application with pre-built async repository classes for common CRUD operations without writing boilerplate.
- Implement read/write database replica routing with automatic query distribution and sticky-primary mode for high-traffic applications.
- Store file objects in the database using a unified interface across different storage backends (fsspec or obstore).
- Add audit columns and composite primary key support to your SQLAlchemy models with utility base classes.
- Cache frequently-accessed query results using Dogpile integration without modifying existing repository code.
- Perform optimized bulk insert and update operations on large datasets with repository bulk methods.
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
Advanced Alchemy is actively maintained, has low install friction, carries no known vulnerabilities, and is MIT-licensed. It's well-suited for web frameworks (FastAPI, Litestar, Starlette) where reducing repository boilerplate is valuable. Install it if you're building a data-driven web application and want structured, tested patterns for database access; skip it if you prefer minimal abstractions over SQLAlchemy or are not using one of its supported frameworks.
Install
advanced-alchemy on PyPI
Before you install
Low friction install with a pure-Python wheel. Maintenance is active with a release within the last 75 days. Six runtime dependencies are all well-established libraries (sqlalchemy, alembic, greenlet, typing-extensions, eval-type-backport, exceptiongroup).
Requires SQLAlchemy and a database driver; async operations require an async-compatible database driver and event loop.
License in practice
MIT license is permissive; you can use this in commercial and proprietary projects with minimal restrictions, provided you include the license notice.
Quickstart
pip install advanced-alchemy
from advanced_alchemy.repository import SQLAlchemyRepository
from sqlalchemy.orm import Session
repo = SQLAlchemyRepository(session=session, model=YourModel)
await repo.create(data={"field": "value"})Verify before relying
- Whether composite primary key support works across all database backends listed in the fact sheet.
- Performance characteristics of bulk operations compared to raw SQLAlchemy queries.
- Dogpile caching integration requirements and configuration details.
Package facts
| License | MIT permissive |
| Python support | Supports the current Python release >=3.9 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 6 packagesalembiceval-type-backportexceptiongroupgreenletsqlalchemytyping-extensions |
| Maintenance | Actively maintained 75 days since the last release |
| First released | |
| Downloads | 451,970 / month, #6,583 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Development Status :: 3 - AlphaEnvironment :: Web EnvironmentIntended Audience :: DevelopersIntended Audience :: System AdministratorsLicense :: OSI Approved :: MIT LicenseNatural Language :: EnglishOperating System :: OS IndependentProgramming Language :: PythonProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Programming Language :: Python :: 3.9Topic :: DatabaseTopic :: Database :: Database Engines/ServersTopic :: Software DevelopmentTyping :: Typed |
Evidence: advanced_alchemy-1.11.0-py3-none-any.whl
Tags
Let your AI agent find packages like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 14,416 PyPI packages by what they can do, searchable in plain language.
wish › “sqlalchemy repository pattern”
- advanced-alchemyAdvanced Alchemy provides sync and async SQLAlchemy repositories with…
- sqlalchemy-mixinsProvides Active Record-style mixins for SQLAlchemy ORM, enabling…
- async-factory-boyExtends factory_boy to generate test fixtures asynchronously for…
Give your agent the search over MCP, or paste the wish link into any chat.
More Software Development packages
Provides backported and experimental type hints for Python 3.9+, allowing use of newer typing features on older Python versions and enabling early experimentation with type system PEPs before they enter the standard library.
NumPy provides an N-dimensional array object and a comprehensive suite of mathematical, linear algebra, Fourier transform, and random number functions for scientific computing in Python.
FastAPI is a Python web framework for building REST APIs using type hints, with automatic request validation, serialization, and interactive API documentation.
Provides a way to document function parameters, class attributes, return types, and variables inline using Python's `Annotated` type hint syntax instead of traditional docstrings.
Typer builds command-line applications from Python functions using type hints, automatically generating help text, argument parsing, and shell completion.
Install it if you are building CLIs in Python.
Distlib provides low-level packaging utilities for building, distributing, and managing Python software—including metadata handling, version specifiers, wheel support, script installation, and dependency resolution.
See also databases · litestar · sqlalchemy-mixins · fastcrud · sqladmin · casbin-async-sqlalchemy-adapter · FastAPI-SQLAlchemy · sqlalchemy-cockroachdb · validations-engine · starlette-admin