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.
Key Features
- 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.
Related Software
| MySQL Tools | |
|---|---|
| DBeaver | Universal database tool |
| phpMyAdmin | MySQL web administration tool |
| NocoDB | Build databases as spreadsheets |
| MySQL Workbench | Complete visual database design tool |
| mycli | Command line interface for MySQL, MariaDB, and Percona |
| gh-ost | GitHub's Online Schema Migrations for MySQL |
| Beekeeper Studio | Cross-platform SQL editor and database manager |
| usql | Command-line database client |
| sqlit | lazygit of SQL databases |
| Harlequin | Easy, fast, and beautiful database client for the terminal |
| DbGate | Database manager for MySQL, PostgreSQL, MongoDB |
| Percona Toolkit | Essential command-line utilities for MySQL |
| SQuirreL SQL Client | Graphical SQL client written in Java |
| Adminer | Full-featured tool for managing content in MySQL database |
| dblab | Interactive client for PostgreSQL, MySQL, SQLite3, and more |
| Antares | SQL client based on Electron.js and Vue.js |
| XtraBackup | Backup utility for MySQL |
| innotop | Real-time, advanced investigation tool |
| SQLCheck | Detects common SQL anti-patterns |
| Skeema | Manage MySQL and MariaDB schema changes |
| Sequeler | Native Linux SQL client built in Vala and Gtk |
| orchestrator | High availability and replication management tool |
| OmniDB | Collaborative environment For database management |
Read our verdict in the software roundup.
 Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more. Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form. |