Open Source cross-platform SQL Editor and Database Manager. Use Beekeeper Studio to query and manage your relational databases, like MySQL, Postgres, SQLite, and SQL Server. Available for Windows, Mac, and Linux.
PostgresqlCO.NF (CONF for short) is a postgresql.conf documentation and ultimate recommendations’ source to help you tune and optimize all of your PostgreSQL configuration. With around 290 configuration parameters in postgresql.conf (and counting), it is definitely a difficult task!
migra is a schema comparison tool for PostgreSQL.
It's a command line tool, and Python library. Find differences in database schemas as easily as running a diff on two text files.
migra makes schema changes almost automatic. Management of database migration deployments becomes much easier, faster, and more reliable.
PostgreSQL Database Modeler is an open source data modeling tool designed for PostgreSQL. No more DDL commands written by hand let pgModeler do the job for you! This software reunites the concepts of entity-relationship diagrams and the features that PostgreSQL implements as extensions of SQL standards.
Free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports all popular databases: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc.
pg_chameleon is a MySQL to PostgreSQL replica system written in Python 3. The tool can connect to the mysql replication protocol and replicate the data changes in PostgreSQL. Whether the user needs to setup a permanent replica between MySQL and PostgreSQL or perform an engine migration, pg_chamaleon is the perfect tool for the job.
pgloader loads data into PostgreSQL and allows you to implement Continuous Migration from your current database to PostgreSQL.
pgLoader has two modes of operation. It can either load data from files, such as CSV or Fixed-File Format; or migrate a whole database to PostgreSQL.
pgLoader supports several RDBMS solutions as a migration source, and fetches information from the catalog tables over a connection to then create an equivalent schema in PostgreSQL. This means that you can migrate to PostgreSQL in a single command-line!
A template for PostgreSQL High Availability with ZooKeeper, etcd, or Consul.
skor is a utility for Postgres which calls a webhook with row changes as JSON whenever an INSERT, UPDATE or DELETE event occurs on a particular table. You can drop the docker image next to your Postgres database instance and configure a webhook that will be called.
It works using a pg_notify trigger function and a tiny C program skor that listens to the notifications and calls the configured webhook with a JSON payload.
pgBackRest aims to be a simple, reliable backup and restore system that can seamlessly scale up to the largest databases and workloads.
migra is a schema comparison tool for PostgreSQL.
It's a command line tool, and Python library. Find differences in database schemas as easily as running a diff on two text files.
Migra makes schema changes almost automatic. Management of database migration deployments becomes much easier, faster, and more reliable.
PostgreSQL schema documentation tool
repmgr is an open-source tool suite for managing replication and failover in a cluster of PostgreSQL servers. It enhances PostgreSQL's built-in hot-standby capabilities with tools to set up standby servers, monitor replication, and perform administrative tasks such as failover or manual switchover operations.
Metabase is the easy, open source way for everyone in your company to ask questions and learn from data.
Barman (Backup and Recovery Manager) is an open-source administration tool for disaster recovery of PostgreSQL servers written in Python. It allows your organization to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase.
The Postgresql object model manager for PHP
Pomm is an open source database access framework coupled with an Object Model Manager dedicated to the Postgresql™ database. It offers an alternative approach than ORM to using database in web developments.
Query Editor: think of JS Fiddle for SQL queries. It's your way to share data in the organization in an open way, by sharing both the dataset and the query that generated it.
Visualizations: once you have a dataset, you can create different visualizations out of it.
Dashboards: combine several visualizations into a single dashboard.
A tutorial covering SQL indexing and SQL tuning for developers: avoiding unnecessary details about database internals.
SQL indexing is the most effective SQL tuning method and requires the same care as schema design yet it is often neglected during development. Use The Index, Luke explains SQL indexing from the source code perspective—covering ORM tools like Hibernate and Doctrine.