Open Source PostgreSQL Projects
PostgreSQL is an open source relational database management system for storing, organizing, and querying structured data. It uses SQL and supports transactions, constraints, indexing, and extensible data types, helping applications preserve data integrity and handle complex queries. Its capabilities make it useful for workloads ranging from small applications to large, data-intensive services.
Open source tools in the PostgreSQL ecosystem include database clients, extensions, backup utilities, migration tools, drivers, and application libraries. When choosing one, consider its license, compatibility with your PostgreSQL version, maintenance activity, documentation, security practices, and fit with your deployment and development environment. These tools are useful to developers, database administrators, and organizations that build, operate, or connect applications to PostgreSQL databases.
23 repositories · updated October 4, 2026
utopia: Build a Time-Aware Enterprise Knowledge System
Utopia is a self-hosted knowledge system that turns documents and observations into an ontology-guided, bitemporal graph. It combines search, evidence-backed answers, agent access, and human review for teams that need to track how knowledge and decisions change.
pgrust: Run a Rust Rewrite of PostgreSQL
pgrust is a Rust reimplementation of PostgreSQL that aims to preserve its wire protocol and SQL behavior while reworking execution, concurrency, and storage. It is for evaluation and experimentation today, not production data you cannot afford to lose.
rachoon: Self-Host Invoicing for Small Businesses
Rachoon is a self-hosted invoicing web app for freelancers and small businesses. It manages clients, invoices, quotations, and payments, with PDF export and support for custom templates, currencies, and taxes.
pg_textsearch: Add BM25 Ranked Search to PostgreSQL
pg_textsearch is a PostgreSQL extension that adds BM25 relevance ranking and indexed full-text search. It suits teams that want ranked text queries inside PostgreSQL, using its text search configurations and SQL workflows.
multigres: Scale Postgres with a Vitess-Inspired System
Multigres adapts Vitess’s approach to managing and scaling databases for PostgreSQL. It is aimed at teams exploring connection pooling, sharding, and high availability, but is still in early development.
relay: Send Email Through Your Own Infrastructure
Hyvor Relay is a self-hosted email API that sends mail through your own SMTP infrastructure. It suits teams that want control over delivery operations, logs, and tenant or project separation rather than relying on a hosted sending provider.
graphql-engine: Build GraphQL APIs Across Your Data
Hasura GraphQL Engine turns connected data sources into a composable GraphQL API with fine-grained access control. It suits teams that want to expose database-backed data through a managed API layer rather than build each resolver and access rule by hand.
Badget: Manage Household Finances with AI-Assisted Insights
Badget is a web app for households to track accounts, transactions, budgets, and financial goals in one place. It combines shared household access with AI-oriented analysis and budgeting features, and is intended for teams comfortable configuring a full-stack application.
pgcli: Query PostgreSQL from an Interactive Terminal
pgcli is a Python command-line client for PostgreSQL that adds SQL highlighting and context-aware autocomplete to an interactive REPL. It suits developers and database users who want a more guided terminal workflow than a basic SQL prompt.
postcard: Create a Personal Website and Newsletter
Postcard is a self-hostable Rails app for publishing a personal website, blog posts, and an integrated newsletter. It suits people who want an owned online presence and mailing list instead of relying on social media.
HiveChat: Team AI Chat with Multiple Model Providers
HiveChat is a deployable AI chat app for small and medium-sized teams. Administrators configure model providers, access methods, user groups, and monthly token limits, while team members use a shared chat interface.
logo-ai: Generate Custom Logos with AI
LogoAI is a web app for creating custom logos from user-selected styles, colors, sizes, and quality settings. It suits individuals and small teams who want to explore logo concepts quickly, with generation powered by Nebius AI.