Showing 775 open source projects for "postgresql database"

View related business solutions
  • Our Free Plans just got better! | Auth0 Icon
    Our Free Plans just got better! | Auth0

    With up to 25k MAUs and unlimited Okta connections, our Free Plan lets you focus on what you do best—building great apps.

    You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.
    Try free now
  • Stop vibe-debugging. Icon
    Stop vibe-debugging.

    Plug Claude into your app's actual errors.

    AppSignal's MCP server hands Claude, Cursor, or Zed your real errors, traces, and the deploy that shipped them. AI writes the fix; you review the diff.
    Free 30 days.
  • 1
    Ora2Pg

    Ora2Pg

    Ora2Pg is a free tool used to migrate an Oracle database

    ora2pg is an open-source tool used to migrate Oracle databases to PostgreSQL. It connects to an Oracle database, extracts schema and data, and generates SQL-compatible output for PostgreSQL. It supports complex migration scenarios, including stored procedures, triggers, data types, and performance optimization, making it ideal for enterprises transitioning away from Oracle systems.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 2
    Noisia

    Noisia

    Harmful workload generator for PostgreSQL

    noisia is a PostgreSQL workload generator designed for testing and benchmarking query performance. It simulates real-world SQL traffic by replaying or generating workloads based on defined query profiles. noisia is useful for stress testing databases, tuning configurations, and validating changes in performance-sensitive environments.
    Downloads: 7 This Week
    Last Update:
    See Project
  • 3
    pg_flo

    pg_flo

    Stream, transform, and route PostgreSQL data in real-time

    The easiest way to move and transform data between PostgreSQL databases.
    Downloads: 6 This Week
    Last Update:
    See Project
  • 4
    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: 3 This Week
    Last Update:
    See Project
  • Fully Managed MySQL, PostgreSQL, and SQL Server Icon
    Fully Managed MySQL, PostgreSQL, and SQL Server

    Automatic backups, patching, replication, and failover. Focus on your app, not your database.

    Cloud SQL handles your database ops end to end, so you can focus on your app.
    Try Free
  • 5
    Barman for PostgreSQL

    Barman for PostgreSQL

    Backup and Recovery Manager for PostgreSQL

    Barman (backup and recovery manager) is an administration tool for disaster recovery of PostgreSQL servers written in Python. It allows to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase. Barman's most wanted features include backup catalogs, retention policies, remote recovery, archiving and compression of WAL files and backups. Barman is written and maintained by PostgreSQL professionals 2ndQuadrant.
    Downloads: 37 This Week
    Last Update:
    See Project
  • 6
    sqlsmith

    sqlsmith

    A random SQL query generator

    SQLSmith is a fuzz testing tool for PostgreSQL that automatically generates random SQL queries to uncover bugs in the query planner and executor. It is widely used by PostgreSQL developers and database vendors to stress-test SQL features and engine behavior under edge-case conditions. SQLSmith helps improve database robustness by revealing unexpected failures.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 7
    SPQR

    SPQR

    Stateless Postgres Query Router

    SPQR is a sharding proxy for PostgreSQL that enables horizontal scalability by distributing queries across multiple PostgreSQL instances. Designed for large-scale, multi-tenant architectures, SPQR routes, rewrites, and manages SQL queries to ensure they are executed efficiently across shards. It provides a PostgreSQL-compatible interface so applications can scale transparently without code changes.
    Downloads: 3 This Week
    Last Update:
    See Project
  • 8
    Citus

    Citus

    Distributed PostgreSQL as an extension

    Citus is a PostgreSQL extension that transforms Postgres into a distributed database, so you can achieve high performance at any scale. With Citus, you extend your PostgreSQL database with new superpowers. Distributed tables are sharded across a cluster of PostgreSQL nodes to combine their CPU, memory, storage and I/O capacity. References tables are replicated to all nodes for joins and foreign keys from distributed tables and maximum read performance. ...
    Downloads: 3 This Week
    Last Update:
    See Project
  • 9
    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: 11 This Week
    Last Update:
    See Project
  • $300 Free Credits for Your Google Cloud Projects Icon
    $300 Free Credits for Your Google Cloud Projects

    Start building on Google Cloud with $300 in free credits. No commitment, no credit card required until you're ready to scale.

    Launch your next project with $300 in free Google Cloud credits—no strings attached. Test, build, and deploy without risk. Use your credits across the entire Google Cloud platform to find what works best for your needs. After your credits are used, continue with always-free tier services. Only pay when you're ready to scale. Sign up in minutes and start exploring.
    Start Free Trial
  • 10
    Postgres.js

    Postgres.js

    The Fastest full featured PostgreSQL client for Node.js

    Postgres.js is a fast and full-featured PostgreSQL client for Node.js, Deno, Bun, and Cloudflare Workers. It offers a modern, promise-based API with support for tagged template literals, providing a safe and efficient way to interact with PostgreSQL databases. Postgres.js is known for its performance and minimal dependencies, making it a popular choice for developers.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 11
    Autobase

    Autobase

    Automated database platform for PostgreSQL

    autobase is an automated, lightweight PostgreSQL replication setup tool for streaming replication using repmgr. It simplifies the configuration and management of PostgreSQL high availability clusters by handling role switching, connection settings, and initial replication setup with minimal manual effort. It's particularly useful for small to medium-sized teams looking to deploy resilient database clusters quickly.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 12
    Apache AGE

    Apache AGE

    Graph database optimized for fast analysis

    Apache AGE (A Graph Extension) is a PostgreSQL extension that adds support for graph database functionality using the openCypher query language. AGE allows users to store and query graph-structured data alongside traditional relational data in a single database. Built for performance and scalability, it brings the power of graph queries to the robustness of PostgreSQL, making it suitable for use cases like social networks, recommendation systems, and fraud detection.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 13
    Temporal Tables

    Temporal Tables

    Postgresql temporal_tables extension in PL/pgSQL

    temporal_tables is a PostgreSQL extension that adds temporal support to tables by automatically tracking row history. It enables versioned records, letting users query data as it existed at any point in time. This is ideal for audit logging, data versioning, and time-travel queries without needing manual triggers or archive tables.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 14
    pg_probackup

    pg_probackup

    Backup and recovery manager for PostgreSQL

    pg_probackup is an advanced backup and recovery tool for PostgreSQL developed by PostgresPro. It supports full, incremental, and differential backups with compression and encryption, and provides fine-grained control over backup and restore processes. It’s designed for enterprise-grade backup strategies in PostgreSQL environments.
    Downloads: 3 This Week
    Last Update:
    See Project
  • 15
    PgBouncer

    PgBouncer

    lightweight connection pooler for PostgreSQL

    PgBouncer is a lightweight, high-performance connection pooler for PostgreSQL. It reduces the overhead of frequent connection handling by maintaining a pool of open connections, which are reused by client applications. PgBouncer supports various pooling modes, transaction-level handling, and authentication mechanisms, making it essential for scaling Postgres-backed applications.
    Downloads: 3 This Week
    Last Update:
    See Project
  • 16
    repmgr

    repmgr

    A lightweight replication manager for PostgreSQL (Postgres)

    repmgr is a management tool for PostgreSQL replication, providing monitoring, failover, and administrative capabilities for streaming replication setups. It simplifies the configuration of primary/standby clusters and automates failover processes for high availability. repmgr is widely used in production environments where database resilience and minimal downtime are critical.
    Downloads: 1 This Week
    Last Update:
    See Project
  • 17
    pgactive

    pgactive

    PostgreSQL replication extension to create an active-active database

    pgactive is an open-source extension for PostgreSQL that enables active-active replication across multiple database instances—meaning each node can accept writes and replicate changes to other nodes. Traditionally PostgreSQL supports active-standby setups (single writable master), but pgactive opens up use cases such as multi-region high-availability clusters, low-latency writes from distributed apps, and blue/green migrations where both sides are writable.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 18
    Procrastinate

    Procrastinate

    PostgreSQL-based Task Queue for Python

    Procrastinate is a powerful PostgreSQL-based task queue for Python, built to integrate seamlessly with Django and FastAPI. It allows you to schedule and execute background jobs using your existing database infrastructure, avoiding the need for additional queueing systems like Redis. Procrastinate is designed with simplicity, reliability, and observability in mind.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 19
    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: 4 This Week
    Last Update:
    See Project
  • 20
    pglogical

    pglogical

    Logical Replication extension for PostgreSQL

    pglogical is an advanced logical replication extension for PostgreSQL that allows selective replication of data between databases. Unlike physical replication, it enables fine-grained control of which tables or changes to replicate. It’s well-suited for multi-master setups, version upgrades, and real-time data distribution across environments.
    Downloads: 2 This Week
    Last Update:
    See Project
  • 21
    pgroll

    pgroll

    PostgreSQL zero-downtime migrations made easy

    pgroll is an open-source command-line tool for performing zero-downtime, reversible schema migrations on PostgreSQL databases. It allows developers to define migrations using a high-level JSON format and manages the migration process to ensure application availability during schema changes.
    Downloads: 5 This Week
    Last Update:
    See Project
  • 22
    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: 3 This Week
    Last Update:
    See Project
  • 23
    Supabase Wrappers

    Supabase Wrappers

    Postgres Foreign Data Wrapper development framework in Rust

    Supabase Wrappers is a collection of PostgreSQL extensions (written in Rust) that allow Postgres to interact with external systems like APIs, files, and other databases. It uses Foreign Data Wrappers (FDWs) to treat external resources as if they were native SQL tables, enabling seamless integration with external services directly from SQL queries.
    Downloads: 3 This Week
    Last Update:
    See Project
  • 24
    Knex

    Knex

    A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, etc.

    Knex.js is a flexible and portable SQL query builder for JavaScript. It supports multiple database systems, including PostgreSQL, MySQL, SQLite3, and more. Knex.js offers a powerful and intuitive API for building and executing SQL queries, making it a popular choice for Node.js applications requiring database interactions.
    Downloads: 0 This Week
    Last Update:
    See Project
  • 25
    Postgres Meta

    Postgres Meta

    A RESTful API for managing your Postgres. Fetch tables, add roles

    Postgres Meta is a RESTful API for managing PostgreSQL databases, developed by Supabase. It allows users to perform administrative tasks such as creating tables, views, functions, roles, and extensions programmatically through HTTP endpoints. Postgres Meta enables developers to integrate database management directly into dashboards, automation tools, or backend services without requiring SQL access or pgAdmin.
    Downloads: 5 This Week
    Last Update:
    See Project
Auth0 Logo