Goat
|
Goat is essentially a universal JDBC Viewer/Editor. Every major database today supports JDBC, and most of them come with their own set of tools to view / modify data. The impetous behind creating goat was to have an unified interface to simplify viewing and managing data irrespective of the underlying database.
Note that goat does not intend to replace the existing tools to manage any given database, [since most of them contain database specific commands which are not cross-platform compatible] but to provide a common denominator to view and manage data.
In addition to providing an easy to use interface, goat also has some useful features (query completion, smart query generation, schema export/import etc) which can help both database administrators as well as java developers to manage data easily.
Goat Features:
1. Code Completion & Syntax Highlighting.
2. Export/Import of schema and data as HTML/CSV/XML.
3. Allow Multiple database connections.
4. Dynamic Driver Class Loading to avoid application restart when changing drivers.
5. Auto-Connection mechanism can automatically connect to all databases on start
6. Ability to render Clob/Blob data as text, images or XML.
7. Allows searching through clob data for matching text.
8. Update Dialog allows creating dynamic update queries
9. Update of all fields - including blobs/clobs possible via Update Dialog
10. Plugin mechanism allows creating customizable viewers for data
11. Graphical Relationship management tool
12. SQL Generation mechanism to generate sql queries easily
13. Import Mapping allows users to customize importing data from other databases
Requirements:
* Java
The license of this software is Freeware, you can free download and free use this database management software.