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 (9)

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 :)

jmfayard profile image
Jean-Michel Fayard πŸ‡«πŸ‡·πŸ‡©πŸ‡ͺπŸ‡¬πŸ‡§πŸ‡ͺπŸ‡ΈπŸ‡¨πŸ‡΄ • Edited

what is your favorite tool to XXX :D

IntelliJ IDEA Ultimate.

No matter what XXX is :D

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.

srinivasskc profile image
Srinivas Kadiyala

MYSQL Workbench
Oracle SQL Developer

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

mike_hasarms profile image
Mike Healy

I just came across TablePlus which looks very promising

pawsql profile image

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.