DEV Community

Levi Velázquez for Fullstapps

Posted on

2 1

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.

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more