Postgres · Utilities

Utilities

• hasura/graphql-engine on GitHub, opens in a new tab

  32.1Kstars

  Blazing fast, instant realtime GraphQL APIs on Postgres with fine grained access control, also trigger webhooks on database events.

  TypeScript·Apache License 2.0·active·4 hours ago

• PostgREST/postgrest on GitHub, opens in a new tab

  27.6Kstars

  Serves a fully RESTful API from any existing PostgreSQL database.

  Haskell·MIT License·active·yesterday

• xataio/pgroll on GitHub, opens in a new tab

  6.6Kstars

  Zero-downtime, reversible, schema migrations for Postgres

  Go·Apache License 2.0·active·last month

• dimitri/pgloader on GitHub, opens in a new tab

  6.5Kstars

  Loads data into PostgreSQL using the COPY streaming protocol, and does so with separate threads for reading and writing data.

  Common Lisp·Other·active·3 weeks ago

• prest/prest on GitHub, opens in a new tab

  4.6Kstars

  Serve a RESTful API from any PostgreSQL database (Golang)

  Go·MIT License·active·3 days ago

• darold/pgbadger on GitHub, opens in a new tab

  4.1Kstars

  Fast PostgreSQL Log Analyzer.

  Perl·PostgreSQL License·active·last month

• ankane/pgsync on GitHub, opens in a new tab

  3.5Kstars

  Tool to sync PostgreSQL data to your local machine.

  Ruby·MIT License·active·2 days ago

• sqitchers/sqitch on GitHub, opens in a new tab

  3.2Kstars

  Tool for managing versioned schema deployment

  Perl·MIT License·active·2 weeks ago

• djrobstep/migra on GitHub, opens in a new tab

  3.1Kstars

  Like diff but for Postgres schemas.

  Python·The Unlicense·steady·12 months ago

• dalibo/pg_activity on GitHub, opens in a new tab

  3Kstars

  top like application for PostgreSQL server activity monitoring.

  Python·PostgreSQL License·active·2 weeks ago

• jarulraj/sqlcheck on GitHub, opens in a new tab

  2.5Kstars

  Automatically detects common SQL anti-patterns. Such anti-patterns often slow down queries. Addressing them will, therefore, help accelerate queries.

  C++·Apache License 2.0·slowing·2 years ago

• GreenmaskIO/greenmask on GitHub, opens in a new tab

  1.7Kstars

  Database anonymization and synthetic data generation tool for MySQL and PostgreSQL.

  Go·Apache License 2.0·active·2 weeks ago

• lesovsky/pgcenter on GitHub, opens in a new tab

  1.6Kstars

  Provides convenient interface to various statistics, management task, reloading services, viewing log files and canceling or terminating database backends.

  Go·Other·active·2 weeks ago

• cybertec-postgresql/pg_timetable on GitHub, opens in a new tab

  1.4Kstars

  Advanced job scheduler for PostgreSQL.

  Go·Other·active·5 hours ago

• lukasmartinelli/pgfutter on GitHub, opens in a new tab

  1.3Kstars

  Import CSV and JSON into PostgreSQL the easy way.

  Go·MIT License·dormant·6 years ago

• nanopack/yoke on GitHub, opens in a new tab

  1.3Kstars

  PostgreSQL high-availability cluster with auto-failover and automated cluster recovery.

  Go·Other·dormant·11 years agoarchived

• lanyrd/mysql-postgresql-converter on GitHub, opens in a new tab

  1.3Kstars

  Lanyrd's MySQL to PostgreSQL conversion script.

  Python·BSD 2-Clause "Simplified" License·dormant·4 years ago

• CrunchyData/pgmonitor on GitHub, opens in a new tab

  713stars

  Postgres metrics collection and visualization that can be deployed to bare metal, virtual machines, or Kubernetes.

  PLpgSQL·Other·steady·4 months ago

• yandex/pgmigrate on GitHub, opens in a new tab

  668stars

  CLI tool to evolve schema migrations, developed by Yandex.

  Python·PostgreSQL License·active·2 months ago

• spotify/postgresql-metrics on GitHub, opens in a new tab

  598stars

  Tool that extracts and provides metrics for your PostgreSQL database.

  Python·Apache License 2.0·dormant·3 years ago

• postgrespro/zson on GitHub, opens in a new tab

  568stars

  PostgreSQL extension for transparent JSONB compression

  C·MIT License·dormant·3 years ago

• achiku/planter on GitHub, opens in a new tab

  556stars

  Generate PlantUML ER diagram textual description from PostgreSQL tables

  Go·MIT License·slowing·2 years ago

• the4thdoctor/pg_chameleon on GitHub, opens in a new tab

  439stars

  Real time replica from MySQL to PostgreSQL with optional type override migration and migration capabilities.

  Python·BSD 2-Clause "Simplified" License·active·3 months ago

• perseas/Pyrseas on GitHub, opens in a new tab

  406stars

  Postgres database schema versioning.

  Python·BSD 3-Clause "New" or "Revised" License·slowing·2 years ago

• lukasmartinelli/pgclimb on GitHub, opens in a new tab

  393stars

  Export data from PostgreSQL into different data formats.

  Go·MIT License·dormant·6 years ago

• dimitri/regresql on GitHub, opens in a new tab

  358stars

  Tool to build, maintain and execute a regression testing suite for SQL queries.

  Go·Other·active·3 months ago

• lob/pg_insights on GitHub, opens in a new tab

  310stars

  Convenient SQL for monitoring Postgres database health.

  TSQL·MIT License·dormant·7 years agoarchived

• gatewayd-io/gatewayd on GitHub, opens in a new tab

  288stars

  Cloud-native database gateway and framework for building data-driven applications. Like API gateways, for databases.

  Go·GNU Affero General Public License v3.0·active·7 days ago

• dalibo/ldap2pg on GitHub, opens in a new tab

  235stars

  Synchronize roles and privileges from YML and LDAP.

  Go·PostgreSQL License·active·4 weeks ago

• pgxn/pgxnclient on GitHub, opens in a new tab

  160stars

  Command line tool to interact with the PostgreSQL Extension Network

  Python·Other·slowing·2 years ago

• timescale/pgspot on GitHub, opens in a new tab

  147stars

  Spot vulnerabilities in PostgreSQL extension scripts.

  Python·PostgreSQL License·active·2 days ago

• ayarotsky/diesel-guard on GitHub, opens in a new tab

  120stars

  Linter for dangerous Postgres migration patterns in Diesel and SQLx.

  Rust·MIT License·active·3 hours ago

• gajus/pg-formatter on GitHub, opens in a new tab

  83stars

  A PostgreSQL SQL syntax beautifier (Node.js).

  TypeScript·Other·steady·5 months ago

• pg-spot-ops/pg-spot-operator on GitHub, opens in a new tab

  59stars

  A daemon to run stateful Postgres on cheap AWS Spot VMs

  Python·Apache License 2.0·active·3 weeks ago

• Particular/NServiceBus.SqlServer on GitHub, opens in a new tab

  47stars

  The NServiceBus.Transport.PostgreSql library allows .NET developers to use a PostgreSQL database as a message broker. (Commerical Software)

  C#·Other·active·3 days ago

• cbbrowne/pgcmp on GitHub, opens in a new tab

  46stars

  Tool to compare database schemas, with capability to accept some persistent differences

  Shell·Other·slowing·2 years ago

• multum/pg-differ on GitHub, opens in a new tab

  40stars

  Tool for easy initialization / updating of the structure of PostgreSQL tables, migration alternative (Node.js).

  JavaScript·MIT License·steady·6 months ago

• qail-io/qail on GitHub, opens in a new tab

  35stars

  rust-first typed AST pipeline for PostgreSQL with compile-time query checks and built-in tenant scoping.

  Rust·Apache License 2.0·active·10 hours ago

• jwdeitch/pg_migrate on GitHub, opens in a new tab

  32stars

  Manage PostgreSQL codebases and make VCS simple.

  C·MIT License·dormant·9 years ago

• kabirbaidhya/pglistend on GitHub, opens in a new tab

  30stars

  A lightweight PostgresSQL LISTEN/NOTIFY daemon built on top of node-postgres.

  JavaScript·MIT License·dormant·9 years ago

• mchristofides/pg_docs_bot on GitHub, opens in a new tab

  18stars

  Browser extension to redirect PostgreSQL docs links to the current version.

  JavaScript·MIT License·slowing·last year

• defnotwig/pg-safe-migrate on GitHub, opens in a new tab

  1stars

  Safety-first Node.js migration engine with advisory locks, SHA-256 drift detection, and 10 built-in lint rules for PostgreSQL.

  TypeScript·MIT License·steady·6 months ago