System information: Operating system (distribution) and version Windows 10 1803 DBeaver version 5.3.4.04 Java version OpenJDK 11.0.2 Additional extensions None Connection specification. DBeaver, DataGrip, and pgAdmin 4 are probably your best bets out of the 13 options considered. DataGrip is described as 'database IDE from JetBrains that is tailored to suit specific needs of professional SQL developers.— Intelligent query console' and is a popular app in the Development category. TablePlus vs Zoho Creator. See the 5 best PostgreSQL GUI tools for data visualization and managing your open source databases: 1) pgAdmin, 2) DBeaver, 3) Navicat, 4) DataGrip, 5) OmniDB. DBeaver is a tool in the Database Tools category of a tech stack. DBeaver is an open source tool with 20K GitHub stars and 1.9K GitHub forks. Here’s a link to DBeaver 's open source repository on GitHub. Datagrip vs mysql workbench. Comparison of database tools - Wikipedia - Flashing light on xbox 360 power supply.
List of database ER diagram (ERD) / schema visualization / reverse engineering tools for popular databases.
Dataedo
Dataedo enables you to create database documentation of your existing relational databases. It reads your schema and lets you easily describe each data element (tables and columns) and other database objects (like triggers, stored procedures, etc.) visually as ER diagrams.
| Commercial: | Commercial |
|---|---|
| Free edition: | |
| Export: | HTML,MS Excel,PDF |
dbForge Studio for SQL Server
dbForge Studio for SQL Server is a powerful IDE for SQL Server management, administration, development, data reporting and analysis.
| Commercial: | Commercial |
|---|---|
| Free edition: | |
| Export: | Printer |
Navicat Data Modeler
Navicat Data Modeler is a database design tool which helps you build conceptual, logical and physical data models. It allows you to visually design database structures, perform reverse/forward engineering processes, import models from ODBC data sources, generate complex SQL/DDL, print models to files.
| Commercial: | Commercial |
|---|---|
| Free edition: | |
| Export: | Image,PDF |
SchemaSpy
SchemaSpy is a Java-based free and open source tool that generates interactive entity-relationship diagrams to HTML from database schema metadata analysis.
Adminer
Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP.
ConceptDraw DIAGRAM
ConceptDraw DIAGRAM software gives the ability to describe a database using the Entity-Relationship model. The Entity-Relationship Diagram (ERD) solution of ConceptDraw contains all libraries, templates, and samples you may need for professional ERD drawing.
| Commercial: | Commercial |
|---|---|
| Free edition: | |
| Export: | Image,PDF |
DatabaseSpy
The Altova DatabaseSpy® 2017 graphical database Design Editor lets you view and edit the structures of all your databases through one graphical user interface.
| Commercial: | Commercial |
|---|---|
| Free edition: | |
| Export: | Image,SQL script |
DataGrip
Datagrip Vs Dbeaver
DataGrip is database IDE that is tailored to suit specific needs of professional SQL developers.
| Commercial: | Commercial |
|---|---|
| Free edition: | |
| Export: | Image |
DB Designer Fork
DB Designer Fork is a fork of the fabFORCE DBDesigner 4. It integrates entity relationship design, front-end (you can run queries), and SQL exporting
DBeaver
Free multi-platform database tool for developers, SQL programmers, database administrators and analysts.
| Commercial: | Free |
|---|---|
| Free edition: | |
| Export: | GraphML,Image |
DbSchema
DbSchema is diagram designer and query tool.
| Commercial: | Commercial |
|---|---|
| Free edition: | |
| Export: | HTML,PDF |
DbWrench
Database design and synchronization tool
Enterprise Architect
Enterprise Architect is a visual modeling and design tool based on the OMG UML.
| Commercial: | Commercial |
|---|---|
| Free edition: | |
| Export: | EMF,Image,WMF |
Lucidchart
Online diagram application makes it easy to sketch and share professional flowchart diagrams.
| Commercial: | Commercial |
|---|---|
| Free edition: | |
| Export: | Image,PDF,VDX |
ModelSphere
Datagrip Vs Mysql Workbench
Open ModelSphere is a powerful data, process and UML modeling tool - supporting user interfaces in English and French.
Dbeaver Datagrip
- Dark theme support was improved (Windows 10 and GTk)
- Data viewer:
- Copy As: format configuration editor was added
- Extra configuration for filter dialog (performance)
- Sort by column as fixed (for small fetch sizes)
- Case-insensitive filters support was added
- Plaintext view now support top/bottom dividers
- Data editor was fixed (when column name conflicts with alias name)
- Duplicate row(s) command was fixed for multiple selected rows
- Edit sub-menu was returned to the context menu
- Columns auto-size configuration was added
- Dictionary viewer was fixed (for read-only connections)
- Current/selected row highlighting support was added (configurable)
- Metadata search now supports search in comments
- GIS/Spatial:
- Map position preserve after tiles change
- Support of geometries with Z and M coordinates was added
- Postgis: DDL for 3D geometry columns was fixed
- Presto + MySQL geometry type support was added
- BigQuery now supports spatial data viewer
- Binary geo json support was improved
- Geometry export was fixed (SRID parameter)
- Tiles definition editor was fixed (multi-line definitions + formatting)
- SQL editor:
- Auto-completion for objects names with spaces inside was fixed
- Database objects hyperlinks rendering was fixed
- SQL Server: MFA (multi-factor authentication) support was added
- PostgreSQL: array data types read was fixed
- Oracle: indexes were added to table DDL
- Vertica: LIMIT clause support was improved
- Athena: extra AWS regions added to connection dialog
- Sybase IQ: server version detection was improved
- SAP ASE: user function loading was fixed
- Informix: cross-database metadata read was fixed
- We migrated to Eclipse 2021-03 platform