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
(省略されました)