Summary

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.

Website

• Project Homepage
• Download squirrel-sql-x.x.x-optional if you want all of the plugins installed.

Features

• Supports autocomplete when creating queries by pressing CTRL+SPACE.
• On-the-fly generation of ERD diagrams.

Useful Keyboard Shortcuts

• CTRL+SPACE - autocomplete database, table, and fields in queries.
• CTRL+t - SQL Editor Tools Popup
• CTRL+j - Display Query Bookmarks
  (Note: need to enable with CTRL+t edit bookmarks first.)
• CTRL+SHIFT+, / CTRL+SHIFT+. - switch to prev/next results tab

Useful Plugins

• UnityJDBC - A plugin for SQuirreL that allows queries involving multiple kinds of databases, much in the same way that MS-Access allows linked tables.