pgweb - Web-based PostgreSQL database browser written in 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

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

---

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

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

---

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

PostGIS - Spatial and Geographic objects for PostgreSQL

---

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

---

Contribution and issues reports are very appreciated.

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

pgAdmin - Administration and development platform for PostgreSQL

---

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

Npgsql -.NET data provider for PostgreSQL.

---

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

---

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

DBGlass - PostgreSQL client built with Electron.

---

Cross platform GUI PostgreSQL client

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

DBeaver - Universal SQL Manager and SQL Client

---

DBeaver is a multi-platform database tool for developers, SQL programmers, database administrators and analysts. It supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, Teradata, MongoDB, Cassandra, Redis, etc. Its feature include metadata editor, SQL editor, rich data editor, ERD, data export/import/migration, SQL execution plans, etc.

database-tool database-management database-administration sql-client

PostgreSQL - Powerful, Open Source Object-Relational Database System

---

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It has native programming interfaces for most of the programming language.

database postgres postgresql sql rdbms relational-database

HeidiSQL - A lightweight client for managing MySQL, MSSQL and PostgreSQL, written in Delphi

---

HeidiSQL is a useful and reliable tool designed for web developers using the popular MySQL server, Microsoft SQL databases, PostgreSQL and MariaDB. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. Also, you can export structure and data, either to SQL file, clipboard or to other servers. Read about features or see some screenshots. Look at the online help page for learning how to use HeidiSQL.

mysql delphi mssql postgresql sql mariadb

Kallax - PostgreSQL typesafe ORM for the Go language

---

Kallax is a PostgreSQL typesafe ORM for the Go language. It aims to provide a way of programmatically write queries and interact with a PostgreSQL database without having to write a single line of SQL, use strings to refer to columns and use values of any type in queries.

orm database-library postgres-library postgres-orm

SQuirreL SQL - Universal SQL Client

---

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. SQuirreL's functionality can be extended through the use of plugins.

sql-client database-tool database-admin admin mysql postgresql

node-postgres - PostgreSQL client for node.js.

---

PostgreSQL client - pure javascript & libpq with the same API

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

LibreOffice - The Document foundation

---

LibreOffice is the free power-packed Open Source personal productivity suite for Windows, Macintosh and Linux. LibreOffice is the perfect choice for home users, businesses, government and other organizations. It's native file format is the ISO standardized ODF (Open Document Format), but LibreOffice can open and save Microsoft Word, PowerPoint and Excel files, as well as many other formats, bringing you the widest-available compatibility with other products.

office-suite document office word excel graphics-editor

libpqxx - The official C++ client API for PostgreSQL

---

Welcome to libpqxx, the C++ API to the PostgreSQL database management system.This package requires PostgreSQL to be installed -- including the C headers for client development. The library builds on top of PostgreSQL's standard C API, libpq, though this fact is almost completely hidden from programs that use libpqxx.

postgresql-client postgresql-driver postgres

db - Productive data access layer for Go.

---

The upper.io/db.v3 package for Go is a productive data access layer for Go that provides a common interface to work with different data sources such as PostgreSQL, MySQL, SQLite, MSSQL, QL and MongoDB.Take the tour to see real live examples in your browser.

orm database sql upper db postgresql mysql nosql sqlite mongodb dal database-library go-orm

Bookshelf - A simple Node.js ORM for PostgreSQL, MySQL and SQLite3 built on top of Knex.js

---

Bookshelf is a JavaScript ORM for Node.js, built on the Knex SQL query builder. Featuring both promise based and traditional callback interfaces, providing transaction support, eager/nested-eager relation loading, polymorphic associations, and support for one-to-one, one-to-many, and many-to-many relations. It is designed to work well with PostgreSQL, MySQL, and SQLite3.

bookshelf database mysql postgresql sqlite nodejs orm datamapper active-record

rust-postgres - Native PostgreSQL driver for the Rust programming language

---

A native PostgreSQL driver for Rust.Rust-Postgres is a pure-Rust frontend for the popular PostgreSQL database.

postgresql-client postgresql-driver postgresql-library postgres