Packages
Reads an existing database schema and generates SQLAlchemy model code automatically, supporting multiple output formats including declarative classes, dataclasses, and SQLModel.
Generates a web-based admin interface for SQLAlchemy models, integrating with Starlette to provide CRUD operations, filtering, and model management without writing custom views.
Install it if you need a functional admin interface for SQLAlchemy models in Starlette without building custom views.
Implements keyset-based paging for SQLAlchemy queries, replacing offset-based pagination to avoid performance degradation and result skipping on large datasets.
SQLAlchemy is a Python SQL toolkit and Object Relational Mapper (ORM) that provides both a high-level ORM layer for declarative object persistence and a Core SQL construction system for direct database abstraction and query building.
Bridges PyCasbin access-control policies with SQLAlchemy-supported databases, enabling policy persistence and retrieval across PostgreSQL, MySQL, SQLite, Oracle, SQL Server, Firebird, and Sybase.
It is a straightforward adapter with a narrow, well-defined scope—use it when pycasbin and SQLAlchemy are your architecture; do not install it if you are not already…
Provides a SQLAlchemy dialect for accessing PostgreSQL and MySQL databases via AWS Aurora Serverless Data API, enabling HTTP-based database access without managing TCP connections.
However, dormant maintenance (last release 958 days ago) means you should verify compatibility with your SQLAlchemy version and test thoroughly before production use,…
SQLAlchemy dialect that enables you to use BigQuery as a database backend through SQLAlchemy's ORM and query interface.
Install it if you need to access BigQuery through SQLAlchemy's ORM or query interface.
Provides a SQLAlchemy-backed scheduler for Celery that stores periodic task definitions in a relational database instead of configuration files, allowing dynamic task scheduling without restarting the beat process.
However, verify compatibility with your specific celery and sqlalchemy versions before production use, and monitor the repository for updates given the aging…
A SQLAlchemy dialect that enables ORM and SQL toolkit access to CockroachDB databases, supporting both synchronous and asynchronous connections through multiple database drivers.
SQLAlchemy-Continuum adds automatic versioning and auditing to SQLAlchemy models, tracking all inserts, updates, and deletes with the ability to query and revert changes at any point in time.
Provides a SQLAlchemy dialect that connects to Databricks workspaces and SQL analytics clusters using the official databricks-sql-connector driver.
Compares database schemas across two SQLAlchemy-connected databases, reporting structural differences in tables, columns, keys, indexes, constraints, and enums.
Provides a SQLAlchemy dialect to query Dremio data warehouses via Flight and ODBC interfaces, enabling SQL-based access to Dremio within Python applications.
SQLAlchemy dialect for Apache Drill that enables SQL queries against Drill data sources via REST, JDBC, or ODBC connections.
Adds soft-deletion support to SQLAlchemy models with automatic query filtering and customizable mixin generation.
SQLAlchemy dialect that enables Python applications to connect to and query Exasol databases using SQLAlchemy's ORM and Core APIs via WebSocket.
Install it if you are building or migrating an application to Exasol and want SQLAlchemy integration.
Adds filtering, sorting, and pagination capabilities to SQLAlchemy query objects via declarative specifications, designed for REST API exposure.
However, accept that maintenance is dormant: no updates since April 2023, and compatibility with newer SQLAlchemy versions is unverified.
Provides a SQLAlchemy 2.0+ dialect for connecting to and querying Firebird 3.0+ databases using the firebird-driver DB-API 2.0 driver.
Provides a SQLAlchemy dialect that enables you to use SAP HANA as a database backend, translating SQLAlchemy ORM and SQL expressions into HANA-compatible SQL via the hdbcli driver.
Provides a SQLAlchemy dialect to connect to Db2 on IBM i systems using ODBC, enabling ORM and SQL query construction against IBM i databases.
SQLAlchemy dialect for JDBC and ODBC database connections with support for PostgreSQL, Oracle, MySQL, MariaDB, SQL Server, DB2, SQLite, OceanBase, GBase 8s, IBM iSeries, MS Access, and Apache Phoenix.
However, maintenance is aging (268 days since last release), and the description explicitly requests community testing feedback, indicating some dialects may not be…
Provides mutation-tracked JSON column types for SQLAlchemy that detect and persist changes to JSON data at the top level or nested within objects and arrays.
However, maintenance is dormant—last release was over two years ago—so verify compatibility with your specific SQLAlchemy and Python versions before adopting it in…
Provides a SQLAlchemy column type for storing dictionaries as JSON, with automatic fallback to text encoding for databases that lack native JSON support.
Simplifies SQLAlchemy code with helper functions for credential management, bulk insert/update/upsert operations, and ORM extensions that reduce boilerplate.
Provides database schema migration management for SQLAlchemy projects, enabling version-controlled changesets and command-line tools to track and apply database schema changes.
Provides Active Record-style mixins for SQLAlchemy ORM, enabling Django-like query syntax, eager loading, and CRUD operations on model classes.
Provides a SQLAlchemy dialect that enables connections to PGSpider using SQLAlchemy's PostgreSQL interface and psycopg2 driver.
Install only if you are locked into an old environment and PGSpider is a hard requirement; otherwise, seek an actively maintained alternative or contact the PGSpider…
Provides a SQLAlchemy dialect for connecting to Microsoft SQL Server via the TDS protocol using python-tds as the underlying driver.
Provides SQLAlchemy dialects for connecting to Amazon RDS PostgreSQL instances using IAM authentication instead of passwords, with support for both psycopg2 and asyncpg drivers.
However, verify that it remains compatible with your SQLAlchemy, psycopg2/asyncpg, and boto3 versions before deploying to production.
Provides a SQLAlchemy dialect for Amazon Redshift, enabling ORM and SQL expression language support against Redshift clusters via psycopg2 or redshift_connector.
Adds automatic, human-readable repr() output to SQLAlchemy model instances by providing mixin base classes that format column data for display.
Provides a SQLAlchemy dialect that enables Python applications to connect to and query RisingWave, a cloud-native streaming database, using SQLAlchemy's standard ORM and query APIs.
However, understand that RisingWave's streaming semantics diverge significantly from PostgreSQL OLTP assumptions—read the documentation on read-after-write visibility…
Generates entity-relationship and UML diagrams from SQLAlchemy ORM models and database schemas, outputting them as image files via Graphviz.
Adds fulltext search capabilities to SQLAlchemy models using PostgreSQL's native search features.
Adds a `.to_dict()` method to SQLAlchemy model instances, converting them to dictionaries with support for nested relationships, custom field rules, and timezone handling.
Install it if you want to avoid the boilerplate of schema libraries for straightforward serialization tasks.
Provides a SQLAlchemy dialect that allows you to query Apache Solr collections using standard SQL syntax and SQLAlchemy ORM patterns.
However, the aging maintenance status (no recent commits, last release August 2024) means you should verify compatibility with your specific Solr and SQLAlchemy…
Provides a SQLAlchemy dialect that enables applications to use SQLAlchemy's ORM and query API against Google Cloud Spanner databases.
Provides type stubs and a mypy plugin to enable static type checking of SQLAlchemy code, helping type checkers understand SQLAlchemy's dynamic features.
Provides a SQLAlchemy dialect for connecting to and querying Trino databases, enabling ORM and SQL expression support for Trino as a backend.
Provides a SQLAlchemy DateTime type that consistently handles timezone-aware datetimes across database vendors, storing all values in UTC and returning aware datetime objects regardless of whether the underlying database supports native timezone types.
However, it is abandoned (last commit August 2022, no activity for nearly four years) and only explicitly supports Python up to 3.9.