Repository files navigation

A curated list of awesome extra libraries and resources forSQLAlchemy. Inspired byawesome-python. (See also otherawesome lists!)

Licensed under aCreative Commons Attribution-ShareAlike 4.0 InternationalLicense.

SQLAlchemy-Continuum

Versioning and auditing extension for SQLAlchemy.

• Creates versions for inserts, deletes and updates.
• Does not store updates which don't change anything.
• Supports alembic migrations.
• Can revert objects data as well as all object relations at giventransaction even if the object was deleted.
• Transactions can be queried afterwards using SQLAlchemy query syntax.
• Query for changed records at given transaction.
• Temporal relationship reflection. Version object's relationship showthe parent objects relationships as they where in that point in time.
• Supports native versioning for PostgreSQL database (trigger basedversioning).

sqlalchemy_mptt

Library for implementing MPTT (modified preorder tree traversal) withSQLAlchemy models and working with trees of model instances,likedjango-mptt.

SQLAlchemy-ORM-tree

An implementation for SQLAlchemy-based applications ofthe nested-sets/modified-pre-order-tree-traversal technique forstoring hierarchical data in a relational database.

vdm

Versioned domain model. Python library for revisioning/versioning of databases.

SQLAlchemy-Enum34

SQLAlchemy type to store standardenum.Enum values.

SQLAlchemy-Utc

SQLAlchemy type to store awaredatetime.datetime values.

SQLAlchemy-Utils

Various utility functions, new data types and helpers for SQLAlchemy

• Listeners
• Data types: {..., ChoiceType, CountryType, JSONType, URLType, UUIDType, ...}
• Range data types
• Aggregated attributes
• Generates decorator
• Generic relationships
• Database helpers: create_database, drop_database
• Foreign key helpers
• ORM helpers
• Utility classes
• Model mixins: Timestamp (created, updated times)

Alembic

Alembic is a lightweight database migration tool for usage with theSQLAlchemy Database Toolkit for Python.

sqlalchemy-migrate

Inspired by Ruby on Rails' migrations, SQLAlchemy Migrate providesa way to deal with database schema changes in SQLAlchemy projects.

https://docs.sqlalchemy.org/en/latest/dialects/

redshift_sqlalchemy

Amazon Redshift dialect for SQLAlchemy.

sphinxalchemy

SQLAlchemy dialect for interfacing withSphinx (search engine) viaSphinxQL.

GINO

An asynchronous PostgreSQL dialect forasyncpg, providing SQLAlchemycore support and its own asynchronous ORM interface.

• https://docs.sqlalchemy.org/en/latest/
• https://docs.sqlalchemy.org/en/latest/intro.html
• https://docs.sqlalchemy.org/en/latest/core/tutorial.html
• https://docs.sqlalchemy.org/en/latest/orm/tutorial.html
• https://docs.sqlalchemy.org/en/latest/glossary.html

filedepot

DEPOT is a framework for easily storing and serving files in webapplications. Depot features simple integration with SQLAlchemy by providingcustomized model field types for storing files attached to your ORMdocument.

SQLAlchemy-ImageAttach

SQLAlchemy-ImageAttach is a SQLAlchemy extension for attaching imagesto entity objects.

sqlalchemy-media

Based on SQLAlchemy-ImageAttach but using JSON type instead of relation,and SqlAlchemy's mutable facility, Also supports multiple stores per context.

ColanderAlchemy

ColanderAlchemy helps you to auto-generateColander schemas that are basedon SQLAlchemy mapped classes.

Such Colander schemas can be used with libraries likeDeform and helpsremove the need for duplication of schema definitions.

Flask-Validator

Data validator for Flask and SQL-Alchemy, working at Model componentwith events, preventing invalid data in the columns.The extension works with event listeners from SQLAlchemy.

FormAlchemy

FormAlchemy eliminates boilerplate by autogenerating HTML input fields from agiven model. FormAlchemy will try to figure out what kind of HTML code shouldbe returned by introspecting the model's properties and generate ready-to-useHTML code that will fit the developer's application.

WTForms-Alchemy

WTForms-Alchemy is aWTForms extension toolkit for easier creation ofmodel based forms. Strongly influenced by Django ModelForm.

Sprox

Sprox provides an easy way to create forms for web content which are:automatically generated, easy to customize, and validated. Sprox alsohas powerful tools to help you display your content the way you wantto with table and record viewers. Sprox provides a way to fill yourwidgets, whether they are forms or other content with customizable data.

SQLAlchemy-Searchable

Full-text searchable models for SQLAlchemy. Only supports PostgreSQL.

SQLAlchemy-FullText-Search

Fulltext search support with MySQL & SQLAlchemy.

GeoAlchemy

GeoAlchemy provides extensions to SQLAlchemy to work with spatial databases.

The current supported spatial database systems arePostGIS,Spatialite,MySQL, Oracle, and MS SQL Server 2008.

GeoAlchemy 2

GeoAlchemy 2 provides extensions to SQLAlchemy for working withspatial databases.

GeoAlchemy 2 focuses onPostGIS. PostGIS 1.5 and PostGIS 2 are supported.Spatialite is also supported, but using GeoAlchemy 2 with Spatialiterequires some specific configuration on the application side.

GeoAlchemy 2 aims to be simpler than its predecessor,GeoAlchemy.Simpler to use, and simpler to maintain.

SQLAlchemy-i18n

Internationalization extension for SQLAlchemy models.

• Stores translations in separate tables.
• Reflects translation table structures based onparent model table structure.
• Supports forcing of given locale.
• Good performance (uses proxy dicts and other advanced SQLAlchemyconcepts for performance optimization).

flask_debugtoolbar

Debug toolbar with SQLAlchemy query information for Flask.

pyramid_debugtoolbar

Debug toolbar with SQLAlchemy query information for Pyramid.

SQLTap

SQLTap is a library that allows you to profile and introspect the queriesthat your application makes using SQLAlchemy.

SQLTap helps you understand:

• how many times a sql query is executed
• how much time your sql queries take
• where your application is issuing sql queries from

nplusone

Auto-detect the n+1 queries problem in SQLAlchemy (and other Python ORMs)

nplusone detects unnecessary queries caused by lazy loading and unused eager loading.Integrates with Flask-SQLAlchemy.

sqlakeyset

This library implements keyset-based paging for SQLAlchemy (both ORM and core).

This library has been tested with PostgreSQL and MariaDB/MySQL.It should work with other SQLAlchemy-supported databases to provided they supportrow( syntax.

• https://github.com/sqlalchemy/sqlalchemy/wiki/UsageRecipes

marshmallow-sqlalchemy

SQLAlchemy integration with themarshmallow (de)serialization library.

pydantic

Data parsing and validation using Python type hints

sqlalchemy-dict

SQLAlchemy extension for interacting models with python dictionary.

charlatan

Fixtures management for SQLAlchemy and other systems.

factory_boy

Generate fake data and create random fixtures for testing in SQLAlchemyand many other Python ORM systems.

mixer

Generate fake data and create random fixtures for testing in SQLAlchemyand many other Python ORM systems.

Dataset

Easy-to-use data handling for SQL data stores in Python with support forimplicit table creation, bulk loading, and transaction. Dataset alsoincludes support for freezing data to CSV and JSON flat files.

rdflib-sqlalchemy

RDFLib store using SQLAlchemy dbapi as back-end.

PugSQL

Loading and execution of parameterized queries stored in files.

SQLSoup

SQLSoup provides a convenient way to map Python objects torelational database tables, with no declarative code of any kind.It's built on top of the SQLAlchemy ORM and provides a super-minimalisticinterface to an existing database.

SQLModel

SQLModel is a library for interacting with SQL databases from Python code, with Python objects.It is designed to be intuitive, easy to use, highly compatible, and robust. SQLModel is basedon Python type annotations, and powered by Pydantic and SQLAlchemy.

Zillion

Zillion is a free, open data warehousing and dimensional modeling tool thatallows combining and analyzing data from multiple datasources through asimple API. It writes SQL so you don't have to, and it easily bolts ontoexisting database infrastructure via SQLAlchemy.

Flask-SQLAlchemy-PGEvents

Flask extension that uses SQLAlchemy andpsycopg2-pgevents toenable event listeners tied into database-layer triggers.

sqlalchemy-crosstab-postgresql

New grammar for SQLAlchemy to make handling thecrosstab() tablefunc(i.e. pivot tables) in PostgreSQL easy peasy.

sqlalchemy-postgres-copy

Wrapper for using PostgreSQL COPY with SQLAlchemy for efficient bulk dataimports and exports.

sadisplay

Simple package for describing SQLAlchemy schema and display raw database tables by reflecting feature.

sqlalchemy_schemadisplay

This module generates images from SQLAlchemy models.

eralchemy

ERAlchemy generates Entity Relation (ER) diagram from databases or from SQLAlchemy models.

paracelsus

CLI and Library that generates Mermaid and DOT Diagrams from SQLAlchemy models and injects them into documentation.

bottle-sqlalchemy

ABottle plugin to manage SQLAlchemy session to your application.

filteralchemy

Declarative query builder that auto-generates filter parameters frommodels and parses request parameters usingmarshmallow-sqlalchemyandwebargs.

Flask-SQLAlchemy

Flask-SQLAlchemy is an extension forFlask that adds support forSQLAlchemy to your application.

Flask-Admin

The admin interface framework forFlask.With scaffolding for SQLAlchemy, MongoEngine, pymongo and Peewee.

pyramid_sqlalchemy

pyramid_sqlalchemy provides everything needed to use SQLAlchemy inPyramid applications.

pyramid_restler

pyramid_restler is a somewhat-opinionated toolkit for buildingRESTful Web services and applications on top of thePyramid framework (with SQLAlchemy models).

sacrud

SACRUD will solve your problem of CRUD interface for SQLAlchemy,by providing extension forPyramid (yet) or use it in pure form.Unlike classical CRUD interface,pyramid_sacrud allows override andflexibly customize interface (that is closer todjango.contrib.admin).

SQLA-wrapper

A light and framework-independent wrapper for SQLAlchemy that makesit really easy to setup and use.

• Doesn't change the SQLAlchemy syntax.
• Can paginate the results of the queries.
• Support for multiple databases at the same time.

zope.sqlalchemy

The aim of this package is to unify the plethora of existing packagesintegrating SQLAlchemy withZope's transaction management.As such it seeks only to provide a data manager and makes no attemptto define a zopeish way to configure engines.

paginate_sqlalchemy

This module helps dividing large lists of items into pages.The user is shown one page at a time and can navigate to other pages.

sandman2

Generate a curl-able REST HTTP API with searching and filteringfor all tables in a database and an admin UI with Flask-SQLAlchemyand HTTP Basic Authentication.

sqlalchemy_mixins

A set of well-tested mixins that brings Active Record, Django-like queries, nested eager load and beauty __repr__ to your SQLAlchemy.