Query Optimization Python Packages

uqa

Embeddable Rust query engine unifying relational, full-text, vector, graph, and probabilistic retrieval under one typed algebra.

pycanopy

A high-performance spatial query layer for Polars

anumana-mcp

Query-cost foresight for AI agents across 12 database engines — preflight SQL/NoSQL/graph/warehouse/vector queries before you run them (MCP server).

delta-explain

CLI diagnostic tool showing step-by-step how Delta Lake prunes files given a predicate

indexwright

Read-only performance advisor for self-hosted MongoDB: slow query shapes, ESR index recommendations, unused and redundant indexes. The Atlas Performance Advisor, for your own servers.

dataxplan-mcp

Read PostgreSQL EXPLAIN plans for AI agents: bottlenecks, estimation errors, fixes, charts.

django-index-optimizer

A workload-driven PostgreSQL Index Advisor for Django. Find missing indexes and generate safe, reviewable recommendations.

django-fetch-guard

Prevent accidental Django ORM queries with strict fetch contracts, automatic N+1 batching, DRF integration, and support for Django 4.2–6.1.

dataxplan

Read PostgreSQL EXPLAIN plans locally: parse, compute self time and estimation error, flag documented problems, compare plans, and guard them in CI. No database connection, deterministic.

samkhya

Engine-agnostic Rust SDK for portable, feedback-driven cardinality correction in embedded analytical engines: DataFusion, DuckDB, Polars, Postgres, Iceberg, Arrow, GPU, Python. One Corrector trait — GBT, TabPFN-2.5, LLM. LpJoinBound never-regress clamp. Apache-2.0.

chqce

Estimate the cost of a ClickHouse SQL query before you run it — timing, rows/bytes scanned, and skip-index suggestions, right in your terminal.

query-normalizer

Modern Python library for search-query normalization with bilingual support (Russian/English).

libsqlglot

126× faster sqlglot in C++. Parses, transpiles and optimises 40+ SQL dialects. Supports stored procedures. Python bindings available.