Open Source PostgreSQL Projects
Discover 23 open source PostgreSQL repositories from GitHub, each with an analysis of what it does, key features, use cases and alternatives. PostgreSQL projects here are most often combined with Self Hosted, TypeScript and Web App. Last updated October 4, 2026.
23 repositories · updated October 4, 2026
Damn-Vulnerable-RESTaurant-API-Game: Practice API Security
A deliberately insecure Python API for practicing vulnerability discovery, exploitation, and remediation. Developers, ethical hackers, and security engineers can run it locally with Docker as a controlled training environment.
ryot: Track Media and Fitness in a Self-Hosted App
Ryot brings media tracking and fitness logs into one self-hosted platform, with imports and integrations for services such as Jellyfin and Trakt. It suits people who want a single place to organize activity and retain control of their data.
Panora: Unify Business App Integrations Behind an API
Panora was an open-source integration engine intended to help teams connect business apps through a unified API. The repository is archived and its OSS product was sunset, so it is not a good choice for a new deployment.
readyset: Cache Database Queries for Faster Reads
Readyset sits between an application and a MySQL or PostgreSQL database, caching supported SQL reads and keeping results updated from database changes. It can help teams improve read throughput without adding application-managed cache invalidation.
paradedb: Add Search and Analytics to PostgreSQL
ParadeDB is a PostgreSQL extension that brings full-text search, vector retrieval, and analytics into the database where application data already lives. It suits teams that want SQL-based search and aggregation without operating a separate search system.
drizzle-orm: Build Type-Safe SQL Applications
Drizzle ORM is a TypeScript-first library for declaring database schemas and writing typed SQL-like or relational queries. It supports PostgreSQL, MySQL, and SQLite across JavaScript runtimes, with companion tools for migrations and data browsing.
twenty: Customize and Self-Host a CRM
Twenty is a TypeScript CRM for teams that need customizable business workflows and data models. Use it as a cloud service, self-host it, or extend it with apps defined and versioned as code.
discourse: Run an Online Community Discussion Platform
Discourse is a self-hostable platform for forums and community conversations, with topic discussions, chat, themes, and plugins. It suits organizations that want control over their community software and hosting.
OpenArchiver: Archive and Search Email for Compliance
OpenArchiver is a self-hosted platform for importing, preserving, and searching email from major providers and common archive formats. It suits organizations that need searchable records and retention controls, with deployment and storage managed on their own infrastructure.
bracket: Manage and Schedule Tournaments
Bracket is a self-hosted tournament management system for organizing teams, stages, matches, and schedules. It supports single-elimination, round-robin, and Swiss formats, with public dashboards for sharing tournament information.
Zero: Self-Host an AI-Powered Email App
Zero is a self-hostable email app that connects services such as Gmail and Outlook in a unified inbox. It combines email workflows with AI agents and is aimed at people who want more control over their email setup and data.