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.
The SQuirreL SQL client provides a simple graphical interface to relational databases. Because it is built using Java, it can access any JDBC-compliant database running on any machine, allowing remote access to multiple databases. A SQuirreL user can:- easily view and edit data in any JDBC-compliant database,
- view the database’s meta-data,
- work with multiple databases on both local and remote machines,
- use a single, consistent interface to work with different database engines, and
- expand the tool’s capabilities and include DB-specific functionality using plugins.
The user can click on tables to view them and edit data, or use full SQL operations. Data can be viewed in read-only mode for safety, or in an editable mode where it may be modified by simply typing the new data into the table. All of the meta-data for the database (eg: data types, table column names, etc.) are accessible through SQuirreL. In cases where multiple types of database engines are being used (eg: Oracle, MySQL, PostgreSQL, etc.), the user does not need to learn multiple DB-management tools since SQuirreL-SQL provides a common mechanism for accessing them all. In those cases where a Database engine has nonstandard quirks, SQuirreL’s plugin architecture allows users to include DB-specific components to handle those operations. The plugin architecture also allows developers to create add-on functions that users may choose to include or not as they wish.
Download
