Adaptive query optimization for PostgreSQL
-
Updated
Jun 27, 2026 - C
Adaptive query optimization for PostgreSQL
PilotScope is a middleware to bridge the gaps of deploying AI4DB (Artificial Intelligence for Databases) algorithms into actual database systems.
A playground for experimenting ideas that may apply to Spark SQL/Catalyst
Slides and material for MySQL and MariaDB query optimization.
A Relational Optimizer and Executor
build your own query planner
100+ data engineering projects from scratch — streaming, CDC, table formats, query engines, consensus, governance. 2,500+ tests, mypy strict.
Run the PostgreSQL Explain Visualizer 2 (pev2) from the command line.
Laravel package helps you to execute more effective databases queries, delete, update, insert, and optimize your database queries.
The codebase for DBSim
Open source Snowflake cost proxy. Verified caching, suspend, rewrites, attribution, and signed savings evidence.
🔄 PostgreSQL MCP Server – AI-Powered PostgreSQL Management & Monitoring. A powerful, AI-integrated PostgreSQL Model Context Protocol (MCP) server for automated database operations, monitoring, security, diagnostics, and optimization. Seamlessly manage PostgreSQL with 237+ tools designed for AI assistants like Claude and ChatGPT.
pg_orca is a PostgreSQL extension of the ORCA query optimizer — a Cascades-style, cost-based optimizer extension.
Use JSON objects to generate PostgreSQL WHERE clause expressions.
Homework for Query Optimization - a TUM Computer Science Course
A custom relational SQL database engine built from scratch in C++17 — TCP server, REST API, replication, full-text search, window functions, triggers
A dataframe library for Go (Golang), modelled on Polars: lazy queries with a query optimizer, Apache Arrow memory, SIMD kernels and out-of-core execution that spills to disk. Pure Go, no cgo.
Cost-based advisor for filtered vector search in PostgreSQL and pgvector
Local-first Big Data query diagnostics for Apache Impala triage and bounded local Trino support, with raw-data-safe reports and read-only optimizer guidance.
A tiny SQL query engine that runs SELECT queries directly over CSV and Parquet files — pure-Python, no database, no server. Hand-written tokenizer and recursive-descent parser feed a Volcano-model execution engine (the architecture behind DuckDB and DataFusion).
To associate your repository with the query-optimizer topic, visit your repo's landing page and select "manage topics."