MCPcopy
hub / github.com/dbeaver/dbeaver

github.com/dbeaver/dbeaver @26.1.1 sqlite

repository ↗ · DeepWiki ↗ · release 26.1.1 ↗
60,486 symbols 215,336 edges 6,266 files 6,545 documented · 11%
README

Twitter URL Codacy Badge Apache 2.0 Tickets in review

DBeaver

Free multi-platform database tool for developers, SQL programmers, database administrators and analysts.

  • Has a lot of features including schema editor, SQL editor, data editor, AI integration, ER diagrams, data export/import/migration, SQL execution plans, database administration tools, database dashboards, Spatial data viewer, proxy and SSH tunnelling, custom database drivers editor, etc.
  • Out of the box supports more than 100 database drivers.
  • Supports any database which has JDBC or ODBC driver (basically - almost all existing databases).
  • Supports smart AI completion and code generation with OpenAI or Copilot

Download

You can download prebuilt binaries from official website or directly from GitHub releases.
You can also download Early Access version. We publish daily.

Running

Just run an installer (or unzip an archive) and run dbeaver.

Note: DBeaver needs Java to run. OpenJDK 21 is included in all DBeaver distributions. You can change default JDK version by replacing directory jre in dbeaver installation folder.

Documentation

Architecture

  • DBeaver is written mostly on Java. However, it also uses a set of native OS-specific components for desktop UI, high performance database drivers and networking.
  • Basic frameworks:
  • OSGI platform for plugins and dependency management. Community version consists of 130+ plugins.
  • Eclipse RCP platform for rich user interface build.
  • JDBC for basic database connectivity API.
  • JSQLParser and Antlr4 for SQL grammar and semantic parser.
  • For networking and additional functionality we use wide range of open source libraries such as SSHJ, Apache POI, JFreeChart, JTS, Apache JEXL etc.
  • We separate model plugins from desktop UI plugins. This allows us to use the same set of "back-end" plugins in both DBeaver and CloudBeaver.
  • Dependencies: being an OSGI application we use P2 repositories for third party dependencies. For additional Maven dependencies we use our own DBeaver P2 repo.

Supported databases

Community version

Out of the box DBeaver supports following database drivers: MySQL, MariaDB, Oracle, DB2, PostgreSQL, SQL Server, Sybase, Apache Hive, Drill, Presto, Trino, Phoenix, Exasol, Informix, Teradata, Vertica, Netezza, Firebird, Derby, H2, H2GIS, WMI, Snowflake, Greenplum, Redshift, Athena, SAP HANA, MaxDB, NuoDB, MS Access, SQLite, CSV, DBF, Firebird, TimescaleDB, Yellowbrick, CockroachDB, OrientDB, MonetDB, Google BigQuery, Google Spanner, Apache Hive/Impala/Spark, Apache Ignite, MapD, Azure SQL, CrateDB, Elasticsearch, Ocient, Ingres, OmniSci, Yugabyte, IRIS, Data Virtuality, Denodo, Virtuoso, Machbase, DuckDB, Babelfish, OceanBase, Salesforce, EnterpriseDB, Apache Druid, Apache Kylin, Databricks, OpenSearch, TiDB, TDEngine, Materialize, JDBCX, Dameng, Altibase, StarRocks, CUBRID, GaussDB, DolphinDB, LibSQL, GBase 8s, Databend, Cloudberry, Teiid, Kingbase.

PRO versions

Commercial versions extends functionality of many popular drivers and also support non-JDBC datasources such as: ODBC, MongoDB, Cassandra, Couchbase, CouchDB, Redis, InfluxDB, Firestore, BigTable, DynamoDB, Kafka KSQL, Neo4j, AWS Neptune, AWS Timestream, Azure CosmosDB, Yugabyte, Salesforce, etc.
Also, we support flat files as databases: CSV, XLSX, Json, XML, Parquet.
You can find the list of all databases supported in commercial versions here.

Feedback

  • For bug reports and feature requests - please create a ticket.
  • To promote a ticket to a higher priority - please vote for it with 👍 under the ticket description.
  • If you have any questions, ideas, etc - please start a discussion.
  • Pull requests are welcome. See our guide for contributors.
  • Visit https://dbeaver.com for more information.
  • Follow us on X and watch educational video on YouTube
  • Thanks for using DBeaver! Star if you like it.

Contribution: help the Beaver!

Hooray, we have reached 50k+ stars on GitHub and continue to grow!
That's really cool, and we are glad that you like DBeaver.

  • We are actively looking for new source code contributors. We have added labels “Good first issue” and “Help wanted” to some tickets. If you want to be a part of our development team, just be brave and take a ticket. We are happy to reward our most active contributors every major sprint.
  • You can buy one of our commercial versions. They include NoSQL databases support, additional extensions, and official online support. Also, licensed users have priorities in bug fixes and the development of new features.

Thank you!


CloudBeaver is a web-based database management tool built on the DBeaver platform. It brings the capabilities of DBeaver to the web interface, enabling database management from any device with an internet connection and eliminating the need for local installation.
Supporting any database, CloudBeaver incorporates most of DBeaver's features and includes advanced access management for secure collaboration.
Designed with a user-friendly interface, CloudBeaver simplifies complex database operations and is suitable for both individual developers and organizations. Its scalable architecture accommodates various needs, making it a convenient solution for managing databases anytime and anywhere through web-based accessibility.

Extension points exported contracts — how you extend this code

WSEventHandler (Interface)
CB web event handlers [23 implementers]
plugins/org.jkiss.dbeaver.model.event/src/org/jkiss/dbeaver/model/websocket/WSEventHandler.java
JDBCObjectSupplier (Interface)
JDBC object supplier [28 implementers]
plugins/org.jkiss.dbeaver.model.jdbc/src/org/jkiss/dbeaver/model/exec/jdbc/JDBCObjectSupplier.java
DBPScriptObjectExt2 (Interface)
Can check whether object support an option or not [27 implementers]
plugins/org.jkiss.dbeaver.model/src/org/jkiss/dbeaver/model/DBPScriptObjectExt2.java
DBFRemoteFileStore (Interface)
An IFileStore that supports explicit refresh. [29 implementers]
plugins/org.jkiss.dbeaver.model.rcp/src/org/jkiss/dbeaver/model/fs/DBFRemoteFileStore.java
IDataTransferAttributeTransformer (Interface)
Attribute transformer for data transfer. Transformer may have a state. It is instantiated for each entity attribute. [18 …
plugins/org.jkiss.dbeaver.data.transfer/src/org/jkiss/dbeaver/tools/transfer/IDataTransferAttributeTransformer.java
GisAttribute (Interface)
GisAttribute. [7 implementers]
plugins/org.jkiss.dbeaver.data.gis/src/org/jkiss/dbeaver/model/gis/GisAttribute.java
SQLControlCommandHandler (Interface)
Control command handler [12 implementers]
plugins/org.jkiss.dbeaver.model.sql/src/org/jkiss/dbeaver/model/sql/SQLControlCommandHandler.java
DB2SourceObject (Interface)
Object that provide a DDL text @author Denis Forveille [8 implementers]
plugins/org.jkiss.dbeaver.ext.db2/src/org/jkiss/dbeaver/ext/db2/editors/DB2SourceObject.java

Core symbols most depended-on inside this repo

append
called by 4851
plugins/org.jkiss.dbeaver.model.rcp/src/org/jkiss/dbeaver/model/fs/nio/EFSNIOPath.java
add
called by 4662
plugins/org.jkiss.dbeaver.model/src/org/jkiss/dbeaver/model/struct/DBSDataManipulator.java
getName
called by 2632
plugins/org.jkiss.dbeaver.model/src/org/jkiss/dbeaver/LogHandler.java
equals
called by 2087
plugins/org.jkiss.dbeaver.model/src/org/jkiss/dbeaver/model/sql/Diff.java
put
called by 2085
plugins/org.jkiss.dbeaver.model/src/org/jkiss/dbeaver/model/preferences/DBPSettingsSection.java
get
called by 1962
plugins/org.jkiss.dbeaver.ui.forms/src/org/jkiss/dbeaver/ui/forms/UIObservable.java
toString
called by 1873
plugins/org.jkiss.dbeaver.model/src/org/jkiss/dbeaver/model/data/DBDBinaryFormatter.java
safeGetString
called by 1710
plugins/org.jkiss.dbeaver.model.jdbc/src/org/jkiss/dbeaver/model/impl/jdbc/JDBCUtils.java

Shape

Method 52,390
Class 6,552
Interface 952
Enum 420
Function 172

Languages

Java100%
TypeScript1%

Modules by API surface

plugins/org.jkiss.dbeaver.ui.editors.data/src/org/jkiss/dbeaver/ui/controls/resultset/ResultSetViewer.java272 symbols
plugins/org.jkiss.dbeaver.ui.editors.sql/src/org/jkiss/dbeaver/ui/editors/sql/SQLEditor.java246 symbols
plugins/org.jkiss.dbeaver.ui.editors.data/src/org/jkiss/dbeaver/ui/controls/lightgrid/LightGrid.java206 symbols
plugins/org.jkiss.dbeaver.model.jdbc/src/org/jkiss/dbeaver/model/impl/jdbc/exec/JDBCDatabaseMetaDataImpl.java179 symbols
plugins/org.jkiss.dbeaver.registry/src/org/jkiss/dbeaver/registry/DataSourceDescriptor.java167 symbols
plugins/org.jkiss.dbeaver.ui/src/org/jkiss/dbeaver/ui/UIUtils.java163 symbols
plugins/org.jkiss.dbeaver.registry/src/org/jkiss/dbeaver/registry/driver/DriverDescriptor.java159 symbols
plugins/org.jkiss.dbeaver.ext.postgresql/src/org/jkiss/dbeaver/ext/postgresql/model/PostgreDatabase.java157 symbols
plugins/org.jkiss.dbeaver.ui.editors.data/src/org/jkiss/dbeaver/ui/controls/resultset/spreadsheet/SpreadsheetPresentation.java156 symbols
plugins/org.jkiss.dbeaver.ui.editors.erd/src/org/jkiss/dbeaver/ui/editors/erd/editor/ERDEditorPart.java135 symbols
plugins/org.jkiss.dbeaver.ui.navigator/src/org/jkiss/dbeaver/ui/navigator/itemlist/ObjectListControl.java132 symbols
plugins/org.jkiss.dbeaver.ext.oracle/src/org/jkiss/dbeaver/ext/oracle/model/OracleSchema.java132 symbols

Datastores touched

(mysql)Database · 1 repos
postgresDatabase · 1 repos
RfamDatabase · 1 repos
saDatabase · 1 repos
dbeaverDatabase · 1 repos
dvdrentalDatabase · 1 repos

For agents

$ claude mcp add dbeaver \
  -- python -m otcore.mcp_server <graph>

⬇ download graph artifact