Showing 574 open source projects for "postgresql"

View related business solutions
  • Premier Construction Software Icon
    Premier Construction Software

    Premier is a global leader in financial construction ERP software.

    Rated #1 Construction Accounting Software by Forbes Advisor in 2022 & 2023. Our modern SAAS solution is designed to meet the needs of General Contractors, Developers/Owners, Homebuilders & Specialty Contractors.
    Learn More
  • Turn traffic into pipeline and prospects into customers Icon
    Turn traffic into pipeline and prospects into customers

    For account executives and sales engineers looking for a solution to manage their insights and sales data

    Docket is an AI-powered sales enablement platform designed to unify go-to-market (GTM) data through its proprietary Sales Knowledge Lake™ and activate it with intelligent AI agents. The platform helps marketing teams increase pipeline generation by 15% by engaging website visitors in human-like conversations and qualifying leads. For sales teams, Docket improves seller efficiency by 33% by providing instant product knowledge, retrieving collateral, and creating personalized documents. Built for GTM teams, Docket integrates with over 100 tools across the revenue tech stack and offers enterprise-grade security with SOC 2 Type II, GDPR, and ISO 27001 compliance. Customers report improved win rates, shorter sales cycles, and dramatically reduced response times. Docket’s scalable, accurate, and fast AI agents deliver reliable answers with confidence scores, empowering teams to close deals faster.
    Learn More
  • 1
    pg-mem

    pg-mem

    An in memory postgres DB instance for your unit tests

    pg-mem is an in-memory PostgreSQL emulator for Node.js and TypeScript that allows you to simulate a Postgres database without a real server. It’s perfect for unit testing and development scenarios where spinning up a full database would be too heavy. pg-mem supports many Postgres features and is compatible with various ORMs like TypeORM and Sequelize.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 2
    pg_analytics

    pg_analytics

    DuckDB-powered analytics for Postgres

    pg_analytics (formerly named pg_lakehouse) puts DuckDB inside Postgres. With pg_analytics installed, Postgres can query foreign object stores like AWS S3 and table formats like Iceberg or Delta Lake. Queries are pushed down to DuckDB, a high-performance analytical query engine. By transforming Postgres into a performant search and analytics engine, ParadeDB frees your team from the pain of scaling and syncing Elasticsearch.
    Downloads: 50 This Week
    Last Update:
    See Project
  • 3
    Postgres

    Postgres

    PostgreSQL driver for Deno

    A lightweight PostgreSQL driver for Deno focused on developer experience. deno-postgres is inspired by the excellent work of node-postgres and pq. The documentation is available on the deno-postgres website. Due to breaking changes introduced in the unstable APIs deno-postgres uses, there has been some fragmentation regarding what versions of Deno can be used alongside the driver.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 4
    PGManage

    PGManage

    Web tool for database management

    pgManage is an open-source, cross-platform desktop GUI for managing PostgreSQL databases. It provides a tabbed interface for browsing schemas, writing queries, and managing server configurations. Designed for both developers and DBAs, pgManage aims to be a user-friendly yet powerful alternative to pgAdmin.
    Downloads: 2 This Week
    Last Update:
    See Project
  • Failed Payment Recovery for Subscription Businesses Icon
    Failed Payment Recovery for Subscription Businesses

    For subscription companies searching for a failed payment recovery solution to grow revenue, and retain customers.

    FlexPay’s innovative platform uses multiple technologies to achieve the highest number of retained customers, resulting in reduced involuntary churn, longer life span after recovery, and higher revenue. Leading brands like LegalZoom, Hooked on Phonics, and ClinicSense trust FlexPay to recover failed payments, reduce churn, and increase customer lifetime value.
    Learn More
  • 5
    WhoDB

    WhoDB

    A lightweight next-gen data explorer

    WhoDB is a lightweight audit logging extension for PostgreSQL that helps track who accessed what data and when. It uses logical decoding and hooks into PostgreSQL internals to log query metadata, user identities, and timestamps in a separate audit schema. WhoDB is useful for compliance, security monitoring, and debugging in multi-user environments.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 6
    pspg

    pspg

    Unix pager (with rich functionality) designed for work with tables

    pspg is a Unix pager designed for working with tabular data, particularly from PostgreSQL, but also supports other databases like MySQL.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 7
    DoltgreSQL

    DoltgreSQL

    DoltgreSQL - Version Controlled PostgreSQL

    DoltgreSQL is an experimental Postgres fork that adds Git-like version control to your database. It allows users to commit, branch, merge, and revert changes to data and schema, bringing collaborative workflows to SQL databases. DoltgreSQL is designed for teams who want full auditability and control over every change made in their data layer.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 8
    Digoal Blog

    Digoal Blog

    Opensource, Database, AI, Business

    Digoal Blog is a comprehensive collection of articles, tutorials, and resources focused on open-source databases, particularly PostgreSQL. Maintained by Digoal Zhou, the blog covers a wide range of topics including database optimization, architecture, and best practices, serving as a valuable resource for database administrators and developers.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 9
    pg_easy_replicate

    pg_easy_replicate

    Easily setup logical replication and switchover to new database

    pg_easy_replicate is a simple tool for replicating PostgreSQL data from one database to another using logical replication. It abstracts away the complexity of publication/subscription setup and enables selective table replication. Ideal for developers or data engineers who want quick replication without deep Postgres expertise.
    Downloads: 1 This Week
    Last Update:
    See Project
  • AestheticsPro Medical Spa Software Icon
    AestheticsPro Medical Spa Software

    Our new software release will dramatically improve your medspa business performance while enhancing the customer experience

    AestheticsPro is the most complete Aesthetics Software on the market today. HIPAA Cloud Compliant with electronic charting, integrated POS, targeted marketing and results driven reporting; AestheticsPro delivers the tools you need to manage your medical spa business. It is our mission To Provide an All-in-One Cutting Edge Software to the Aesthetics Industry.
    Learn More
  • 10
    PHP-CRUD-API

    PHP-CRUD-API

    Single file PHP script that adds a REST API to a SQL database

    Single file PHP script that adds a REST API to a MySQL/MariaDB, PostgreSQL, SQL Server or SQLite database. Howto: Upload "api.php" to your webserver, configure it to connect to your database, have an instant full-featured REST API. This is the TreeQL reference implementation in PHP. This is a single file application! Upload "api.php" somewhere and enjoy! For local development you may run PHP's built-in web server.
    Downloads: 8 This Week
    Last Update:
    See Project
  • 11
    dblab

    dblab

    The database client every command line junkie deserves

    dblab is a fast and lightweight interactive terminal based UI application for PostgreSQL, MySQL and SQLite3, written in Go and works on OSX, Linux and Windows machines. Main idea behind using Go for backend development is to utilize ability of the compiler to produce zero-dependency binaries for multiple platforms. dblab was created as an attempt to build very simple and portable application to work with local or remote PostgreSQL/MySQL/SQLite3/Oracle/SQL Server databases.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 12
    pg_auto_failover

    pg_auto_failover

    Postgres extension and service for automated failover

    pg_auto_failover is a PostgreSQL extension and management tool for automated high availability. It handles health checks, failover, and monitoring without requiring third-party tools or complex configuration. Designed by the Citus Data team at Microsoft, it's ideal for developers and ops teams wanting reliable HA with minimal effort.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 13
    HeidiSQL

    HeidiSQL

    A lightweight client for managing MariaDB, MySQL, SQL Server, etc.

    HeidiSQL is a lightweight, open-source client for managing relational databases. It provides a user-friendly interface for browsing and editing data, creating and modifying tables, and executing SQL queries. HeidiSQL supports various database systems, making it a versatile tool for developers and database administrators.
    Downloads: 59 This Week
    Last Update:
    See Project
  • 14
    PEV2

    PEV2

    Postgres Explain Visualizer 2

    PEV2 is a web-based tool to visualize PostgreSQL execution plans. It takes EXPLAIN or EXPLAIN ANALYZE output and displays it in an interactive, tree-like format that highlights performance metrics, helping users understand query behavior and bottlenecks. PEV2 is a complete rewrite of the original PEV, offering a modern, user-friendly interface for query optimization.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 15
    Sequin

    Sequin

    Postgres change data capture to streams and queues like Kafka

    Sequin is a change data capture (CDC) system that replicates API data to Postgres in real time. It syncs services like Stripe, Salesforce, and GitHub into PostgreSQL tables, enabling developers to query third-party data with standard SQL. Sequin is ideal for building data-driven applications that need immediate visibility into external SaaS platforms.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 16
    pgcat

    pgcat

    PostgreSQL pooler with sharding, load balancing and failover support

    PgCat is a high-performance PostgreSQL connection pooler and load balancer built for modern, distributed systems. Written in Rust, PgCat is designed to efficiently manage database connections across multiple shards and replicas while supporting features like automatic failover, query-based routing, and observability. It works with both single-node and multi-tenant Postgres setups, making it ideal for cloud-native applications that require scale and reliability.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 17
    WebApp.rs

    WebApp.rs

    A web application completely written in Rust

    ...For getting started with hacking, the backend can be tested via make run-backend, whereas the frontend can be tested with make run-frontend. You can adapt the application configuration within Config.toml if needed. make deploy uses podman to start a PostgreSQL container and the Rust backend container. If you wish to use docker instead of podman, set CONTAINER_RUNTIME=docker in the top of Makefile. Edit Config.toml if needed to set the backend url and PostgreSQL credentials. The login screen will accept any username and password that are equal, such as me (username) and me (password). ...
    Downloads: 0 This Week
    Last Update:
    See Project
  • 18
    Dbmate

    Dbmate

    A lightweight, framework-agnostic database migration tool

    ...This is especially helpful if you are writing many services in different languages, and want to maintain some sanity with consistent development tools. Supports MySQL, PostgreSQL, SQLite, and ClickHouse. Uses plain SQL for writing schema migrations. Migrations are timestamp-versioned, to avoid version number conflicts with multiple developers. Migrations are run atomically inside a transaction. Supports creating and dropping databases (handy in development/test). Supports saving a schema.sql file to easily diff schema changes in git. ...
    Downloads: 9 This Week
    Last Update:
    See Project
  • 19
    Enferno

    Enferno

    Modern Flask framework optimized for AI-assisted development

    Enferno is a framework for building developer-first cloud backends using PostgreSQL and TypeScript. It offers primitives for defining data models, APIs, and access rules directly in code, enabling quick iteration and deployment. Enferno is designed to accelerate SaaS and internal tool development by combining the benefits of traditional backends with developer ergonomics.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 20
    pg_squeeze

    pg_squeeze

    A PostgreSQL extension for automatic bloat cleanup

    pg_squeeze is a PostgreSQL extension that reclaims space in bloated tables without blocking read or write access. It provides a non-intrusive alternative to VACUUM FULL by creating a new compacted copy of the table in the background. It’s particularly useful for maintaining performance in large, heavily updated databases.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 21
    DB Dumper

    DB Dumper

    Dump the contents of a database

    DB Dumper is a simple PHP library for creating database dumps of MySQL, PostgreSQL, and SQLite databases. It provides a fluent, expressive API that lets developers configure backup paths, credentials, and additional options. DB Dumper is ideal for integrating automated backups into Laravel or other PHP-based applications.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 22
    Reshape

    Reshape

    An easy-to-use, zero-downtime schema migration tool for Postgres

    Reshape is a declarative SQL schema migration tool for PostgreSQL that allows developers to define the desired schema in a single file. It compares the current database schema with the desired state and generates safe, dependency-aware migrations automatically. Reshape is built for simplicity, safety, and version control integration.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 23
    django-pgtrigger

    django-pgtrigger

    Write Postgres triggers for your Django models

    django-pgtrigger is a Django library for defining and managing PostgreSQL triggers directly in Python code. It allows developers to create database-level logic like automatic field updates, auditing, or validation without writing raw SQL. It’s ideal for teams that want stronger data integrity while keeping logic version-controlled.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 24
    PLpgSQL Check

    PLpgSQL Check

    plpgsql_check is a linter tool (does source code static analyze)

    plpgsql_check is a PostgreSQL extension for static analysis and runtime checking of PL/pgSQL functions. It helps developers catch bugs early by analyzing code structure, variable usage, and SQL correctness before execution. The extension is ideal for improving code quality in large Postgres-based applications.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 25
    postgres_dba

    postgres_dba

    The missing set of useful tools for Postgres DBAs and all engineers

    postgres_dba is a collection of helpful SQL queries and scripts for PostgreSQL database administration. It provides ready-made insights into performance, storage, indexes, and configuration, helping DBAs quickly diagnose issues or monitor health. It's designed as a practical toolkit to keep in every Postgres admin’s back pocket.
    Downloads: 0 This Week
    Last Update:
    See Project
MongoDB Logo MongoDB