DEV Community

Levi Velázquez for Fullstapps

Posted on

What is your favorite SQL viewer/tool

It should be great to compile a list of best SQL viewers/tools available out there. So, based on the requirements, sometimes we need a simple interface for viewing a table, others, we need a whole tool for making more complex process over a DB (Save queries, Entity-Relationship diagrams, etc)

Let's make a list of best SQL viewer/tools in the market.

Updated list:

  • DBeaver
  • PSequel (simplest one, just for PostgreSQL)
  • TablePlus
  • HeidiSQL
  • DbBrowser
  • MYSQL Workbench
  • Oracle SQL Developer

Top comments (8)

Collapse
 
rocambille profile image
Romain Guillemot

I like adminer. Once you installed PHP, it's just one PHP file (+ 1 css file if you use a theme) to install where you want. It's faster than PHPMyAdmin and simpler than MySQL Workbench IMO :)

Collapse
 
jmfayard profile image
Jean-Michel 🕵🏻‍♂️ Fayard • Edited

what is your favorite tool to XXX :D

IntelliJ IDEA Ultimate.

No matter what XXX is :D

Collapse
 
peledzohar profile image
Zohar Peled

I work with Microsoft SQL Server, so the natural selection for me is SQL Server Management Studio (A.K.A SSMS). It has a list of add-ins that can make life easier - some are free, some costs money.

Collapse
 
srinivasskc profile image
Srinivas Kadiyala

MYSQL Workbench
Oracle SQL Developer

Collapse
 
sdktalks profile image
Sodeeq Olamide

I like and use PHPMyAdmin, I use HeidiSQL as well for MySQL.
Then I use DbBrowser to view Sqlite db

Collapse
 
mike_hasarms profile image
Mike Healy

I just came across TablePlus which looks very promising

Collapse
 
pawsql profile image
Tomas@PawSQL

PawSQL Advisor, it's a IntelliJ based plugin for query optimization(query rewrite and index recommendation). And you can also use it online on PawSQL Cloud.

Some comments may only be visible to logged-in visitors. Sign in to view all comments.