DBeaver
詳細情報
| タイトル | DBeaver |
|---|---|
| URL | https://dbeaver.io/download/ |
| バージョン | ver 26.0.1 |
| 更新日 | 2026/03/23 |
| 追加日 | 2019/09/07 |
| 種別 | フリーソフト |
| 説明 | マルチプラットフォーム対応のデータベース管理ツール。 |
レビュー
概要
DBeaverは、Serge Rider氏によって2010年に開発が始まったオープンソースのマルチプラットフォーム対応データベース管理ツールです。Javaで実装されており、Eclipse RCPフレームワークをベースに構築されています。当初は個人プロジェクトとして始まりましたが、その汎用性の高さとオープンソースであることから急速に普及し、現在では世界中の開発者・データベース管理者に広く利用されています。Community Edition(無料・オープンソース)とPro Edition(有料・追加機能あり)の2ラインナップで提供されており、特にCommunity Editionは個人・商用問わず無料で使用できます。
主要な特徴・機能
- 幅広いデータベース対応 - MySQL、MariaDB、PostgreSQL、SQLite、Oracle、SQL Server、DB2、MongoDB、Cassandraなど100種類以上のデータベースに対応
- 強力なSQLエディタ - シンタックスハイライト・オートコンプリート・コード整形機能を備えた多機能SQLエディタ
- 高度なデータエディタ - テーブルデータをグリッド形式で直接編集・フィルタリング・ソートが可能
- データベーススキーマエディタ - テーブル・ビュー・インデックスなどのスキーマ情報をGUIで管理・編集
- ERダイアグラム - データベース構造をER図として自動生成・可視化
- データのエクスポート/インポート - CSV、Excel、JSON、XML、SQLなど複数形式でのデータ移行が可能
- SSH・プロキシ接続 - セキュアなトンネル接続を通じたリモートデータベースへのアクセス
- 空間データビューア - 地理情報データ(GIS)の可視化機能
- AIアシスタント - SQL生成を支援する基本的なAI機能(ChatGPT等と連携可能)
- チャート機能 - クエリ結果をグラフ・チャートで可視化
- マルチプラットフォーム - Windows、macOS、Linuxに対応
対象ユーザー
- データベースを日常的に扱う開発者・バックエンドエンジニア
- 複数種類のデータベースを管理するデータベース管理者(DBA)
- SQLを使ったデータ分析を行うデータアナリスト・データサイエンティスト
- 個人プロジェクトや学習目的でデータベースを使用する学生・個人開発者
ライセンス情報
Community EditionはApache License 2.0のオープンソースソフトウェアとして無償提供されています。商用・個人を問わず無料で使用可能です。より高度な機能(ノーSQL対応強化、データ比較、タスクスケジューラ等)を含むDBeaver Proは有料ライセンスで提供されています。Windows、macOS、Linux向けのインストーラーが公式サイトから無料でダウンロード可能です。
スクリーンショット
更新グラフ
バージョン履歴
26.0.1
- SQL Editor:
- Queries cancelled by users are no longer marked as invalid
- Fixed layout issue when the first few rows of text were not visible
- Grouping panel:
- Percent function now shows 2 significant digits
- Added the ability to reorder grouping columns
- Metadata Editor: Fixed hash code display when the table name is empty (thanks to @dahyeong-yun)
- Data Transfer: the Proceed button is now enabled earlier, on every page that is properly filled
- Query Manager became accessible even if the database password is lost
- Connectivity:
- Added connection name and background color to the Ctrl+E editor switcher dropdown (thanks to @bittoby)
- Fixed an issue when changes in connection parame
26.0.0
- AI assistant: added the ability to filter database objects in AI scope settings
- Data Editor:
- Fixed an issue where adding a new row in record mode inserted an existing row instead of creating a new empty one
- Fixed incorrect DDL generation for tables without keys
- Fixed a bug where a new column could be replaced with the percent column after it had been enabled and then disabled
- ER Diagram: Fixed an issue where table names were truncated after saving in PNG format
- Task Management: fixed the ability to run tasks with linked scripts
- Connectivity:
- Fixed jump host edits. Changes take effect as soon as the hostname is updated
- Fixed the "Test tunnel configuration" functionality that did not work for custom n
25.3.5
- AI assistant: added descriptions for the custom prompts
- Data Editor:
- Improved the presentation of multiple foreign keys
- Fixed dark mode display for single-tab results
- Fixed several minor issues related to background rendering, exceptions, and cursor behavior
- Metadata Editor: Fixed tab styling
- Task Management:
- The "Save Task" button was moved to the same row as the other action buttons
- Added a tooltip to the Auto-commit option in the SQL Script task settings
- Miscellaneous:
- Added an option to exclude the application from Windows Defender during installation
- Fixed Linux installation using Debian
- Fixed the ability to manage software installation
25.3.4
- SQL Editor:
- When no text is selected, pressing "Ctrl+C" and "Ctrl+X" will copy or cut the entire line at the caret position (thanks to @jihoon0413, @jihoon0413)
- Fixed status bar visibility in the result set for single and multiple query execution
- Added result set display for pause commands in scripts
- Non-result presentations include filters and actions after executing a script
- AI assistant: fixed the SQL generation for the OpenAI engine
- Grouping Panel:
- Added Percent of Total function
- Columns and functions can now be reordered
- Pressing the Add button opens a submenu with available items and columns
- Choosing Custom adds an empty, editable column or function
- Data
25.3.3
- SQL Editor: improved performance when executing multiple SQL queries simultaneously
- AI Assistant: the temperature setting is disabled for models that do not support it
- Data Editor: "Calculate row count automatically" was enabled by default and applies only to SELECT queries
- Data Transfer: resolved an issue with an oversized data transfer window
- Miscellaneous:
- Auto-commit settings were redesigned
- Redesigned visual page structure in Preferences and some dialogs
- Resolved an issue with incorrect transaction mode display
- Restored the splash screen on macOS
- Databases:
- ClickHouse: fixed broken spatial data presentation
- Sybase: fixed table opening via double-click in the Navi
25.3.2
- Data Editor: Fixed value change cancellation
- Search: Fixed text input for Chinese, Japanese, and other similar languages on macOS
- Data transfer: Removed a warning from the logs that appeared during CSV import
- Miscellaneous:
- Linux Debian package was fixed
- Snap:
- Packaging switched to classic mode
- Issues with web browser activation were resolved
- Issues with Office integration were resolved
- Problem with DuckDB embedded driver connection was fixed
- Databases:
- MySQL: Fixed database dump when SSH is enabled
- ClickHouse:
- Driver version was updated to version 0.9.5
- JSON data type reading was fixed
25.3.1
- SQL Editor:
- New script numbering algorithm was improved
- Bug in Find/Replace panel and Ctrl+Enter shortcut was resolved
- Dangerous query confirmation now shown for any DROP statements
- Query confirmation message was fixed
- Data Editor:
- Ordering of rows by primary key feature was redesigned and now works only in tables
- Issue with virtual keys and "use all columns as key" option was resolved
- Issue with tooltips for JSON columns was resolved
- Value change cancellation was fixed
- Data export in DbUnit format was fixed (issue with escaping)
- Data import wizard now show file selector automatically
- Issue with incorrect detection of read-only column
25.3.0
Changes since 25.2.5:
- SQL Editor:
- Fixed the ability to select multiple rows on macOS
- Fixed an issue with the unavailable script execution button
- Data Editor: fixed incorrect behavior when applying filters with extra conditions
- Metadata editor:
- Fixed an issue with duplicate unique index create statement when generating DDL
- Table size presentation was fixed
- Navigator: fixed an issue when filters didn't work in a new DBeaver window (thanks to @klassik86)
- Query Manager: execution time is now always displayed in milliseconds
- Data transfer: fixed an issue when the application freezes during the export of a large number of tables
- Task Management: added a loading progress indicator for
25.2.5
- Data Editor:
- Icons for data edit commands were updated
- Data loading progress messages now show more details
- SQL Editor:
- Resolved the issue with performance lag during long scripts scrolling
- `@include` command processing was improved
- Error processing in nested scripts was fixed
- `CTRL+Enter` shortcut was fixed in Find/Replace panel
- AI: OpenAI legacy API support was added
- Miscellaneous:
- Opening of sql files by using command line of file explorer was fixed
- Potential security breach was resolved in GIS map viewer
- Splash screen is now disabled on MacOS
- Data transfer:
- "Write to the single file" option was fixed
25.2.4
- Data Editor:
- The default shortcut for Advanced Copy with previous settings on macOS was changed to CTRL+SHIFT+4
- Added the option to disable numeric identifier columns formatting
- SQL Editor: Added support for temporary tables in semantic analysis
- AI assistant: added the confirmation for query types that DBeaver cannot recognize as valid SQL
- Data Transfer: Added connection and database info to backup/restore wizards
- Connectivity: fixed an issue that prevented deleting network profiles
- Miscellaneous:
- Fixed a crash on Windows that occurred when the username contained non-ASCII characters
- Fixed an issue where notifications stole focus when the user was in another application
- Added the abili
25.2.3
- AI assistant:
- Added the ability to test AI configuration in Preferences
- Fixed bug in AI command which lead to an error whenever a query contained a trailing delimiter
- Data Editor:
- Removed the default shortcut for Select Row Count (Ctrl+Alt+Shift+C) due to a conflict with the Advanced Copy shortcut
- Fixed an issue when the boolean inline editor was read-only in tables without a primary key
- Metadata Editor:
- Updated the UI for object comments editing
- Removed object name comments duplicate in view DDL
- Navigator:
- Added an option for case-insensitive alphabetical sorting
- Fixed an issues with tree inconsistency after disconnect
- Fixed an issue with ta

