SQLAlchemy-Utils
Various utility functions for SQLAlchemy.
Decision gist · record as of 2026-08-14
Yes. The package is actively maintained, has no known vulnerabilities, installs with minimal friction, and is widely used (top 1000 on PyPI). It's worth installing if you're building SQLAlchemy models and want to reduce boilerplate for common patterns like email validation, URL types, or other utility functions—but only if those specific utilities align with your project's needs.AI-flagged interpretation of the facts on this page — verify before relying
Before you install
- Requires SQLAlchemy as a runtime dependency; minimum Python version is 3.9.
- Low friction install with a single runtime dependency on SQLAlchemy.
- The package is actively maintained with a recent commit on 2026-07-08 and has been in development since 2013-03-01, indicating stable, long-term support.
License · maintenance · safety
BSD-3-Clause (permissive) — Licensed under BSD-3-Clause (permissive), allowing use in commercial and proprietary projects with minimal restrictions beyond attribution and liability disclaimers.
last release 2025-12-13 (244 days) · last repo commit 2026-07-08 · 1,342 stars
0 known vulnerabilities (OSV.dev, 2026-08-14) · 29,307,657 downloads/mo, #819 on PyPI
Alternatives
Verify before relying
pip install sqlalchemy-utils
from sqlalchemy_utils import URLType, EmailType
from sqlalchemy import Column, String, create_engine
from sqlalchemy.orm import declarative_base
Base = declarative_base()
class User(Base):
__tablename__ = 'users'
id = Column(Integer, primary_key=True)
email = Column(EmailType)
website = Column(URLType)- Specific list of utility functions, data types, and helpers provided beyond the summary
- Whether custom data types require database-specific implementations or work across all SQLAlchemy-supported databases
- Performance characteristics when used with large datasets or complex validation chains
What it is and what it does
SQLAlchemy-Utils is a collection of utility functions and custom column types that fill gaps in SQLAlchemy's standard library. It provides pre-built solutions for common database modeling patterns—such as email validation, URL types, JSON handling, and UUID columns—without requiring you to implement them from scratch. The package acts as a convenience layer on top of SQLAlchemy, reducing boilerplate in model definitions and adding validation helpers that integrate cleanly with SQLAlchemy's declarative ORM.
The package is designed for developers building web applications and data-driven systems who want to avoid reinventing common patterns. It supports modern Python versions (3.9 through 3.13) and has maintained active development since 2013, making it a stable choice for production use. Installation is straightforward with only SQLAlchemy as a dependency.
Use it for
- Add email and URL validation to model columns without writing custom validators
- Use pre-built JSON, UUID, and other specialized column types in ORM models
- Implement common database patterns (like soft deletes or audit timestamps) with minimal code
- Build form-friendly model helpers that integrate with web frameworks
- Add database-level constraints and validation helpers to reduce application-level checks
Worth the install?
AI-flagged interpretation of the facts on this page. Verify before relying on it.
Yes.
The package is actively maintained, has no known vulnerabilities, installs with minimal friction, and is widely used (top 1000 on PyPI). It's worth installing if you're building SQLAlchemy models and want to reduce boilerplate for common patterns like email validation, URL types, or other utility functions—but only if those specific utilities align with your project's needs.
Install
sqlalchemy-utils on PyPI
Before you install
Low friction install with a single runtime dependency on SQLAlchemy. The package is actively maintained with a recent commit on 2026-07-08 and has been in development since 2013-03-01, indicating stable, long-term support.
Requires SQLAlchemy as a runtime dependency; minimum Python version is 3.9.
License in practice
Licensed under BSD-3-Clause (permissive), allowing use in commercial and proprietary projects with minimal restrictions beyond attribution and liability disclaimers.
Quickstart
pip install sqlalchemy-utils
from sqlalchemy_utils import URLType, EmailType
from sqlalchemy import Column, String, create_engine
from sqlalchemy.orm import declarative_base
Base = declarative_base()
class User(Base):
__tablename__ = 'users'
id = Column(Integer, primary_key=True)
email = Column(EmailType)
website = Column(URLType)Verify before relying
- Specific list of utility functions, data types, and helpers provided beyond the summary
- Whether custom data types require database-specific implementations or work across all SQLAlchemy-supported databases
- Performance characteristics when used with large datasets or complex validation chains
Package facts
| License | BSD-3-Clause permissive |
| Python support | Supports the current Python release >=3.9 |
| Install friction | Low. Pure-Python wheel |
| Runtime dependencies | 1 packageSQLAlchemy |
| Maintenance | Actively maintained 244 days since the last release |
| Last repo commit | |
| First released | |
| Downloads | 29,307,657 / month, #819 on PyPI 30-day window, as of 2026-08-14 |
| Known vulnerabilities | None known OSV.dev, checked 2026-08-14 |
| Classifiers | Environment :: Web EnvironmentIntended Audience :: DevelopersOperating System :: OS IndependentProgramming Language :: PythonProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.9Topic :: Internet :: WWW/HTTP :: Dynamic ContentTopic :: Software Development :: Libraries :: Python Modules |
Evidence: sqlalchemy_utils-0.42.1-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 utilities and helpers”
- SQLAlchemy-UtilsProvides utility functions, custom data types, and helpers that…
- sqlbagsqlbag provides a collection of SQLAlchemy utilities and helpers for…
- alchemy-mockProvides mock helpers for SQLAlchemy sessions and expression matchers…
Give your agent the search over MCP, or paste the wish link into any chat.
More Python Modules packages
Converts domain names between Unicode and ASCII-compatible encoding (Punycode) according to IDNA 2008 and Unicode Technical Standard 46, with security validation and broader script coverage than the standard library.
Install it if you work with internationalized domain names, need to validate domains, or use HTTP clients that depend on it transitively.
Setuptools is a Python build backend and package management tool that handles building, distributing, and installing Python packages, including support for C/C++ extension modules.
PyYAML parses and emits YAML 1.1 data format, enabling serialization and deserialization of configuration files and Python objects to and from human-readable YAML text.
Pydantic validates Python data structures against type hints, coercing and checking input at runtime to ensure it matches a declared schema.
Provides reusable metadata objects for use with PEP-593 `typing.Annotated` to express common constraints like bounds, collection sizes, and predicates on types.
Install it if you use or build libraries that need to express type constraints in a standardized, inspectable way—or if you want to annotate your own types with…
Provides runtime tools to inspect and introspect Python type annotations, enabling programmatic examination of type hints at execution time.
See also sqlalchemy-searchable · types-sqlalchemy-utils · msbench-utils · Flask-SQLAlchemy · sqlbag · WTForms-Alchemy · nr-util · types-SQLAlchemy · WTForms-SQLAlchemy · banal