SQuirreL SQL Client

詳細情報

タイトル SQuirreL SQL Client
URL http://www.squirrelsql.org/
バージョン ver 5.1.0
更新日 2026/04/01
追加日 2016/04/25
種別 フリーソフト / オープンソース(GPL)
説明 Javaで作られたオープンソースのデータベースクライアント。

レビュー

概要

SQuirreL SQL ClientはJDBC対応データベースをGUIで操作できるJavaベースのオープンソースSQLクライアントです。Colin Bellを中心とした世界中のJava開発者チームによって2001年からSourceForgeでホストされているプロジェクトで、20年以上にわたって継続的に開発・メンテナンスされています。Java + SwingによるGUIで実装されているため、JVM(Java仮想マシン)が動作するWindows・macOS・Linuxすべてのプラットフォームで動作します。JDBC準拠のドライバが存在するあらゆるデータベースに接続でき、プラグインアーキテクチャによってベンダー固有の機能を追加拡張することも可能です。最新安定版はバージョン5.1.0(2026年3月時点)で、Java 17以上が必要です。

主要な特徴・機能

  • データベース構造の閲覧: カタログ・スキーマ・テーブルなどのオブジェクトをツリービューで視覚的に参照
  • SQLエディタ: RSyntaxTextAreaベースのエディタで構文強調表示・自動補完に対応
  • 複数同時接続: 複数のデータベースへの同時セッション管理が可能
  • データエクスポート: SQL実行結果をExcel形式などにエクスポート
  • グラフ機能: テーブル間のリレーション関係図を自動生成
  • プラグインアーキテクチャ: ベンダー固有機能の追加や独自プラグイン開発が可能
  • ブックマーク管理: よく使うSQLをブックマークとしてツリー管理
  • 多言語対応: UIの11言語翻訳に対応
  • パスワード暗号化: 接続情報のパスワードを安全に暗号化して保存
  • クロスプラットフォーム: JVMが動作する全OS(Windows・macOS・Linux等)で動作

対象ユーザー

  • 複数種類のデータベースを一つのクライアントで管理したいDBA(データベース管理者)
  • データベース設計・開発を行うSQL開発者
  • PostgreSQL・MySQL・Oracle・SQL Serverなど多様なDBを扱うシステムエンジニア
  • プラットフォームを問わず統一した操作感でSQLを実行したいエンジニア

ライセンス情報

GNU Lesser General Public License v2.1以降(LGPLv2.1+) のオープンソースソフトウェアです。無償で利用できます。Java 17以上が必要です。公式サイト(https://squirrel-sql.sourceforge.io/)またはSourceForgeよりダウンロード可能です。

スクリーンショット

更新グラフ

バージョン履歴

Version 5.1.0
Feature highlights of 5.1.0:
Table columns can be toggled between a monospaced font and default font
Table cell contents can be concatenated without separator
SQL results can be rerun automatically after a configurable number of seconds
The SQL editor allows to run bookmarks by the syntax @runbookmark <bookmarkNameInSingleQuotes>
MS Excel file export allows to add or replace sheet-tabs in an MS Excel file
Option to execute SQL in multiple Sessions
Single click connect to multiple Aliases
Enhanced security for encrypting Alias passwords
"Copy as WIKI Table" - function of tables now supports copying the Jira/Cloud table format
User Bookmarks can be displayed as tree
All new features and bug fixes of the 5.1.0 release can be found in our change log at
SQuirreL 5.1.0 is released (03/26/2026).
The list of feature highlights is rather long and can be found above.
For all new features and bug fixes see our change log at SourceForge
or GitHub.
Note that SQuirreL 5.1.0 requires at least Java 17.
5.1.0 releases on SourceForge:
(省略されました)
Version 5.0.0
Feature highlights of 5.0.0:
The Object tree's root node has a new detail tab named "Client Properties"
The Object tree didn't show tables when the JDBC driver didn't provide table types
Support for Java 25
SQL result table search now highlights results in cell detail display, too
Cell data image display offers to scale images to fit the display size
MS Excel exports offer to create tabs containing the exports' SQL statements
Improved memory footprint
Enhanced 'Copy separated by ...' function
Searching all open SQL results and cell data dialogs
Code completion for JOIN ON clauses
Cell data display highlights JSON and XML after reformatting
Choosing fonts for MS-Excel export
Aliases can be made read-only
SQL result tabs that match the current SQL in the editor are marked
SQL result's find function now offers to narrow the columns to search
SQL result's detail data display now allows to automatically reformat XML or Json
Numeric values can be right aligned
(省略されました)
Version 4.8.0
Feature highlights of 4.8.0:
Saved Session Groups: store and restore groups of Sessions
Cell detail display at the right of SQL results
Cell detail display and cell detail popup support image display
Renaming additional SQL tabs
Fixed dark theme
Java 22 compatibility
All new features and bug fixes of the 4.8.0 release can be found in our change log at
SQuirreL 4.8.0 is released (09/01/2024), feature highlights of 4.8.0:
⇒ Saved Session Groups: store and restore groups of Sessions
⇒ Cell detail display at the right of SQL results
⇒ Cell detail display and cell detail popup support image display
⇒ Renaming additional SQL tabs
⇒ Fixed dark theme
⇒ Java 22 compatibility
4.8.0 releases on SourceForge:
4.8.0 releases on GitHub:
The new snapshot snapshot-20240722_2010 allows to display cell details on the left of SQL result tables.
(省略されました)
Version 4.7.1
Feature highlights of 4.7.1:
Multiple Alias modification
Code completion offers contains mode
Timeout for SQL executions
Object tree: Save and restore selected nodes
Data compare to clipboard
Search function for table cell data popup
Edit toggle button on SQL result tabs
Graph Plugin (ER diagrams) allows to hide columns
Caret/Cursor position in SQL is displayed
Java 21 compatibility
All new features and bug fixes of the 4.7.1 release can be found in our change log at
SQuirreL 4.7.1 is released (02/20/2024), feature highlights of 4.7.1:
⇒ Multiple Alias modification
⇒ Code completion offers contains mode
⇒ Timeout for SQL executions
⇒ Object tree: Save and restore selected nodes
⇒ Data compare to clipboard
(省略されました)
Version 4.6.0
and
Feature highlights of 4.6.0:
Data compare function
Search function for preferences/configurations
Enhanced BLOB and CLOB loading configuration
Export of multiple SQL results
Java 20 compatibility
Many more features and bug fixes
All new features and bug fixes of the 4.6.0 release can be found in our change log at
SQuirreL 4.6.0 is released (06/04/2022).
Feature highlights of 4.6.0:
⇒ Data compare function
⇒ Search function for preferences/configurations
⇒ Enhanced BLOB and CLOB loading configuration
⇒ Export of multiple SQL results
⇒ Java 20 compatibility
⇒ Many more features and bug fixes
For all new features and bug fixes see our change log at SourceForge
(省略されました)
Version 4.5.1
Feature highlights of 4.5.1:
All new features and bug fixes of the 4.5.1 release can be found in our change log at
SQuirreL 4.5.1 is released (11/13/2022).
4.5.1 is a bug fix release first and foremost to fix an error which occurred when SQL results were edited.
For more details on all new features and bug fixes see our change log.
4.5.1 releases on SourceForge:
Download installer for Windows/Linux/others
Download installer for Mac OS
4.5.1 releases on GitHub:
Download installer for Windows/Linux/others
Download installer for Mac OS
New snapshot 20221027_2155 that fixes an error which occurred when SQL results were edited.
For details see our change log at SourceForge
or GitHub.
The snapshot releases on SourceForge are:
Download installer for Windows/Linux/others
Download installer for Mac OS
The snapshot releases on GitHub are:
(省略されました)
Version 4.5.0
 
On GitHub
Project Home
Stable downloads
Snapshot downloads
Bugs/Feature requests
GIT
 
Feature highlights of 4.5.0:
Multiple caret/cursor editing
Global Preferences and New Session Properties search
Several improvements of Saved Sessions (feature to save and restore all SQL editors of a Session)
Configurable right mouse menus
Redesigned add/edit JDBC-Driver dialog
Java 19 compatibility
All new features and bug fixes of the 4.5.0 release can be found in our change log at
SourceForge
or GitHub.
(省略されました)
Version 4.4.0
Introduction, Screenshots
Open Java JDK download
OpenJdk Home
Oracle Java Home
Introduction, Screenshots  
Feature highlights of 4.4.0:
Saved Sessions: Option to save and restore all SQL editors of a Session
Improved Object Tree search
Java 18 compatibility
Dependency on Log4j libraries was removed
All new features and bug fixes of the 4.4.0 release can be found in our
Download SQuirreL SQL Client
SQuirreL 4.4.0 is released. Highlights are
Saved Sessions: Option to save and restore all SQL editors of a Session.
Improved Object Tree search.
Java 18 compatibility.
Dependency on Log4j libraries was removed.
For more details on all new features and bug fixes see our change log.
(省略されました)
Version 4.3.0
All new features and bug fixes of the 4.3.0 can be found in our
SQuirreL 4.3.0 is released.
Note: Java 11 or higher is required for this release.
For new features and bug fixes see our change log.
Another 4.3.0 release candidate: snapshot 20210922_2129 which compared to the last candidate contains one more bug fix.
Note: Java 11 or higher is required.
New snapshot 20210918_0413.
Introduces Java 17 compatibility and is a release candidate for version 4.3.0.
Note: Java 11 or higher is required.
Download installer for Mac OS
New snapshot 20210411_2107.
On Mac OS Apple's application close command "Command key"+Q now works the same way as Ctrl+Q.
From this snapshot on Java 11 or higher is required.
For the 4.3.0 release the minimum required Java version is 11.x.
Already the first snapshot release after 4.2.0 required Java 11.x.
From version 3.8.1 to 4.2.0 version the minimum version of Java supported was 1.8.x.
See the Old Versions
Install jar of SQuirreL 4.3.0 for Windows/Linux/others
Install jar of SQuirreL 4.3.0 for MacOS X
Version 4.2.0
Feature highlights of 4.2.0:
Find columns function
Show distinct values of SQL results
Recent Aliases list
Java 16 compatibility
SQuirreL 4.2.0 is released. Feature highlights are listed above.
Another snapshot, 20210309_2111, meant to be a release candidate for version 4.2.0.
It would be nice if you could give it a try.
Note: We don't anounce every snapshot release here. If you are interested please check
New snapshot 20210131_2217 with several changes concerning the Mac OS installer.
It is recommended to delete former Mac OS installations before using the new installer.
Download installer for Mac OS
The former snapshot was planed to be a release candidate for version 4.2.0. This didn't work out.
Several new features and bug fixes came up and were implemented lately. So here's a new snapshot.
For details see our change log.
Download installer for Windows/Linux/others
Install jar of SQuirreL 4.2.0 for Windows/Linux/others
Install jar of SQuirreL 4.2.0 for MacOS X
Version 4.1.0
Feature highlights of 4.1.0:
Change tracking including GIT (https://git-scm.com) integration
Selectively copy Aliases between SQuirreL installations
Selectively copy Bookmarks between SQuirreL installations
Option to view Objects window alongside SQL editor
On demand table creation for CSV/Excel file imports
Java 14 compatibility
SQuirreL 4.1.0 is released. Feature highlights are listed above.
For details see our change log.
The last snapshot announced here was declared a release candidate for version 4.1.0. This didn't work out.
Several new features and bug fixes were implemented since.
So here's another 4.1.0 release candidate: Snapshot 20200407_2239.
It would be nice if you could give it a try again.
Snapshot 20200220_2238 allows to selectively copy aliases between SQuirreL installations
and is meant to be a candidate for the 4.1.0 release.
So it would be nice if you could give it a try.
Install jar of SQuirreL 4.1.0 for Windows/Linux/others
Install jar of SQuirreL 4.1.0 for MacOS X