Query Builder Python Packages

piccolo

A fast, user friendly ORM and query builder which supports asyncio.

graphql-query

Complete Domain Specific Language (DSL) for GraphQL query in Python.

gqlalchemy

GQLAlchemy is a library developed with the purpose of assisting in writing and running queries on Memgraph. GQLAlchemy supports high-level connection to Memgraph as well as modular query builder.

sqeleton

A python library for efficiently interacting and querying SQL databases

prometheus-query-builder

Package for generation Prometheus Query Language queries.

yara-orm

Fast async Python ORM with a Rust engine — Tortoise-style models, querysets, relations and migrations for PostgreSQL, MySQL and SQLite. A faster, fully-typed alternative to Tortoise ORM and async SQLAlchemy.

path-dict

Easily query and modify Python dicts!

python-cypher

Python Cypher Querybuilder

aura-connector

Async-native, type-safe Python client and connector for AuraDB: typed models, an injection-safe query builder, first-class vector fields, a deterministic binary protocol, migrations, observability, and optional native acceleration.

david8

david8 is lightweight Python SQL builder

odsbox-pilot

A desktop query tool for ASAM ODS servers, built on top of odsbox.

ryx

Ryx gives you the ergonomic query API of Django's ORM while running SQL execution through a compiled Rust core — giving you async-native, high-performance database access with a familiar Python interface.

sql-mongo-converter

🛠️ SQLMongo - A PyPI package for converting SQL queries to MongoDB queries and vice versa. Effortlessly translate between relational and NoSQL query formats for seamless database interoperability.

gql-query-builder

This is a GraphQL query builder.

david8-clickhouse

david8 ClickHouse dialect

zillion

Make sense of it all. Semantic data modeling and analytics with a sprinkle of AI. https://totalhack.github.io/zillion/

mongo-queries-manager

Convert query parameters from API urls to MongoDB queries !

pykusto

Query Kusto like a pro from the comfort of your Jupyter notebook

fastapi-sa-orm-filter

Package that helps to implement easy objects filtering and sorting based on URL query parameters.

david8-duckdb

david8 duckdb dialect

pypromql

PyPromql is a Python library that simplifies the creation and execution of PromQL queries.

database-mcp

A server that helps people access and query data in databases using the Legion Query Runner with Model Context Protocol (MCP) in Python.

estoult

Python data mapper and query builder for SQL databases.

duckql

JSON declarative SQL conversion library