I was looking for a replacement for SQL Server’s Enterprise Manager tool the other day, and came across this open-source project that does a nice job. 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. It has many other cool features that include:
- Broad support for many database products (SQL Server, Oracle, MySQL, Postgres, etc.)
- Code completion for tables, columns, keywords, data types, views, stored procedures and more. Generation of SQL-JOIN syntax based on foreign keys. All accessible through shortcut (ctrl +space) or tools popup
- Creating and printing charts of tables and their relations.
- SQL-Bookmark handling
- Best part is that it works on Linux and OSX as well as Windows!