Community Guide to PostgreSQL Tools Abandoned
This is a list of Postgres Tools (of any type and flavor, and OS) that appear to not be maintained (i.e. had a release in the last 5 years).
Obsolete or End-of-Life
Alternate Guides
Another detailed summary from 2009 is available at Database Administration, Reporting, and Light application development
pgdesigner
http://pgdesigner.sourceforge.net/en/index.html
Druid III
Java (multi-platform)
The druid is a tools that allows users to create databases in a graphical way. The user can add tables, fields, folders to group tables and can modify most of the database options that follow the SQL-92 standard. In addition to sql options, the user can document each table and each field with HTML information. Once the database is created, the druid can generate:
- HTML documentation: for all tables, with browsing facilities
- PDF documentation: for all tables
- Java classes: (one class for each table) that contain tables' constants (such as fields size) plus java code added by the user
- A data dictionarythat contains all tables and fields present in the database
- SQL script which contains all table definitions that can be piped to the DBMS
- And much more info...
Last update: 2006
Open Source CMS
http://www.risetobloome.com/Page_1_S.aspx?ITEM=2017
Windows
The CMS is a free Visual Studio 2010 solution template with a set of projects providing a complete Content Management System (CMS) based on RISE Visual Modeling with model, full source, sample site and DB-scripts for PostgreSQL, MySQL and SQL Server.
It’s a complete ready-to-run Visual Studio solution with model, source code and web clients. It illustrates how to use RISE, how to implement a SOA backend and how to build RIA frontends.
Last update: 2014
Power*Architect
http://www.sqlpower.ca/page/architect
Java (multi-platform)
Power*Architect is an ERD modelling tool that is based on Java and JDBC. Support for forward and reverse engineering PostgreSQL databases is supported. It's OpenSource with a GPL license.
Last update: 2014
RISE PostgreSQL code generator
http://www.risetobloome.com/Page_1_S.aspx?ITEM=1889
Windows only
The RISE PostgreSQL code generator generates native PL/pgSQL scripts. Model your information in the free RISE Editor and generate your database script from your models. The script incrementally updates the tables, columns, indexes and constraints in the database to match the RISE model. Once the database model is updated, the views defined in the RISE model are created in the database and possible default data, entered in the model, is inserted.
Last update: 2014
Marshal SQL Utility
http://www.risetobloome.com/Page_1_S.aspx?ITEM=1756
Windows
The Marshal SQL Utility is a generic cross database utility with batch execution capabilities. It allows you to test ODBC connections, browse database schemas, discover tables, views and columns.
Key features of Marshal SQL Utility:
- Execute any query supported by your database server
- Execute batches of queries
- Discover tables and views in your database
- Discover columns for a selected table or view
- Supports BLOBS and CLOBS
- Save your results to file
- Use any ODBC compliant database such as PostgreSQL.
RISE PHP for PostgreSQL code generator
http://www.risetobloome.com/Page_1_S.aspx?ITEM=1888
Windows
The RISE PHP for PostgreSQL code generator renders PHP source code for database access. Model your information and programming interfaces in the free RISE Editor and generate your code. The generated code implements the classes and methods corresponding to the information interfaces specified in the RISE model. This includes classes for database access and, optionally, classes implementing SOAP/JSON web services and proxy classes assisting the implementation of a PHP SOAP client.
RISE - Model Driven Development using ERD / UML
Windows
RISE is a free software suite for model driven information system development. Use a single source RISE model to generate your entire information solution including database, web services and documentation. Boost development throughput and improve quality and maintainability!
The RISE user experience is based on a project concept, similar to that of most integrated development environments. The user works with resources and drawings that are part of a single development project.
RISE supports a fully graphical approach to information modeling and system engineering, using ERD (Entity Relationship Diagram) as well as UML (Unified Modeling Language). This includes drag-and-drop of entities, their attributes and relations, as well as of views and entire web services.
RISE supports graphic editing of complex objects such as views and orchestrated methods. RISE automatically safeguards the combination process, thus, assuring a technically correct result.
RISE provides several ways to generate code from the model; directly to file, via the RISE Server or as an Internet service. RISE provides code generators for the database layer (SQL/DDL) as well as for the server side application layer (web services and persistent classes). All database scripts are incremental allowing you to install and maintain any number of databases from a single model.
Feature list http://www.risetobloome.com/Page_1_S.aspx?ITEM=1355
openOffice
- OpenOffice postgresql SDBC Driver. no work on the project since 2010; last version was a beta. http://www.openoffice.org/dba/drivers/postgresql/index.html
RedHat
- RedHat: hasn't been refreshed since Pg 8.4. http://sources.redhat.com/rhdb
pgEdit
Not a standalone client, rather a plugin for Textmate for using psql.
DBTools Manager
Freeware, available for PostgreSQL and MySQL, allows managing all aspects of the database: db, table, triggers, functions, etc. Includes import/export wizards to migrate data and structure to/from other database engines.
Marshal SQL Utility
http://www.risetobloome.com/Page_1_S.aspx?ITEM=1756
The Marshal SQL Utility is a generic cross database utility with batch execution capabilities. It allows you to test ODBC connections, browse database schemas, discover tables, views and columns.
VSQL++ for PostgreSQL
http://www.sqlpp.com/products/postgresql-management/
A powerful Postgresql database management tool to help DBA sto manage the database objects easy and quickly.
PGExplorer
Hasn't been significantly updated in many years, but latest downloads suggest it may support Postgresql 9.* to some extent.
Gnome DB
Database administration/user tool for GNOME, based on libgda/libgnomedb, which are a complete database-independent access layer for UNIX systems, with support for PostgreSQL, MySQL, Sybase, MS SQL Server, Oracle, Interbase/Firebird, MS Access files, xBase.
Has an experimental Windows build available too.
Druid III
Java
The druid is a tools that allows users to create databases in a graphical way. The user can add tables, fields, folders to group tables and can modify most of the database options that follow the SQL-92 standard. In addition to sql options, the user can document each table and each field with HTML information.
SQLTool Pro Database Editor
Android
SQLTool Pro is a professional Android SQL editor for MySQL, SQL Server, PostgreSQL, Sybase, and Oracle Databases.
pgEdit
Macintosh pgEdit is a high-performance SQL editor and development environment designed specifically for PostgreSQL relational databases. pgEdit features include SQL syntax coloring, direct source code execution, PHP support, integrated documentation, and extensive customizable editing facilities.
pgEdit uses psql, the interactive terminal application included with every PostgreSQL installation. This makes it easy to develop with pgEdit and then transfer your work to any PostgreSQL installation for maintenance and production tasks.
pgEdit is a native application for both Macintosh and Windows. It does not use Java or require installation of external libraries. You have the option of using the version of psql included with pgEdit or a different version installed anywhere on your hard drive.
DB Designer Fork
https://sourceforge.net/projects/dbdesigner-fork/
DB Designer Fork is a fork of the fabFORCE DBDesigner 4. It integrates entity relationship design,front-end (you can run queries) and SQL exporting.DB Designer Fork generates SQL scripts for Oracle, SQL Server, MySQL, FireBird, SQLite and PostgreSQL.
ModelRight
ModelRight allows you to graphically view your database, enforce complex constraints, manage database views, validate design decisions, and generate complete CREATE and ALTER scripts.
Docs mention support for Windows 7 and PostgreSQL 9.0.
dbmstools
https://github.com/charlesnagy/xml2ddl
Python, uses XML as the one true format and generates migration scripts from that.
SchemaSpy
http://schemaspy.sourceforge.net
Java, LGPL
SchemaSpy analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams.
