Packages
Provides utility functions, custom data types, and helpers that extend SQLAlchemy's core functionality for common database modeling and validation tasks.
Provides a SQLAlchemy dialect for Vertica, enabling SQLAlchemy applications to connect to and query Vertica databases using standard SQLAlchemy ORM and SQL expression APIs.
Provides a SQLAlchemy dialect for Vertica using the pure-Python vertica-python driver, enabling ORM and SQL expression language access to Vertica databases.
Adds CreateView and DropView SQL constructs to SQLAlchemy, enabling programmatic creation and removal of database views through SQLAlchemy's expression language.
Provides PEP-484 typing stubs for SQLAlchemy 1.4, enabling static type checking with mypy and other type checkers.
However, this is a legacy package: it is dormant, explicitly incompatible with SQLAlchemy 2.0, and must be manually uninstalled before upgrading.
sqlbag provides a collection of SQLAlchemy utilities and helpers for common database tasks, including connection management, Flask integration, ORM helpers, and temporary database setup for testing.
No—not recommended for new projects.
sqlcipher3 is a Python DB-API 2.0 interface to SQLCipher, providing encrypted SQLite database access with features like user-defined window functions, incremental BLOB I/O, and native backup support.
A Python DB-API 2.0 interface to SQLCipher, providing encrypted SQLite database access with a self-contained binary wheel requiring no external dependencies.
However, verify platform support matches your target (wheels shown are Linux x86_64 only), and note the package is aging—last release was 226 days ago.
Provides a Python DB-API 2.0 interface to SQLCipher, enabling encrypted SQLite database operations with a familiar sqlite3-like API.
However, the aging maintenance status (219 days since last release, 34 stars) suggests evaluating alternatives for new projects.
A drop-in replacement for Python's sqlite3 module that bundles sqlean extensions, adding cryptography, fuzzy matching, statistics, regex, file I/O, and other SQL functions directly into SQLite.
However, the abandoned repository status means you should not rely on it for long-term production systems expecting active maintenance or future Python compatibility…
SQLFluff is a SQL linter and auto-fixer that checks SQL code for style and formatting issues across multiple SQL dialects, with support for Jinja templating and dbt.
Install it if you work with SQL across multiple dialects, use dbt, or want to enforce team SQL style standards.
Enables SQLFluff to lint and auto-fix dbt project SQL using dbt templating, integrating dbt-core and Jinja2 template processing into SQLFluff's multi-dialect SQL linting workflow.
SQLFluff-rs is a Rust-based optional component that integrates with a SQL linting package to accelerate certain operations; it is not a standalone linter and requires the main package to function.
SQLGlot parses, transpiles, optimizes, and analyzes SQL across over 30 dialects without external dependencies, enabling format conversion and semantic analysis of queries.
Provides mypyc-compiled C extensions that accelerate sqlglot's SQL parsing, transpilation, and analysis operations by roughly 3-5x compared to the pure Python version.
A SQL parser, transpiler, and optimizer that converts SQL between over 30 dialects with no runtime dependencies.
However, the package summary marks it as deprecated in favor of sqlglotc—verify whether that migration is necessary for your use case before committing.
Provides an asynchronous client for SQLite that works with any async framework via AnyIO, enabling non-blocking database access without thread pools.
Registers custom SQLite functions for ranking and analyzing FTS4 full-text search results, including BM25 scoring, TF-IDF ranking, and matchinfo decoding.
However, the package is abandoned (last update 2022-07-30) and has no active maintenance, so expect no updates for bugs or compatibility issues with future Python…
A compatibility shim that re-exports the Migrations class from sqlite-utils so existing code can continue importing from sqlite_migrate instead of directly from sqlite-utils.
CLI tool and Python library for creating, querying, and transforming SQLite databases from JSON, CSV, or TSV data, with built-in full-text search and schema migration support.
sqlite-vec adds vector search capabilities to SQLite, enabling similarity queries and vector operations directly within SQLite databases.
Provides a dict-like interface to SQLite databases, allowing you to store and retrieve Python objects persistently with multi-threaded access support.
SQLLineage parses SQL statements to extract and visualize data lineage—identifying source tables, target tables, and intermediate tables involved in data transformations.
SQLMesh is a data transformation framework that lets you write, test, and deploy SQL or Python transformations with built-in change tracking, incremental processing, and virtual development environments.
SQLModel combines SQLAlchemy and Pydantic to let you define SQL database tables and rows as Python classes with type annotations, eliminating code duplication between ORM models and data validators.
sqloxide parses SQL queries into a typed abstract syntax tree (AST) using Rust bindings for sqlparser-rs, and can reconstruct or rewrite SQL from the AST.
Install it if you need fast, accurate SQL parsing for lineage, rewriting, or analysis; skip it only if you need extensive documentation or are locked to older Python…
Converts SQL queries between different parameter styles (named, ordinal, numeric, and dollar-sign variants) to match what your database driver supports.
Install it if you need to bridge parameter style mismatches between your code and your database driver.
sqlparse tokenizes SQL text into a tree of statements, clauses, and expressions, and provides functions to split scripts, format queries, and inspect parsed tokens without validating dialect or syntax.
Install it if you need to manipulate, format, or analyze SQL text programmatically.
sqltap hooks into SQLAlchemy to collect and report metrics on SQL queries—execution counts, timing, and call sites—helping you identify performance problems in ORM-heavy applications.
SQLTrie implements a prefix tree (trie) data structure backed by SQL, combining trie search capabilities with persistent database storage.
Formats, validates, and checks SQL SELECT statements for syntactic and semantic correctness, with command-line and Python API interfaces.
Provides a Python client library for accessing the Square API, enabling payment processing, customer management, and business operations through synchronous and asynchronous interfaces.
Install it if you need to integrate Square payments or business operations into a Python application.
Computes treemap layout rectangles from a list of values using the squarified algorithm, suitable for visualizing hierarchical data as nested rectangles.
Linter that analyzes PostgreSQL migrations and SQL statements to detect patterns that risk downtime, lock contention, or schema problems, and suggests corrections.
Implements the Secure Remote Password (SRP) protocol for password-based mutual authentication over insecure networks without relying on external certificate infrastructure.
However, dormant maintenance (no releases in 651 days) means security updates or bug fixes may be slow; evaluate whether the protocol itself and this implementation…
Implements Secure Remote Password (SRP) protocol for password-authenticated key agreement, providing both programmatic API and command-line tools for client-server authentication without transmitting passwords.
However, note that the latest release was in 2020 and Python 2 support is included; verify that the supported Python versions and any cryptographic assumptions align…
srsly provides a unified API for serializing and deserializing data across JSON, JSONL, MessagePack, Pickle, and YAML formats, bundling multiple serialization libraries into a single binary wheel to simplify cross-platform and cross-Python compatibility.
Parse, modify, and compose SRT subtitle files with support for broken or malformed files and Asian-style formats.
Analyzes and displays the structure of ONNX models, including those too large for graphical tools like Netron, reporting operation counts and model size.
However, dormant maintenance (last update over 1055 days ago) means you should verify compatibility with your ONNX opset version before relying on it in production…
Provides Server-Sent Events streaming for Starlette and FastAPI applications, following the W3C SSE specification with async/await support and automatic client disconnect detection.
Install it if you need to add real-time event streaming to a Starlette or FastAPI application and want standards-compliant SSE without building the plumbing yourself.