Description
Juggling PostgreSQL, MySQL, SQLite and Oracle at once, each with its own official client — different interface, different shortcuts to memorize — gets tiring to switch between. SQuirreL SQL Client takes the universal route: any database with a JDBC driver connects through the same interface to browse its structure, write SQL and read results, one set of habits for every database.
An object tree on the left expands schemas, tables, views, indexes, foreign keys and stored procedures level by level, and clicking a table shows its columns, keys, row count and content in tabs on the right. The SQL editor has syntax highlighting and code completion — type a table name and it offers the column names, so you needn't recall fields. Query results are editable in the grid and written back. It also draws table relationships as a graph and extends through plugins (Hibernate, graphing and more). Written in Java, needing a Java runtime, cross-platform on Windows, macOS and Linux, open source.
Universal JDBC: any database with a JDBC driver connects — PostgreSQL, MySQL, SQLite, Oracle, SQL Server and more — through one interface and one set of habits.
Object-tree browsing: schemas, tables, views, indexes, foreign keys and stored procedures expand level by level, with columns, keys, row counts and content in tabs on the right.
SQL editor: syntax highlighting and code completion offer column names as you type a table, so queries need no memorizing of fields.
Editable results: edit query results in the grid and write them back, sparing a hand-written UPDATE.
Graphs and plugins: draw table relationships as a graph and extend with plugins such as Hibernate and graphing; on Windows, macOS and Linux.
An object tree on the left expands schemas, tables, views, indexes, foreign keys and stored procedures level by level, and clicking a table shows its columns, keys, row count and content in tabs on the right. The SQL editor has syntax highlighting and code completion — type a table name and it offers the column names, so you needn't recall fields. Query results are editable in the grid and written back. It also draws table relationships as a graph and extends through plugins (Hibernate, graphing and more). Written in Java, needing a Java runtime, cross-platform on Windows, macOS and Linux, open source.
Features
Universal JDBC: any database with a JDBC driver connects — PostgreSQL, MySQL, SQLite, Oracle, SQL Server and more — through one interface and one set of habits.
Object-tree browsing: schemas, tables, views, indexes, foreign keys and stored procedures expand level by level, with columns, keys, row counts and content in tabs on the right.
SQL editor: syntax highlighting and code completion offer column names as you type a table, so queries need no memorizing of fields.
Editable results: edit query results in the grid and write them back, sparing a hand-written UPDATE.
Graphs and plugins: draw table relationships as a graph and extend with plugins such as Hibernate and graphing; on Windows, macOS and Linux.
