pgweb - Web-based PostgreSQL database browser written in Go

•    Go

---

Pgweb is a web-based database browser for PostgreSQL, written in Go. Main idea behind using Go for backend development is to utilize ability of the compiler to produce zero-dependency binaries for multiple platforms. Pgweb was created as an attempt to build very simple and portable application to work with local or remote PostgreSQL databases.

postgresql pgweb cross-platform postgresql-client postgresql-gui postgresql-admin postgresql-management postgres database-management

falcon-sql-client - Free, open-source SQL client for Windows and Mac 🦅

•    Javascript

---

Falcon in a free, open-source SQL editor with inline data visualization. It currently supports connecting to RedShift, MySQL, PostgreSQL, IBM DB2, Impala, MS SQL, and SQLite. Visit plot.ly to learn more or visit the Plotly forum.

electron visualization plotly sql mysql-client postgresql falcon redshift postgres elasticsearch drill s3 persistent connector

falcon - Free, open-source SQL client for Windows and Mac 🦅

•    Javascript

---

Falcon is a free, open-source SQL editor with inline data visualization. It currently supports connecting to RedShift, MySQL, PostgreSQL, IBM DB2, Impala, MS SQL, Oracle, SQLite and more (for connecting to Oracle, please, see here the instructions to install the required free Oracle Instant Client). Visit plot.ly to learn more or visit the Plotly forum.

electron visualization plotly sql mysql-client postgresql falcon redshift postgres elasticsearch drill s3 persistent connector

Timescaledb - An open-source time-series database optimized for fast ingest and complex queries

•    PLpgSQL

---

TimescaleDB is an open-source database designed to make SQL scalable for time-series data. It is engineered up from PostgreSQL, providing automatic partitioning across time and space (partitioning key), as well as full SQL support. TimescaleDB is packaged as a PostgreSQL extension and released under the Apache 2 open-source license.

time-series-database postgresql time-series sql postgres tsdb iot financial-analysis analytics database postgresql-extension

pgAdmin - Administration and development platform for PostgreSQL

•    C

---

pgAdmin is the most popular and feature rich administration and development platform for PostgreSQL. It is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more.

postgresql-admin database-admin database-tools postgresql-tools postgresql-management postgresql-gui database-management

ToroDB Stampede - Provides better analytics on top of MongoDB and make it easier to migrate from MongoDB to SQL

•    Java

---

ToroDB helps to transform your NoSQL data from a MongoDB replica set into a relational database in PostgreSQL. There are other solutions that are able to store the JSON document in a relational table using PostgreSQL JSON support, but it doesn't solve the real problem of 'how to really use that data'. ToroDB Stampede replicates the document structure in different relational tables and stores the document data in different tuples using those tables.

database nosql analytics mongodb-to-sql mongodb-to-postgres

PostGIS - Spatial and Geographic objects for PostgreSQL

•    C

---

PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL. PostGIS adds extra types (geometry, geography, raster and others) to the PostgreSQL database. It also adds functions, operators, and index enhancements that apply to these spatial types.

database geospatial-database spatial-database geospatial geospatial-analytics postgresql-extension

sqltabs - Rich SQL client for Postgresql, MySQL, MS SQL, Amazon Redshift

•    Javascript

---

Contribution and issues reports are very appreciated.

postgresql mysql mssql amazon-redshift postgresql-client postgresql-gui postgresql-admin postgresql-management postgres

Apache Superset is a Data Visualization and Data Exploration Platform

•    Python

---

Superset is fast, lightweight, intuitive, and loaded with options that make it easy for users of all skill sets to explore and visualize their data, from simple line charts to highly detailed geospatial charts. It easily integrates your data, using either our simple no-code viz builder or state of the art SQL IDE. Superset can query data from any SQL-speaking datastore or data engine (e.g. Presto or Athena) that has a Python DB-API driver and a SQLAlchemy dialect.

react flask data-science bi analytics superset apache data-visualization data-engineering business-intelligence data-viz data-analytics data-analysis sql-editor asf business-analytics

PolarDB - Share-nothing, Distributed database based on PostgreSQL

•    C

---

PolarDB for PostgreSQL (PolarDB for short) is an open-source database system based on PostgreSQL. It extends PostgreSQL to become a share-nothing distributed database, which supports global data consistency and ACID across database nodes, distributed SQL processing, and data redundancy and high availability through Paxos based replication.

database distributed-database rdbms postgresql

Npgsql -.NET data provider for PostgreSQL.

•    CSharp

---

Npgsql is a .NET data provider for PostgreSQL. It allows you to connect and interact with PostgreSQL server using .NET.For any additional information, please visit the Npgsql website at http://www.npgsql.org.

npgsql database postgresql postgres c-sharp sql postgresql-client postgresql-driver postgresql-library

phpMyFAQ - phpMyFAQ - Open Source FAQ system for PHP and MySQL, PostgreSQL and other databases

•    PHP

---

phpMyFAQ is a multilingual, completely database-driven FAQ-system. It supports various databases to store all data, PHP 5.6+ is needed in order to access this data. phpMyFAQ also offers a multi-language Content Management System with a WYSIWYG editor and an Image Manager, real time search support with Elasticsearch, flexible multi-user support with user and group based permissions on categories and records, a wiki-like revision feature, a news system, user-tracking, 40+ supported languages, enhanced automatic content negotiation, HTML5/CSS3 based responsive templates, PDF-support, a backup-system, a dynamic sitemap, related FAQs, tagging, RSS feeds, built-in spam protection systems, OpenLDAP and Microsoft Active Directory support, and an easy to use installation script. phpMyFAQ is only supported on PHP 5.6.0 and up, you need a database as well. Supported databases are MySQL, Percona Server, PostgreSQL, Microsoft SQL Server, SQLite3 and MariaDB. If you want to use Elasticsearch as main search engine, you need Elasticsearch 2.x as well. Check our detailed requirements on phpmyfaq.de for more information.

faq phpmyfaq mysql database postgresql sqlite mssql elasticsearch docker docker-compose

Tabix - SQL Editor & Open source simple business intelligence for Clickhouse.

•    Javascript

---

Tabix is a SQL Editor & Open source simple business intelligence for Clickhouse. No need to install, it works from the browser. It provides support to Draw charts, Maps of the world, Metrics RealTime charts from system.metrics, Displays database and tables as tree and lot more.

clickhouse sql-query dashboard data-visualization bi data-analysis business-intelligence sql-editor database-management

Barman - Backup and Recovery manager for PostgreSQL

•    Python

---

Barman (Backup and Recovery Manager) is an open source administration tool for disaster recovery of PostgreSQL servers . It allows your organisation to perform remote backups of multiple servers in business critical environments and to help DBAs during the recovery phase. Its features include backup catalogues, incremental backup, retention policies, remote backup and recovery, archiving and compression of WAL files and backups.

postgresql-tools database-backup backup disaster-recovery postgres-backup postgres-tools

pgcenter - Command-line admin tool for observing and troubleshooting Postgres.

•    Go

---

pgCenter is a command-line admin tool for observing and troubleshooting Postgres. Postgres provides various activity statistics that include detailed information about its behaviour: connections, statements, database operations, replication, resources usage and more. General purpose of the statistics is to help DBAs to monitor and troubleshoot Postgres. However, these statistics provided in textual form retrieved from SQL functions and views, and Postgres doesn't provide any tools for working with them. pgCenter's main goal is to help Postgres DBA manage statistics that theу have in their databases and see all the necessary data in convenient format based on builtin stats views and functions.

postgresql postgresql-statistics postgresql-admin

node-postgres - PostgreSQL client for node.js

•    Javascript

---

Non-blocking PostgreSQL client for Node.js. Pure JavaScript and optional native libpq bindings. It supports Connection pooling, PostgreSQL data-type coercion, Parameterized queries, Named statements with query plan caching, Async notifications with LISTEN/NOTIFY and lot more.

postgresql postgresql-driver node-postgres postgres libpq pg postgre database rdbms postgresql-client postgresql-library

massive-js - A data mapper for Node.js and PostgreSQL.

•    Javascript

---

Massive.js is a data mapper for Node.js that goes all in on PostgreSQL and fully embraces the power and flexibility of the SQL language and relational metaphors. Providing minimal abstractions for the interfaces and tools you already use, its goal is to do just enough to make working with your data as easy and intuitive as possible, then get out of your way. Massive is not an object-relational mapper (ORM)! It doesn't use models, it doesn't track state, and it doesn't limit you to a single entity-based metaphor for accessing and persisting data. Massive connects to your database and introspects its schemas to build an API for the data model you already have: your tables, views, functions, and easily-modified SQL scripts.

nodejs postgres postgresql database data-mapper sql promise pg datamapper promises

DBGlass - PostgreSQL client built with Electron.

•    Javascript

---

Cross platform GUI PostgreSQL client

electron react flux webpack react-hot postgresql-client postgresql-gui postgresql-admin postgresql-management postgres

redash - Make Your Company Data Driven

•    Python

---

Redash is our take on freeing the data within our company in a way that will better fit our culture and usage patterns. Prior to Redash, we tried to use traditional BI suites and discovered a set of bloated, technically challenged and slow tools/flows. What we were looking for was a more hacker'ish way to look at data, so we built one.

redash visualization analytics bi angular redshift bigquery athena mysql postgresql dashboard

pgModeler - PostgreSQL Database Modeler

•    C++

---

pgModeler - 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.

entity-relationship-diagram ddl-commands sql-standards database-tools postgres-tools postgresql