pgmoneta: Model Context Server implementation
Contributor: Ahmed Kamal AbdElrasol
The motivation behind this project is to extend and introduce a fully functional MCP server for pgmoneta. To achieve this ultimate goal, we have...
Data
PostgreSQL
The Most Advanced Open Source Relational Database
Technologies
CGoJavaScriptPostgreSQLPython
Topics
Benchmarkdatabasesqluser interfaceweb
- Total projects
- 58
- Years participating
- 10
- Most recent
- 2026
Participation history
Historical projects
Reducing pg stat statements LWLock Contention
Contributor: hoangquan456
pg_stat_statements tracks query statistics across a PostgreSQL cluster, but its single-LWLock architecture creates a scalability bottleneck under...
B-tree Index Bloat Reduction (Page Merge)
Contributor: Salma El-Sayed
PostgreSQL B-tree indexes often suffer from severe bloat after heavy UPDATE and DELETE workloads because the core engine currently cannot consolidate...
pgmoneta: WAL & MCP
Contributor: Sara Nabih
pgmoneta is an open-source tool that offers a solution for PostgreSQL backup and recovery. This project is a continuation of the 2025 GSoC project on...
pgmoneta: Storage engines
Contributor: Shashidhar M
pgmoneta’s current storage layer is fragmented, back-ends do not share full feature parity and a single backup cannot target multiple destinations at...
Historic Data for pgexporter
Contributor: Somye
This project will add native historical metrics storage to pgexporter, enabling users to analyze trends and long-term performance without relying on...
pgagroal: Advanced security
Contributor: trxvor
This project implements true end-to-end TLS pooling for pgagroal by decoupling the cryptographic state from the physical TCP socket. By implementing...
Enhancements to pgwatch v3 RPC integration
Contributor: ahmad gouda
The existing pgwatch3_rpc_server project creates specialized RPC endpoints that allow pgwatch3 clients to export monitoring data in various formats...
pgmoneta: Incremental backup for PostgreSQL 13-16
Contributor: Ashutosh Sh
Implement functionality in pgmoneta and pgmoneta_ext such that an incremental backup can be taken from PostgreSQL 13 to 16. This work can build upon...
Extension Support for pgexporter
Contributor: Bassam Adnan
PostgreSQL extensions can offer detailed views of query performance, storage usage, and system health but this would need frequent manual setup to be...
Upgrade pgwatch Grafana dashboards to v12
Contributor: Gaurav Patidar
This project focused on upgrading the existing pgwatch Grafana dashboards to ensure full compatibility with the latest Grafana version 12. While some...
ABI Compliance Reporting System
Contributor: Mankirat Singh
PostgreSQL introduced Server API and ABI Stability Guidance to help extension authors understand compatibility expectations. The policy ensures ABI...
pgmoneta: WAL Filtering
Contributor: Mohab Yasser
pgmoneta is an open-source tool designed for PostgreSQL backup and recovery, with a strong focus on managing Write-Ahead Logging (WAL) files critical...
Enhancing Pgagroal Security: Hot Reloading, Vault Improvements, and Certificate Monitoring
Contributor: User 1995
This project enhances Pgagroal's security by implementing hot reloading for TLS certificates and configuration files, refining the vault system for...
PostgreSQL (Pgmoneta) - WAL infrastructure
Contributor: Shahryar
In this project, we want to implement an infrastructure in Pgmoneta that can read and parse the WAL files into WAL records. When our infrastructure...
pgmoneta: Extended functionality
Contributor: Chao
The project aims to provide a new code base, pgmoneta_ext, to enable pgmoneta to access files on the PostgreSQL server side, including the ability to...
PostgreSQL JDBC Struct/Array Support
Contributor: Arjan Marku
Currently, the composite types defined in PostgreSQL (https://www.postgresql.org/docs/current/rowtypes.html#ROWTYPES) are not exposed through the...
pgagroal: Replace the I/O Layer
Contributor: decarv
The project consists of replacing the I/O Layer of pgagroal, today highly dependent on the libev library, for a pgagroal's own implementation. The so...
RPC Sinks for PgWatch3
Contributor: Akshat Jaimini
This project aims to provide support for remote sinks in pgwatch3. Currently pgwatch3 allows users to write measurements to ‘sinks’. However there...
pg_adviser / index_adviser: Recommend Potentially Useful Indexes
Contributor: Ahmed Ibrahim
The Index Adviser (pg_adviser) is an extension for PostgreSQL that suggests potentially useful indexes for given queries. This project aims to...
PGweb Testing Harness for the official PostgreSQL Website
Contributor: Akshat Jaimini
As part of the Google Summer of Code 2023 , we developed an automated testing harness suite for the official PostgreSQL website. The suite addresses...
Develop Performance Farm Benchmarks and Website (2023)
Contributor: Anil rundla
The Performance Farm project aims to emphasize Postgresql performance as it evolves by conducting benchmarks and posting the results on a webpage....
pgmoneta: Native Backup
Contributor: Haoran Zhang
Pgmoneta is a backup/restore solution for PostgreSQL. It can be used to backup one or multiple databases. Currently pgmoneta achieves that by calling...
Postgres Extension Tutorial / Quick Start
Contributor: Ishaan Adarsh
This project aims to create a comprehensive and easy-to-follow tutorial on how to write a Postgres extension, addressing the current lack of clear...
pgagroal: simple vault implemention
Contributor: Jichen
pgagroal is a high-performance protocol-native connection pool for PostgreSQL. It also manages authentication for users who try to access the...
Rewriting the pg_chameleon SQL library
Contributor: Kaustubh M
The pg_chameleon library translates DDL from MySQL dialect to PostgreSQL dialect. In doing this, there is an intermediate tokenization step. This...
pg_statviz: Time Series Analysis & Visualization of Statistics
Contributor: Rajiv Harlalka
pg_statviz is a PostgreSQL extension with a command line utility pair. The extension can snapshot cumulative and dynamic statistics of various...
Improving PostgreSQL Version Support for pgexporter
Contributor: resyfer
Pgexporter provides Prometheus metrics for PostgreSQL servers which include some core metrics, as well as custom metrics provided by users. The...
GUI representation of monitoring System Activity with the system_stats Extension in pgAdmin 4
Contributor: Sahil Harpal
This project involves design and developing dashboard in pgAdmin 4 which shows the system level statistics for monitoring Postgres activity with the...
pgagroal: Query Cache
Contributor: Sudeep Reddy
This project involves adding a query caching feature to pgagroal, a high-performance connection pool for PostgreSQL. The goal is to enhance...
Monitoring for pgmoneta
Contributor: Zhengshun Lin
In this project, we will expand metrics to help users observe the running status of pgmoneta and each server at any time. Additionally, a large...
Improve pgarchives
Contributor: Sahil Harpal
pgarchives is the official archive of Postgres mailing lists. Users can access the interface from the website and browse it, searching according to...
Pgexporter: Custom file
Contributor: Donglin Xie
Pgexporter is a Prometheus exporter for PostgreSQL. In this project, we add the option to have a custom query file to specify the queries run against...
Develop Performance Farm Benchmarks and Website
Contributor: Yedil Serzhan
The PostgreSQL Performance Farm (short for Pgperffarm) is a project to measure and visualize the benchmark performance of each version of PostgreSQL...
Improve PostgreSQL Regression Test Coverage
Contributor: DongWook Lee
# proposal summary PostgreSQL is a very actively developed project and there are so many existing codes and so many new ones are added. I think there...
New and improved website for pgjdbc (JDBC)
Contributor: Utkarsh Shukla
This project would aim to update the pgjdbc website. Currently, it is based on a very old PostgreSQL template and uses Jekyll to build it & also this...
pgmoneta: Storage API
Contributor: Mariam Fahmy
pgmoneta is a backup / restore solution for PostgreSQL, it supports doing backups, listing all backups for a server, restoring a backup from a...
pgmoneta: On-disk encryption
Contributor: Jichen
This project aims to add support for on-disk encryption of backups. These are some tasks that need to be completed: Create an internal API for...
Add monitoring of pg_stat_statements to pg_systat
Contributor: Jianhui Lu
Pg_systat is 'systat' for PostgreSQL. It allows users to monitor various PostgreSQL statistics tables from a terminal window. This project aims to...
Improve pgeu-system for Conference Management
Contributor: Saurav Shrivastav
Pg-eu system is an infrastructure developed and maintained by Postgres for managing non-profit organizations along with an extensive conference...
WAL-G optimization backup storage by remote-copy APIs
Contributor: Alexander Slesarev
WAL-G supports two backup types: delta(incremental) and full. Delta backup has higher performance on pushing phase, but it is slower on fetch and...
pgagroal: Metrics and monitoring
Contributor: Junduo Dong
Project "Metrics and monitoring" aims to collect more effective metrics which can characterize the current status of pgagroal's pool, connections,...
Develop Performance Farm Benchmarks and Website
Contributor: YoungHwan Joo
PostgreSQL is a big and active open-source DBMS. This means that the code changes frequently and there are a lot of branches and commits. When big...
Create procedural language extension for the Julia programming language
Contributor: Konstantina Skovola
Postgresql allows developers more freedom to extend the provided capabilities in an application-specific manner compared to other popular open-source...
Develop Performance Farm Database and Website
Contributor: Ilaria Battiston
PostgreSQL is a famous database management system, widely used by DBAs and with an open source license. There is a large community dedicated to...
WAL-G performance improvements
Contributor: Daniil Zakhlystov
The goal of the project is to make two enhancements of archival and restoration tool WAL-G. The first one is to improve the performance of the backup...
Improving PL/Java build system
Contributor: mrrobot
PL/Java is an open source extension PostgreSQL that allows stored procedures, triggers and functions to be written in Java. PL/Java ‘s build system...
Develop Performance Farm Database and Website
Contributor: Ilaria Battiston
The Performance Farm is an useful way to test Postgres' functionalities while changes are being made, to analyze its efficacy on different operating...
de-TOAST'ing using an iterator
Contributor: Binguo Bao
This project would aim to provide the ability to de-TOAST a fully TOAST'd and compressed field using an iterator, and then update the appropriate...
pgAdmin 4 Query Tool Automatic Mode Detection and Enhancements
Contributor: Yosry Ahmed
pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source...
ARTful Buffer Manager
Contributor: mvpant
The main goal of this project is to implement and evaluate an adaptive radix tree as an alternative to the current underlying data structure of...
"Develop Performance Farm Database and Website" proposal for Google Summer of Code 2018
Contributor: Hongyuan Ma
I plan to implement the PerfFarm project using a separate front-end and back-end development approach and use PostgreSQL as a database for storing...
implement pg_thrift plugin for postgreSQL
Contributor: Yan Cui
One of advantages of document-oriented databases like MongoDB or Couchbase over RDBMSs is an ability to change the data scheme easily, fast and...
Sorting Algorithms Benchmark and Implementation
Contributor: Kefan Yang
Implement the project idea sorting algorithms benchmark and implementation (2018) Candidate sorting algorithms: Introsort Timsort Dual-pivot...
Foreign Keys for Array Elements
Contributor: Mark Rofail
My proposal is to target the performance issue regarding the foreign keys for the array index. Any UPDATE or DELETE statement on a Primary Key table...
Eliminate O(N^2) scaling from rw-conflict tracking in serializable transactions
Contributor: Mengxing Liu
To provide strict serializable isolation among transactions, PostgreSQL needs to track read-write conflicts (rw-conflicts for short in the following...
Add errors handling and parallel execution to COPY
Contributor: Alexey Kondratov
Using PostgreSQL (PG) on the daily basis for years I found that there are some use-cases when you need to load (e.g. for a further analytics) a bunch...
Explicitly support predicate locks in index AMs besides btree
Contributor: Shubham Barai
Currently, only B+-trees support page level predicate locking.For other indexes, it acquires relation level lock which can lead to unnecessary...