The SQuirreL SQL Client is a database administration tool that allows you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc. It uses JDBC to allow users to explore and interact with databases via a JDBC driver.
The software provides an editor that offers code completion and syntax highlighting for standard SQL.
It also provides a plugin architecture that allows plugin writers to modify much of the application’s behavior to provide database-specific functionality or features that are database-independent.
Features include:
- Object Tree of session window allows for browsing database objects such as catalogs, schemas, tables, triggers, views, sequences, procedures, UDTs, etc.
- Provides syntax highlighting. It can open, create, save and execute files containing SQL statements.
- Code completion can be used to access drop-down lists of options that include keywords, tables, columns, views, stored procedures.
- Supports simultaneous sessions with multiple databases. This allows comparing data and sharing SQL statements between databases.
- A plugin architecture facilitates database vendor-specific extensions (information or actions not available using standard JDBC. There are a wide variety of plugins available.
- Graph capabilities can generate charts showing table relationships:
- Query Building with instant SQL query generation and executing.
- Saving in JPEG format.
- Printing.
- Linking / copying Graphs from other sessions or directories.
- Bookmarks – user-defined code templates. SQuirreL comes with several pre-defined example bookmarks for the most common SQL and DDL statements.
- Internationalization support – there are translations for Bulgarian, Brazilian Portuguese, Chinese, Czech, French, German, Italian, Japanese, Korean, Polish, Russian, and Spanish,
- Cross-platform support – runs under Linux, Mac OS X, Windows, and any other platform that has a JVM.
Website: www.squirrelsql.org
Support: SourceForge Project Page, Mailing Lists
Developer: Colin Bell, Gerd Wagner, Rob Manning and other contributors
License: GNU Lesser General Public License
SQuirreL SQL Client is written in Java. Learn Java with our recommended free books and free tutorials.
| Popular series | |
|---|---|
 | The largest compilation of the best free and open source software in the universe. Each article is supplied with a legendary ratings chart helping you to make informed decisions. |
 | Hundreds of in-depth reviews offering our unbiased and expert opinion on software. We offer helpful and impartial information. |
 | Replace proprietary software with open source alternatives: Google, Microsoft, Apple, Adobe, IBM, Autodesk, Oracle, Atlassian, Corel, Cisco, Intuit, and SAS. |
 | Awesome Free Linux Games Tools showcases a series of tools that making gaming on Linux a more pleasurable experience. This is a new series. |
 | Machine Learning explores practical applications of machine learning and deep learning from a Linux perspective. We've written reviews of more than 40 self-hosted apps. All are free and open source. |
 | New to Linux? Read our Linux for Starters series. We start right at the basics and teach you everything you need to know to get started with Linux. |
 | Alternatives to popular CLI tools showcases essential tools that are modern replacements for core Linux utilities. |
 | Essential Linux system tools focuses on small, indispensable utilities, useful for system administrators as well as regular users. |
 | Linux utilities to maximise your productivity. Small, indispensable tools, useful for anyone running a Linux machine. |
 | Surveys popular streaming services from a Linux perspective: Amazon Music Unlimited, Myuzi, Spotify, Deezer, Tidal. |
 | Saving Money with Linux looks at how you can reduce your energy bills running Linux. |
 | Home computers became commonplace in the 1980s. Emulate home computers including the Commodore 64, Amiga, Atari ST, ZX81, Amstrad CPC, and ZX Spectrum. |
 | Now and Then examines how promising open source software fared over the years. It can be a bumpy ride. |
 | Linux at Home looks at a range of home activities where Linux can play its part, making the most of our time at home, keeping active and engaged. |
 | Linux Candy reveals the lighter side of Linux. Have some fun and escape from the daily drudgery. |
 | Getting Started with Docker helps you master Docker, a set of platform as a service products that delivers software in packages called containers. |
 | Best Free Android Apps. We showcase free Android apps that are definitely worth downloading. There's a strict eligibility criteria for inclusion in this series. |
 | These best free books accelerate your learning of every programming language. Learn a new language today! |
 | These free tutorials offer the perfect tonic to our free programming books series. |
 | Linux Around The World showcases usergroups that are relevant to Linux enthusiasts. Great ways to meet up with fellow enthusiasts. |
 | Stars and Stripes is an occasional series looking at the impact of Linux in the USA. |