Ecosystem:Database administration/development

From PostgreSQL wiki

Jump to: navigation, search

Contents

Access

  • Provider -- Microsoft Corporation
  • Website -- https://products.office.com/en-us/access
  • License -- proprietary
  • Interoperability level -- interoperable via generic ODBC connection
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- Access is an easy-to-use tool for creating business applications, from templates or from scratch. With its rich and intuitive design tools, Access can help you create appealing and highly functional applications in a minimal amount of time.
  • Additional info -- click here

Aqua Data Studio

  • Provider -- AquaFold, Inc.
  • Website -- https://www.aquafold.com/aquadatastudio
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 9.x, 10.4
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- Aqua Data Studio is the universal database integrated development environment (IDE) for Database Developers, DBAs, and Analysts. It allows you to develop, access, manage, and visually analyze data. Whether you are working with relational, NoSQL, or cloud databases, your data is easily and quickly accessible with Aqua Data Studio.
  • Additional info -- click here

Database .NET

  • Provider -- fish, Taiwan
  • Website -- https://fishcodelib.com/Database.htm
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 8 and higher
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- Database .NET is an innovative, powerful and intuitive multiple database management tool. You can browse/grant objects, design tables, edit rows, run queries, generate scripts, analyze/monitor SQL and import/export/migrate/sync data with a consistent interface.
  • Additional info -- click here

Database Master

  • Provider -- Nucleon Software
  • Website -- http://nucleonsoftware.com/products/database-master
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 8.x and higher
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- Nucleon Database Master is a modern, powerful, intuitive and easy to use database query, administration, and management software with a consistent and modern user interface. Database Master simplifies managing, monitoring, querying, editing, visualizing, designing relational and NoSQL DBMS. Database Master allows you to execute extended SQL, MongoDB and Linq(C#) Scripts, provides all database objects such as tables, views, procedures, packages, columns, indexes, relationships (constraints), collections and triggers. Database Master provides powerful and intuitive extended JSON query editor for MongoDB database queries. It supports most used MongoDB query operations and commands. JSON Query Editor is multi-threaded and allows long running queries and return multiple result sets. The query editor supports JSON IntelliSense (Code Completion, Query Operators and Methods), code highlighting, text find and replace functions and other user-friendly features.
  • Additional info -- click here

DB Doc

  • Provider -- Yohz Software
  • Website -- http://www.yohz.com/dbdoc_details.htm
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 10 or higher
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- DB Doc is the only PostgreSQL documentation tool you’ll ever need, to generate pgsql documentation in HTML, PDF, XML, DOCX, and CHM formats, customize the documentation layouts to your needs, automate the documentation generation process so that you could even generate your database schema documents every hour, ensuring you’ll always have the most up-to-date details.
  • Additional info -- click here

dbForge Studio for PostgreSQL

  • Provider -- Devart
  • Website -- https://www.devart.com/dbforge/postgresql/studio/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 8.1 or higher
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- The GUI tool is designed for managing and developing databases and objects in PostgreSQL, as well as for creating and executing queries, and adjusting the code to your requirements in a user-friendly interface.
  • Additional info -- click here

DBManager

  • Provider -- DBTools Software
  • Website -- http://www.dbtools.com.br/EN/dbmanagerpro/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL (version unknown)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- The DBManager is the most powerful application for data management. With builtin support for MySQL, PostgreSQL, Interbase/Firebird, SQLite, DBF tables, MSAccess, MSSQL Server, Sybase, Oracle and ODBC database engines, it also brings you new features which make it the most advanced application. It comes in two editions so you can choose the one that will fit your needs: Standard and Enterprise. The Standard edition is totally functional and some features are not even available in any other free software for database management. The Enterprise Edition is a commercial product, although inexpensive, if compared with other commercial products available in the market.
  • Additional info -- click here

DbSchema

  • Provider -- Wise Coders Solutions
  • Website -- https://dbschema.com/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL (version unknown)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- You don't have to be an database expert to manage complex databases. DbSchema has everything you need to visually design, document and query relational and NoSQL databases.
  • Additional info -- click here

DbVisualizer

  • Provider -- DbVis Software AB
  • Website -- https://www.dbvis.com/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 8 - 11
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- DbVisualizer is the universal database tool for developers, DBAs and analysts. DbVisualizer runs on all the major platforms, Windows, macOS, and Linux. SQL editor with support for auto completion, parameterized SQLs, SQL formatter, visual query builder, explain plan, and, a command-line based interface.
  • Additional info -- click here

DbWrench

  • Provider -- Nizana Systems
  • Website -- http://www.dbwrench.com/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL (version unknown)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- A database design and synchronizationtool. Guaranteed to save you time with your database tasks. DbWrench handles the details so you can focus on your design.
  • Additional info -- click here

DeZign for Databases

  • Provider -- Datanamic Solutions
  • Website -- https://www.datanamic.com/dezign/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 7 - 11
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- Data modeling for database professionals. Visualize database structures to understand your database, create new databases or reverse-engineer existing databases to modify, document, analyze, and optimize.
  • Additional info -- click here

EMS SQL Management Studio for PostgreSQL

  • Provider -- EMS Software Development, LLC
  • Website -- https://www.sqlmanager.net/en/products/postgresql/manager
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 7.3 or higher
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- EMS SQL Manager for PostgreSQL is a high performance tool for PostgreSQL database administration and development. It works with any PostgreSQL versions up to the newest one and supports the latest PostgreSQL features including exclusion constrains, ‘when’ clause of triggers, functions returning table, and others. SQL Manager for PostgreSQL offers plenty of powerful database tools such as Visual Database Designer to create PostgreSQL database in few clicks, Visual Query Builder to build complicated PostgreSQL queries, powerful BLOB editor and many more useful features for efficient PostgreSQL administration. SQL Manager for PostgreSQL has a state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.
  • Additional info -- click here

LibreOffice Base

  • Provider -- The Document Foundation
  • Website -- https://www.libreoffice.org/discover/base/
  • License -- open source (Mozilla Public License v2.0)
  • Interoperability level -- explicitly supports PostgreSQL 8.4 or higher
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- Base is a full-featured desktop database front end, designed to meet the needs of a broad array of users. Base caters to power users and enterprise requirements, providing native-support drivers for some of the most widely employed multi-user database engines: MySQL/MariaDB, Adabas D, MS Access and PostgreSQL. In addition, the built-in support for JDBC- and ODBC-standard drivers allows you to connect to virtually any other existing database engine as well.
  • Additional info -- click here

Navicat

  • Provider -- PremiumSoft CyberTech Ltd.
  • Website -- https://www.navicat.com/en/products/navicat-for-postgresql
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL (version unknown)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- Navicat for PostgreSQL is designed to accommodate a wide range of users, from PostgreSQL beginners to seasoned developers. Connect to local/remote PostgreSQL servers and compatible with cloud databases like Amazon Redshift, Amazon Aurora, Amazon RDS, Google Cloud and Microsoft Azure, and all PostgreSQL database objects.
  • Additional info -- click here

OmniDB

  • Provider -- 2ndQuadrant
  • Website -- https://www.2ndquadrant.com/
  • License -- MIT License
  • Interoperability level -- explicitly supports PostgreSQL 9.2 or higher
  • Verified PostgreSQL versions -- https://www.2ndquadrant.com/en/resources/omnidb/
  • Last update (YYYY-MM-DD) -- 2019-02-14
  • Description -- OmniDB is an interactive, open source web tool with a powerful yet lightweight design that simplifies database management. It was specifically created to provide a user-friendly interface for multiple databases.
  • Additional info -- click here

repmgr

  • Provider -- 2ndQuadrant
  • Website -- https://www.2ndquadrant.com/
  • License -- GPL v3
  • Interoperability level -- explicitly supports PostgreSQL 9.1 or higher
  • Verified PostgreSQL versions -- https://www.2ndquadrant.com/en/resources/repmgr/
  • Last update (YYYY-MM-DD) -- 2018-10-24
  • Description -- repmgr helps DBAs and System Administrators manage a cluster of PostgreSQL databases. It simplifies administration and daily management, enhances productivity and reduces the overall costs of a PostgreSQL cluster.
  • Additional info -- click here

SI Object Browser ER

  • Provider -- System Integrator Corp.
  • Website -- https://products.sint.co.jp/ober
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 9.0 - 9.6
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- SI Object Browser ER is a data modeling tool. This tool has the top track record in Japan as a data modeling tool using ER diagrams, such as "ER diagram creation", "Reflection to RDBMS (forward)", and "RDBMS schema information import (reverse)".
  • Additional info -- click here

SQL Power Architect

  • Provider -- SQL Power Group
  • Website -- http://www.bestofbi.com/page/architect
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 8.0 or higher
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- The SQL Power Architect data modeling tool was created by data warehouse designers and has many unique features geared specifically for the data warehouse architect. It allows users to reverse-engineer existing databases, perform data profiling on source databases, and auto-generate ETL metadata.
  • Additional info -- click here

SQL Workbench/J

  • Provider -- Thomas Kellerer
  • Website -- http://www.sql-workbench.eu/
  • License -- open source (a modified version of Apache License 2.0)
  • Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- SQL Workbench/J is a free, DBMS-independent, cross-platform SQL query tool. It is written in Java and should run on any operating system that provides a Java Runtime Environment. Its main focus is on running SQL scripts (either interactively or as a batch) and export/import features. Graphical query building or more advanced DBA tasks are not the focus and are not planned.
  • Additional info -- click here

SQuirreL SQL Client

  • Provider -- colbell, gerdwagner
  • Website -- http://squirrel-sql.sourceforge.net/
  • License -- open source (LGPLv2)
  • Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- 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.
  • Additional info -- click here

Toad Data Modeler

  • Provider -- Quest Software Inc.
  • Website -- http://www.toadworld.com/products/toad-data-modeler
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 9.0 - 11
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- Easy-to-use, multi-platform database modeling.
  • Additional info -- click here

Valentina Studio

  • Provider -- Paradigma Software
  • Website -- https://www.valentina-db.com/valentina-studio-overview
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL (version unknown)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- Valentina Studio is your universal database management tool for working with MySQL, MariaDB, SQL Server, PostgreSQL, SQLite and Valentina DB databases. Valentina Studio lets you connect with all major databases, run queries and generate diagrams to better understand your mission critical business data - and that is the free version of Valentina Studio.
  • Additional info -- click here

Vertabelo

  • Provider -- Vertabelo SA
  • Website -- https://www.vertabelo.com/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL 9.x
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- Web-based Data Modeler for Professionals
  • Additional info -- click here

WaveMaker

  • Provider -- WaveMaker, Inc.
  • Website -- https://www.wavemaker.com/
  • License -- proprietary
  • Interoperability level -- explicitly supports PostgreSQL (no specific version is specified)
  • Verified PostgreSQL versions -- didn't actually run the program, but just checked the documentation
  • Last update (YYYY-MM-DD) -- 2020-1-2
  • Description -- Build Scalable Apps, with Faster & Leaner Teams. Low-code solution for higher productivity.
  • Additional info -- click here
Personal tools