Adaptive query optimization for PostgreSQL
-
Updated
May 17, 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
Use JSON objects to generate PostgreSQL WHERE clause expressions.
Homework for Query Optimization - a TUM Computer Science Course
🔄 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 port of the ORCA query optimizer — a Cascades-style, cost-based optimizer extension.
A custom relational SQL database engine built from scratch in C++17 — TCP server, REST API, replication, full-text search, window functions, triggers
A minimal educational relational database management system (RDBMS) implemented in Java 17. The project demonstrates a custom SQL processing pipeline, including lexer, parser, semantic analysis, query planning, optimization, and execution. It features a storage engine with heap pages, a buffer pool, and supports indexing using B-trees and Hash
Local-first Apache Impala query diagnostics for production triage, with raw-data-safe reports and read-only optimizer guidance.
Database Systems Implementation @ NUS SoC
Implementation of a SQL Query Optimizer Application for Oracle Database using indexes and plans.
A Rust-based PostgreSQL extension that makes relational query optimizers natively aware of LLM token costs, semantic entropy, and latency budgets.
Add a description, image, and links to the query-optimizer topic page so that developers can more easily learn about it.
To associate your repository with the query-optimizer topic, visit your repo's landing page and select "manage topics."