The Slant team built an AI & it’s awesome

Find the best product instantly

Add to Chrome Try it now

4.7 star rating

DevelopmentLinuxDatabasesSQL

What are the best SQL clients for Linux?

13

Options
Considered

375

User
Recs.

18 mins

Last
Updated

Here’s the Deal

The Best 1 of 12 OptionsWhy?

Best SQL clients for Linux	Price	Platforms	Last Updated
94 DBeaver	FREE	Windows, Linux, Mac	Mar 27, 2020
84 DataGrip	$ 199/Y	-	Mar 1, 2020
-- Squirrel SQL	FREE	-	Mar 19, 2020
-- DbVisualizer	Free / paid	Windows, Linux, Mac	Mar 11, 2020
-- Sqlectron	Free	Windows, Linux, Mac	Mar 19, 2020

DBeaver

Add Video or Image

Top Pro

Cross-platform

Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86). See More

Top Con

Written in Java

Consumes a lot of memory. See More

FerventApedemak's Experience

This sql editor may many problem and bugs not saved materialized views after editing not worked backup restoring stored procedures created uncorrect tested on debian 9, windows 7 See More

Specs

Platforms:Windows, Linux, Mac

Top Pro

Free & open source

The community edition is free and open source under Apache License 2.0. See More

Top Con

Never-ending function errors

Like 'Communications link failure', 'Connection refused' (Community Edition 6.2.1). See More

DashingVenilia's Experience

It is buggy... I have granted all rights to the user using mysql terminal tool and still I can't open "packages", "triggers" and "events" inside a GUI. I tried downgrading the drivers to a stable version but it is the same. The error is: SELECT command denied to user. See More

Top Pro

Supports a lot of database servers

Connects to plenty of database servers via JDBC. See More

Top Con

Can become unstable after an update

An update can corrupt the configuration files and prevent DBeaver to start. See More

Juli ardi's Experience

The community edition is free and support all database which has JDBC driver. It has a nice GUI which isn't like any other Java-based database management software. See More

Top Pro

Works for many types of databases

MySQL, Oracle, PostgreSQL, IBM DB2, Microsoft SQL Server, Microsoft Access, Sybase, Java DB (Derby), Firebird (Interbase), Derby (JavaDB), SQLite, Mimer, HSQLDB, H2, IBM Informix, Teradata, SAP MAX DB, Cache, Ingres, Linter, Vertica, MongoDB, Cassandra, ODBC, Any JDBC compliant data source. See More

Top Con

Cannot view function

KnowledgeableIsimud's Experience

great query generation and UI table updates See More

Top Pro

Separation between production, QA and development environments

The UI uses a different color to indicate that you are working on a production system which is a hint that the user must be careful. See More

Top Con

Does not support regex for filtering tables

Not able to filter like so: ^patient|standard$ Which would give you the tables in the list that start with 'patient' and end with 'standard'; See More

FlexiblePsamathe's Experience

Nice t See More

Top Pro

Clean, neat, and easy to use interface

Top Con

Trigger edition

Until version 3.5.8 you can not edit triggers, only view (since 3.5.6). See More

Top Pro

Follow foreign key to their primary key

If you have a table with a foreign key you can click on it to see the table row where this key references to. See More

Top Con

Apache license

Top Pro

Formatted text view

It has the classic grid view and a well-organized text view that you can quick-select with CTRL-A. See More

Top Pro

Free

It it licensed under GPL v2. See More

Built by Slant

Find the best product
instantly.

Stop wasting time searching endlessly. Lustre recommends the best products at their lowest prices – right on Amazon.

4.7 star rating

Add to Chrome - It's Free Try now - it's free

11 Other Options Considered

DataGrip

Add Video or Image

Top Pro

Friendly interface

Zero learning curve interface for those who have expeirence with another IntelliJ IDE. See More

Top Con

Expensive

As of January 2018, Jet Brains charges $89 for 1st year, $71 for 2nd year, and $53 for every 3rd year and onwards for individual customers. See More

Don Alfons Nisnoni's Experience

Great for beginners See More

Top Pro

Easy to add external database drivers using JDBC

For example, it is easy to get DataGrip to work with Spark SQL / Thriftserver See More

Top Pro

Helps you avoid mistakes

It can catch SQL bugs and suggest ways to resolve them. It will inform of unresolved objects and the use of keywords as identifiers. See More

Top Pro

Powerful data editor

A powerful data editor lets you add, remove, edit, and clone data rows. Navigate through the data by foreign keys and use the text search to find anything in the data displayed in the table editor. All your changes are stored locally and can be submitted at once. Multiple fields can also be edited at once. See More

Top Pro

Good integration with other IntelliJ tools

Sqlectron

Add Video or Image

Top Con

Unmaintained

The creator stopped working on the project, it is in need of maintainers. See More

Top Pro

Built-in support for major databases

Sqlectron supports PostgreSQL, MySQL (and MariaDB), MSSQL Server, SQLite, and Cassandra. See More

DaringHera's Experience

I used to use Squirrel but switched to Sqlectron because I was tired of installing plugins for mysql and postgres on every computer I installed Squirrel on. Sqlectron has major database support built-in, so no need for plugins. See More

Specs

Platforms:Windows, Linux, Mac

Top Con

Written in Electron

Top Con

No plugins

Top Con

Buggy

Sqlectron is installable and that's about it. You can't actually add servers to connect to in the app, making it a 200 MB paperweight. See More

MySQL Workbench

Add Video or Image

Top Pro

Community version

There is a community edition available that is free and open source; licensed under GPL. See More

Top Con

Freezes constantly

Running any kind of query with more than a thousand records or even just opening a file and other actions crashes the application. You are unable to actually stop a query. You have to kill from Windows Task Manager every single time. See More

GenuineElkunirsa's Experience

As of Ubuntu 19.04 workbench crashes with every first table update query due to unable to load the dialogue window, this also affects query saving or any use of the dialogue window. Editing fields with large content is also impossible due to render issues. Anyone facing this issue, first select a field with less content on the same row and tab into the field you wish to paste into. 6 months after a major release of OS this should be working, it feels more like this tool is being dropped. See More

Specs

Platforms:Windows, Linux, Mac

Top Pro

Cross-platform

Works on Windows, Linux, OS X. See More

Top Con

Very buggy under Ubuntu 19.04

Dialogue windows crash the application. Large fields cannot be pasted into due to render issues. And many more bugs... See More

EmpatheticMehen's Experience

Too complicated, not able to scale up size of fonts etc, installs its own java See More

Top Pro

EER diagramming

MySQL Workbench has enhanced entity–relationship modeling support. See More

Top Con

Complicated

Sometimes it’s too hard to understand how developers implemented certain features. See More

Top Pro

Database synchronization

Forward & reverse engeneering See More

Top Con

Unintuitive UI

Workbench's user interface is regarded by a lot of users as unintuitive and hard to use. It seems cluttered and hard to get used to. The left side of the application has several sections (which you get to choose which to open) with several tools for each. A lot of features are hidden behind menus and need some getting used to find them. See More

Top Pro

Easy to use

Actions can be directly carried out on tables. The software prepares the relevant query for approval before execution. See More

Top Con

Column size is limited

Can't read columns bigger than 65534 chars. See More

SQL Workbench

Add Video or Image

Oracle SQL Developer / Raptor

Add Video or Image

CourageousPersephone's Experience

this company does not allow the download of this software See More

TeamSQL

See flagged products

Explore our new Product Comparison Pages

Built By the Slant team

Find the best product instantly.

Lustre recommends the best products at their lowest prices – right on Amazon.

4.7 star rating

Try it now - it's free

Lustre.ai illustration