Database
dbt enables data analysts and engineers to transform their data using the same practices that software engineers use to build applications.
A fast, user friendly ORM and query builder which supports asyncio.
python async orm with fastapi in mind and pydantic validation
PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially…
A database migrations tool for SQLAlchemy.
ClickHouse® is a real-time analytics database management system
QuestDB is a high performance, open-source, time-series database
High-performance, low-footprint SQL database written in C++. Process millions of rows per second from Kafka, Pulsar, or ClickHouse, and seamlessly write results back. Supports powerful features lik…
SQLAlchemy 2.0+ wrapper that simplifies its use in Python applications. Can be used on its own or alongside Flask, FastAPI or other web frameworks.
Streamlit example project with SQLAlchemy 2.0 Database ORM
A curated list of awesome tools for SQLAlchemy
Automatically turn your SQLalchemy Data Models into a Nice SVG Diagram
libSQL is a fork of SQLite that is both Open Source, and Open Contributions.
A time-series database for high-performance real-time analytics packaged as a Postgres extension
Python client for QuestDB InfluxDB Line Protocol
CrateDB is a distributed and scalable SQL database for storing and analyzing massive amounts of data in near real-time, even with complex queries. It is PostgreSQL-compatible, and based on Lucene.
Python DB API client library for CrateDB, using HTTP.
Grafana Pandas Datasource - using Python for generating timeseries-, table-data and annotations
DuckDB Wasm Datasource Plugin
Python module that provides a simple and convenient way to interact with InfluxDB 3.0.
Community InfluxDB 3.0 "IOx" static builds + containers + Examples for Developers & Integrators. Experiment with low-cost storage, unlimited cardinality and FlightSQL APIs
Scalable datastore for metrics, events, and real-time analytics
SQLAchemy and Apache Superset extensions for QuestDB
Fastest library to load data from DB to DataFrames in Rust and Python