Community Guide to PostgreSQL GUI Tools/ja
その他のガイド
このページには、すでに古くなってしまった情報が含まれているかもしれません。最新化した要約記事が Database Administration, Reporting, and Light application development (2009-09-07) にもあるので参考にしてください。
オープンソース / フリーソフト
pgAdmin III
MS Windows, GNU/Linux, FreeBSD, Mac OS X, OpenBSD, Solaris
管理
pgAdmin III はオープンソースの PostgreSQL 管理ツールとして最も有名なものの1つです。簡単なSQLクエリの作成から複雑なデータベースの管理まで、多くのユーザのニーズを満たすことを目指して設計されています。
以下の機能をサポートしています。
- グラフィカルな管理インタフェース
- ユニコードの完全なサポート
- 高速でマルチスレッド化された SQL / ストアドプロシージャ / データの編集ツール
- PostgreSQL の全オブジェクトタイプのサポート
- 30以上の言語の翻訳メッセージ (日本語含む)
pgAdmin III は Windows インストーラに同梱されています。また、ローカルマシンのサーバだけではなく、遠隔マシンの別OS上のサーバも管理する事ができます。注意が必要なのは、バイナリのリリースが更新されていないプラットホームがあることです。最新版を領したい場合には、ソースコードからビルドすることも考慮に入れてください。
PGAccess
Most platforms
ERD
The original PostgreSQL GUI, with an MS Access-style database browser, written in Tcl/Tk. Allows browsing, adding and editing tables, views, functions, sequencese, databases, and users, as well as graphically-assisted queries. A form and report designer are also under development by the PGAccess team, who could use help from some more Tcl/Tk coders and doc writers. (JMB 11.2002)
PGAccess has not been actively maintained for some time.
phpPgAdmin
http://sourceforge.net/projects/phppgadmin
ウェブブラウザベース
管理
phpMyAdmin と同様のウェブブラウザベースのツールで、PostgreSQL の多くのオブジェクトを閲覧や編集できます。また、任意の SQL クエリの実行機能も持ちます。メンテナンスは phpPgAdmin team によって行われています。(JMB 11.2002).
phpPgAdmin と、その実行に必要な Apache や PHP パッケージは、スタックビルダを使うと手軽にインストールできます。スタックビルダはワン・クリック・インストーラに含まれています。
OpenOffice.org
http://dba.openoffice.org/drivers/postgresql/index.html
Windows, Linux, Solaris
上記URLからの引用です:
The postgresql SDBC Driver allows to use the postgresql database from OpenOffice.org without any wrapper layer such as odbc or jdbc. The current version 0.7.6 can be considerded as good beta quality ( with some known issues and missing features). The driver is aimed at the 1.1 OpenOffice.org and OpenOffice.org 2.x versions, it does not work with OOo1.0.x trees. The final aim is to have an easier to use, faster, more feature rich database driver than the jdbc-odbc solution. The current version should already allow this in most places.
The Red Hat Database Graphical Tools, RHDB Administrator and Visual Explain
http://sources.redhat.com/rhdb
Linux
管理
Red Hat has stood by their word and open-sourced their database tools which ship with Red Hat Database for the benefit of the PostgreSQL community. I haven't used these, a review would be nice. Developed by Red Hat, Inc. (JMB 11.2002)
Xpg: Java PostgreSQL client
Most platforms
管理
Java-based PostgreSQL database administrator, with access to tables and data entry, query interface and ability to export query results to HTML reports. Developed by Soluciones Kazak, in Spanish, but available in English as well. (JMB 11.2002)
(xpg has not been updated since 2004)
Mergeant
Linux, Unix
管理
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.
TOra, an Oracle tool with some PostgreSQL support
Linux & Windows
管理
An Oracle database administration interface, with limited ability to browse PostgreSQL databases (tables, views, and functions only). I'm told that if you have the Oracle libraries, Tora's sophisticated function editor will work for PostgreSQL as well. Developed by Henrik Johnson as a Quest Toad clone. (JMB 11.2002)
KNoda
FreeBSD & Linux
管理
knoda is a database frontend for KDE. It is based on hk_classes and is released under the GNU General Public License (GPL).
PGInhaler
http://pginhaler.ifrance.com/pginhaler/
管理
It's a free Java based PostgreSQL GUI. Haven't used it yet, but worth knowing about. (J.C.)
(PGInhaler has not been updated since 2002)
SQuirreL
http://squirrel-sql.sourceforge.net/
Macintosh/Windows
SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc.
AnySQL Maestro
http://www.sqlmaestro.com/products/anysql/maestro/
Windows
AnySQL Maestro is a freeware tool for administering any database engine (PostgreSQL, SQL Server, Oracle, MySQL, MS Access, etc.), which is accessible via ODBC driver or OLE DB provider. Includes Database Designer, Visual Query Builder, BLOB Viewer/Editor, SQL Editor, Data export/import and other features.
SQL Workbench/J
Java (multi-platform)
An OpenSource SQL GUI tool similar to Squirrel. Data can be edited directly in the result set. It has strong support for exporting and importing data between databases using its own SQL command extension. It can be used in GUI mode or as a console application. All SQL Workbench specific commands can also be run in batch mode to automate export and import task. It supports schema comparison ("diff") and copying data between databases.
PostgreSQL PHP Generator
http://www.sqlmaestro.com/products/postgresql/phpgenerator/
Windows
PostgreSQL PHP Generator is a freeware but powerful PostgreSQL GUI frontend that allows you to generate high-quality PHP scripts for the selected tables, views and queries for the further working with these objects through the web.
WaveMaker Ajax GUI Design Tool
Windows, Macintosh, Linux
WaveMaker is an Ajax-based GUI design tool for Postgres. WaveMaker is built using itself! WaveMaker generates a standard Java WAR file based on Spring, Hibernate and Dojo. WaveMaker supports Postgres schema creation and import and includes a visual query editor.
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...
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.
プロプライエタリ
dbForge Studio for PostgreSQL
https://www.devart.com/dbforge/postgresql/studio/download.html
dbForge Studio for PostgreSQL is a brand new tool for PostgreSQL database development, management, and editing process enjoyable and easy by Devart. The PostgreSQL IDE allows users to create, develop, and execute queries, edit and adjust the code to the requirements in a convenient and UI. The tool provides the PostgreSQL data editor functionality for queries customization and property window for viewing all the required information of PostgreSQL database objects.
dbForge Data Compare for PostgreSQL
https://www.devart.com/dbforge/postgresql/datacompare/download.html
dbForge Data Compare for PostgreSQL is a GUI tool for table data comparison and synchronization. This PostgreSQL compare tool helps to custom-tailor the detection of data differences between two PostgreSQL tables, and establish smart management, and safe deployment of table data inconsistencies. The PostgreSQL diff tool also delivers the generation of the PostgreSQL data synchronization scripts with multiple options to keep PostgreSQL data in sync.
dbForge Schema Compare for PostgreSQL
https://www.devart.com/dbforge/postgresql/schemacompare/download.html
dbForge Schema Compare for Amazon Redshift/PostgreSQL is a tool for easy and effective comparison and deployment of Redshift database structure differences. The tool gives a comprehensive view of all differences in Amazon Redshift database schemas and generates clear and accurate SQL synchronization scripts to update the database schemas.
Lightning Admin for PostgreSQL
http://www.amsoftwaredesign.com/lightning_admin
Windows (それ以外のプラットホームでは WINE を利用)
管理
Lightning Admin is one of the best GUI admin tools available and sports a modern tabbed MDI interface and is the least expensive full featured GUI admin tool on the market. Compare to Navicat or EMS and save big. Current price is $19.99 per user.
Borland Kylix
Linux
ERD
driver: http://www.vitavoom.com/Products/pgExpress_Driver/index.html
The third most popular IDE for Linux, according to a recent Linux Journal poll. Focuses on interface-building for database applications, with some support for browsing database objects (I think). PostgreSQL native drivers are available free from Vita Voom Software. (JMB 11.2002)
DBOne
Windows
管理
DBOne is a shareware Database Administration Tool for PostgreSQL and Oracle, MSSQL, Sybase, DB2, SAPDB, Interbase/Firbird, MySQL.
DBTools Manager
Windows
管理
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. Developed by DBTools Software.
PgManager
http://www.ems-hitech.com/pgmanager
Windows, Linux version just released
管理
Basically a proprietary, more powerful version of PGAdmin II or PGAccess. Adds support for trigger and constraint editing, metadata logging, and query monitoring. Also includes multiple-format data import/export tools, which are also available on their own for Linux. Developed by EMS Hitech. (JMB 4.2003).
Rekall
http://www.thekompany.com/products/rekall
Linux
ERD
Designed by The Kompany as a Linux-based competitor to MS Access, this simple interface and database interface-builder is unfortunately designed for MySQL and has some problems with PostgreSQL. Was still buggy in May 2002, but may be improved by now. Supports limited browsing of database objects, creation of data entry forms and reports. (JMB 11.2002)
Data Architect
http://www.thekompany.com/products/dataarchitect
Linux
ERD
I'm trying DataArchitect 2 from theKompany now for 6 month. Highly recommended if you want an easy to use DB-Design Tool, but generated SQL-Scripts needs some rework. PostgreSQL is supported, you easily can create Stored Procedures, Foreign Keys, Views and Triggers. (Bernd, 1.2003)
SyBase Power Designer
http://www.sybase.com/products/enterprisemodeling/powerdesigner
管理
Sybase PowerDesigner is power tool with built in PostgreSQL support. It support tables, views, triggers, constraints and referential integrity. More advanced than Data Architect.
Microsoft Access
Windows + ODBC only
ERD, 管理
Yes, you can use MS Access as a PostgreSQL database interface. Supports data access to PostgreSQL tables and views; many ODBC-based limitations and errors. I don't need to tell anyone what MS Access' other capabilities are. (JMB 11.2002)
eRWin
http://www.ca.com/products/alm/erwin.htm
Windows
ERD
Apparently a high-end tool by Computer Associates with PostgreSQL support as a downloadable addon for some version(s). Haven't tried this. JC
DeZign for Databases
Windows
ERD
DeZign is a database development tool using an entity relationship diagram. It visually supports the lay out of the entities and relations and automatically generates SQL schemas for most leading databases including PostgreSQL.
ERBuilder Data Modeler
https://soft-builder.com/erbuilder-data-modeler/
Windows
ERD
ERBuilder Data Modeler is a GUI data modeling tool that allows developers to visualize, design, and model databases by using entity relationship diagrams and automatically generates the most popular SQL databases. Generate and share the data Model documentation with your team. Optimize your data model by using advanced features such as test data generation, schema compare, and schema synchronization.
PGExplorer
Windows (Shareware)
管理
NOTE this software is not maintained and has not had a new release in many years. Because of it's age it does not support schemas on PGSQL versions 7.3 and up.
Postgres Explorer is a full-featured GUI postgres development tool. Features include a tree view of your databases, and database objects. You can reverse engineer SQL statements from your database objects , modify the SQL and execute it. Wizards will guide you through the process to generate SQL for various objects and statements. The latest release includes a Graphical Select Query Designer (anonymous, 4.2003)
Case Studio 2
Windows
ERD
I just downloaded the trial version, so far it looks real promising and claims to support PostgreSQL. Handles reverse engineering of existing databases, and has a real nice interface for setting up tables, relationships etc. You can get a lite or full version. The description from the website... Professional database modeling tool for various databases. CASE Studio 2 includes following key features:
LITE version features + Reverse Engineering from various database systems Version Manager Data Flow Diagrams Definition of user defined variables Large COM interface Users, User groups and User permission support and many more.
pgEdit
Macintosh/Windows
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.
RazorSQL
Macintosh/Windows/Linux/Solaris
RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool that supports PostgreSQL and any other JDBC or ODBC compliant database. Some of the major features are tools for creating, dropping, and altering objects such as tables, views, indexes, triggers, functions, users, and databases; a programming editor that supports 20 different programming languages; import and export tools; auto column and table lookup; and a query builder, query scheduler, and SQL formatter.
MicroOLAP Database Designer
http://www.microolap.com/products/database/postgresql-designer/
Windows ODBC
Database Designer for PostgreSQL is an easy CASE tool with intuitive graphical interface allowing you to build a clear and effective database structure visually, see the complete picture (diagram) representing all the tables, references between them, views, stored procedures and other objects. Then you can easily generate a physical database on a server, modify it according to any changes you made to the diagram using fast ALTER statements.
Aqua Data Studio
http://www.aquafold.com/index-postgresql.html
Java: Windows/Linux/Macintosh OSX/Solaris
Aqua Data Studio is a management tool for the PostgreSQL relational database w/ administration capabilities and a database query tool. The visual administration features provide users the ability to browse and modify database structures, including schema objects, database storage and maintain database security. An integrated query tool allows users to quickly create, edit and execute SQL queries and scripts. Aqua Data Studio also provides an import and export tool to allow users to easily move data in and out of the PostgreSQL database in and from different data formats.
EMS SQL Management Studio for PostgreSQL
http://www.sqlmanager.net/en/products/studio/postgresql
Windows
EMS SQL Management Studio for PostgreSQL is a complete solution for PostgreSQL database administration and development. With components that focus on all critical PostgreSQL database management tasks, SQL Studio is a single workbench that provides you with must-have tools for administering PostgreSQL databases, managing database schema and objects as well as for PostgreSQL database design, migration, extraction, PostgreSQL query building, data import, export and database comparison. SQL Studio unites these database tools for PostgreSQL in one powerful and easy-to-use environment that can work round the clock. With SQL Management Studio many database administration objectives, such as migration, data loading and synchronization, database backup and extraction can be automated, allowing PostgreSQL database administrators and PostgreSQL application developers to perform complex tasks on a regular basis with the minimum number of efforts and a high level of flexibility.
https://jp.navicat.com/products/navicat-for-postgresql
Windows/Macintosh OSX/Linux
Navicat は PostgreSQL データベースサーバの管理や開発のための強力なツールです。PostgreSQL バージョン 7.3 以降に対応し、Amazon RDSやAmazon Redshiftのようなクラウドデータベース、そして全てのPostgreSQLデータベースオブジェクトをサポートしています(トリガ, 関数, ビュー, ユーザ管理 等)。熟練したユーザだけではなく、初心者ユーザでも使い方を容易に学ぶことができます。GUI も使いやすく、Navicat を使えば、すばやく安全に情報の作成、管理、閲覧をすることができるでしょう。
Navicat for PostgreSQL is an easy-to-use graphical tool for PostgreSQL database administration. Create and execute queries and functions with a powerful SQL Editor, and manage data with versatile data editing tools. Navicat for PostgreSQL can connect to any local/remote PostgreSQL database servers from version 7.3 or above. It supports Cloud Databases like Amazon RDS and Amazon Redshift, and all PostgreSQL database objects. Navicat for PostgreSQL is designed with a wide range of users in mind, from those new to PostgreSQL to seasoned developers.
SQL Maestro Group products for PostgreSQL
http://www.sqlmaestro.com/products/postgresql/
Windows
SQL Maestro Group offers a number of tools for PostgreSQL.
- PostgreSQL Maestro allows you to create, edit, copy, drop and dump database objects easy and fast. You can also design your database as ER diagram, build queries visually, execute SQL queries and scripts, debug PL/pgSQL functions, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, analyze your data summarized into multidimensional views and hierarchies (OLAP cubes), manage PostgreSQL roles, users, groups and privileges, and use a lot of other admin tools designed for making your work with PostgreSQL database server comfortable and efficient.
- PostgreSQL Data Wizard provides you with a number of easy-to-use wizards to generate PHP and ASP.NET scripts for the selected tables, views and queries, convert any ADO-compatible database to the PostgreSQL database, export data from PostgreSQL tables, views and queries to most popular formats, and import data into the tables.
- PostgreSQL Code Factory is a GUI tool aimed at the SQL queries and scripts development.
SQL Maestro Group also produces similar tools for MySQL, Oracle, MS SQL Server, DB2, SQL Anywhere, SQLite, Firebird and MaxDB.
DB Data Difftective PostgreSQL Edition
http://www.datanamic.com/datadiff/index.html
Windows
DB Data Difftective is a utility for data comparison and synchronization. Compare data for selected tables in two databases, view differences and publish changes quickly and safely. Flexible comparison and synchronization settings will enable you to set up a customized comparison key and to select tables and fields for comparison and for synchronization. DB Data Difftective can be used for data migrations, verification of (corrupt) data, data auditing etc.
DB Schema Difftective PostgreSQL Edition
http://www.datanamic.com/schemadiff/index.html
Windows
DB Schema Difftective is a tool for comparison and synchronization of database schemas. It allows you to compare and synchronize tables, views, functions, sequences (generators), stored procedures, triggers and constraints between two databases.
DB MultiRun PostgreSQL Edition
http://www.datanamic.com/multirun/index.html
Windows
DB MultiRun is a simple tool to execute multiple SQL scripts on multiple databases quickly. Define a list of databases, add SQL scripts to execute on these databases and click "execute" to run those scripts on the databases in the list. The multi-threaded execution of the SQL scripts makes it complete the task fast. After execution of the scripts you can examine the results of the executed scripts on each database.
SQLPro
http://www.vive.net/products/sqlpro.htm
Windows
SqlPro is an easy to use database GUI tool for six popular databases (Oracle, MySQL, PostgreSQL, SQL Server, SQLite and Access). One IDE makes database administration and development faster and error free. SQLPro Key Features: color-coding of the SQL, drag-and-drop of objects into the editor pane to save you from typing their names, retrieval of SQL code for things like stored procedures and triggers from the underlying database, and one-click creation of SELECT and INSERT statements. You can open, save and print SQL scripts. SQLPro uses native drivers to connect to the databases (no ODBS or third party engines to install).
SQL Image Viewer
Windows
SQL Image Viewer allows you to retrieve, view, convert and export images stored in Firebird, MySQL, Oracle, SQLite, SQL Server, and various ODBC-supported databases (e.g. DB2 and PostgreSQL). It supports the following image formats: BMP, GIF, JPG, PNG, PSD, and TIFF.
It also allows you to export binary data, and recognises the following binary file types: PDF, MP3, WAV, 7Z, BZ2, GZ, RAR, ZIP, and has experimental support for DOC, PPT and XLS file types.
Younicycle, the SaaS for Knowledge Management & CMS
Online CMS & Knowledge Management System
Any recent browser with FlashPlayer
Younicycle, the SaaS Platform provides a variety of tools that allow Novice users to collaborate with Experts.
- Younicycle (see Screenshots) Provides an integrated set of GUI tools designed to allow PostgreSQL Novices to effectively collaborate with more advanced PG Users. Includes a Table Editor (unlimited Tables), a graphical Query Builder and a Functions Editor. Designed initially to be an alternative to Filemaker, but has continued to advance beyond that goal. Additional, integrated tools include Php (Actions Editor), WYSIWYG Web site Design, Pdf - Report Design & creation tool(with variable data print), internal chat, datasources, dynamic charts, hosting, publish to web, css/js editor, QRCode generator, CRON, ACL with Role based permissions + additional ancillary tools. All created content can be 'bundled' with the internal SaaS Manager and installed in other accounts (or server installations) with a click. The end result is an online Knowledge Management and Content Management System allowing 'Novices' to see and work with PG within an integrated environment. Free - 15 day trial account without credit card info. Also available as a server install (Linux only).
- Server Packages Available for Linux. Any Solution that is created via the SaaS (online vsn) can be installed into a local server version (or vice versa, with a click of the mouse.
- Video Tutorials A few video tutorials are available. GoToMeeting scheduling is also available.
DbVisualizer
Windows/Mac OS X/Linux/UNIX
DbVisualizer is a feature rich, intuitive multi-database tool for developers, analysts and database administrators, providing a single powerful interface across a wide variety of operating systems. With its easy-to-use and clean interface, DbVisualizer has proven to be one of the most effective database tools available, yet to mention that it runs on all major operating systems and supports all major RDBMS that are available. Users only need to learn and master one application. DbVisualizer integrates transparently with the operating system being used.
