Adaptive query optimization for PostgreSQL

optimization postgresql adaptive query-optimizer

• Updated Jun 27, 2026
• C

PilotScope is a middleware to bridge the gaps of deploying AI4DB (Artificial Intelligence for Databases) algorithms into actual database systems.

middleware database spark postgresql cardinality-estimation query-optimizer ai4db knob-tuning index-recommendation

• Updated Oct 12, 2024
• Python

A playground for experimenting ideas that may apply to Spark SQL/Catalyst

sql query-optimizer

• Updated Jul 5, 2018
• Scala

Slides and material for MySQL and MariaDB query optimization.

slide conference query-optimizer

• Updated Jul 23, 2022

A Relational Optimizer and Executor

codegen query-optimizer query-executor cascades-optimizer distributed-query property-enforcer

• Updated May 28, 2026
• C#

build your own query planner

awesome tutorial scala sql database guide database-management help-wanted scratch looking-for-contributors query-engine query-optimization from-scratch cascades database-design query-optimizer volcano good-first-issue query-planning query-planner

• Updated Apr 22, 2026
• Scala

100+ data engineering projects from scratch — streaming, CDC, table formats, query engines, consensus, governance. 2,500+ tests, mypy strict.

python streaming kafka raft data-engineering cdc iceberg query-optimizer lsm-tree delta-lake

• Updated Jun 12, 2026
• Python

Run the PostgreSQL Explain Visualizer 2 (pev2) from the command line.

postgres postgresql query-optimization query-optimizer query-plan query-planning query-planner pev2

• Updated Oct 20, 2026
• JavaScript

Laravel package helps you to execute more effective databases queries, delete, update, insert, and optimize your database queries.

open-source laravel query laravel-package syria query-optimizer syrian query-helper syrian-open-source

• Updated May 13, 2022
• PHP

The codebase for DBSim

data-science database sql-query sql-parser in-database in-database-analytics query-optimizer

• Updated Mar 8, 2023
• Python

Open source Snowflake cost proxy. Verified caching, suspend, rewrites, attribution, and signed savings evidence.

rust caching sql proxy snowflake data-warehouse data-engineering query-optimization fsl query-optimizer cost-optimization finops wire-protocol fair-source snowflake-optimization

• Updated Jul 28, 2026
• Rust

🔄 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.

postgresql database-management query-optimizer database-monitoring database-security database-optimization devops-automation python-postgresql chatgpt-tools database-admin ai-integration database-performance mcp-server claude-integration ai-database-tools sql-automation database-diagnostics postgres-tools database-health-check postgres-monitoring

• Updated Mar 15, 2026
• Python

Use JSON objects to generate PostgreSQL WHERE clause expressions.

sql postgresql jsonb json-query query-optimizer

• Updated Oct 18, 2017
• PLpgSQL

Homework for Query Optimization - a TUM Computer Science Course

database sql-query query-optimizer

• Updated Feb 5, 2017
• C++

pg_orca is a PostgreSQL extension of the ORCA query optimizer — a Cascades-style, cost-based optimizer extension.

postgresql query-optimizer cascades-optimizer

• Updated Nov 11, 2026
• C++

A custom relational SQL database engine built from scratch in C++17 — TCP server, REST API, replication, full-text search, window functions, triggers

c-plus-plus sql database networking replication cpp rest-api sql-parser cpp17 btree database-engine query-optimizer btree-index database-engineering

• Updated Nov 10, 2026
• C++

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.

go golang data-science csv etl analytics arrow simd data-engineering data-analysis parquet query-engine golang-library lazy-evaluation dataframe dataframes query-optimizer dataframe-library apache-arrow polars

• Updated Nov 10, 2026
• Go

Cost-based advisor for filtered vector search in PostgreSQL and pgvector

postgresql cost-model embeddings ann query-optimizer hnsw vector-search pgvector

• Updated Sep 23, 2026
• Python

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.

performance big-data data-engineering observability query-optimizer trino apache-impala query-diagnostics

• Updated Nov 9, 2026
• Python

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

sql database storage-engine indexing sql-parser rdbms btree execution-engine btree-indexes database-internals buffer-pool query-optimizer educational-project heap-storage query-planner java17 hash-indexes relational-dbms

• Updated Dec 27, 2025
• Java