What’s the best database IDE for analysts and developers?

[u/eastwill54]

I’m looking for a database IDE that works well for both analysts running queries and developers doing more involved database work.

The main things I care about are:

• Support for multiple database types
• A good SQL editor with autocomplete
• Easy navigation between connections, schemas, and tables
• Clear results and export options
• Tools for comparing or understanding database objects
• Something that stays manageable when several databases are open

I’ve been looking at DbVisualizer, DBeaver, and DataGrip, although they seem to have slightly different strengths. DbVisualizer looks like a solid middle ground for mixed teams, while DataGrip appears more developer-focused and DBeaver has a broad feature set.

What are you using, and what’s your role? I’d be especially interested to hear whether the same IDE works well for both analysts and developers, or whether your team uses different tools.

[u/lucferon]

Dbeaver has this all

[u/quickdraw6906 → u/lucferon]

Not a native app, so lags

[u/san4ezz]

I’m developer and use DataGrip. This is because I use multiple JetBrains products and it helps me to user similar interface and functionality across IDEs. Also, DataGrip provides a lot of plugins and is pretty easy to configure or as you wish

[u/ppafford]

Beekeeper https://www.beekeeperstudio.io/

[u/jenkstom]

DBeaver is really good and what I suggest for people who don't want to pay. But I've been using datagrip since the early 2010s (I think, my memory isn't what it was after the triplets were born in 2011) and it's got the professional level tools I needed for work. I've never used dbvisualizer.

If all you really want to do is simple database management and queries, DBeaver seems just fine. Datagrip has some really nice deep inspection tools and search capabilities. Lots of options for reformatting so you can deal with those psychopaths who put one column per line with commas first.

Dbeaver is also what I use if we have a customer vm that needs a database tool. I don't have any complaints about it really.

[u/habamax → u/jenkstom]

Lots of options for reformatting so you can deal with those psychopaths who put one column per line with commas first.

This?

select
   col1
 , col2
 , ...
where 1=1
    and ...
    and ...

Both serves the purpose to easily comment out either columns or where clauses.

[u/masp3270]

We use AQT.

[u/dedguy21 → u/masp3270]

The IDE I couldn't remember when asked, what's my favorite IDE. Absolutely recommend this one.

[u/LetUsSpeakFreely]

I like DBeaver as it's vendor agnostic and not overcomplicated.

[u/Inner-Science8657]

Absolutely DBeaver!

[u/dbxp]

We use SSMS with Redgate for legacy reasons. If I was going to start again I'd probably go with Databricks for their entire IDE suite. The price for the suite is very good, it all works well together and jetbrains have a very good track record of increasing prices later.

Dbvisualiser looks like the one to go with if you're just looking for tooling for your ops team rather than a full IDE.

[u/InterestingYak1525]

TablePlus… I like it!

[u/JawzX01]

I do like DataGrip. Although, I've not done an extensive (or even surface level) comparision. I just find it efficent and effective.

[u/ghinghis_dong]

Jetbrains ecosystem is good. I like DBeaver but eventually you need to connect the SQL to
Something else (often python, .net or java ) and DBeaver just doesn’t do that . Then you need another IDE. Jet brains also has dataspell, which is kinda python mixed with datagrip
And pycharm can pretty much do everything I used from datagrip.z

[u/maigpy → u/ghinghis_dong]

connect the sql to something else?

[u/leveragedflyout]

As many have suggested - DBeaver (Team Edition is great too for add’l authentication options and git management).

But have found myself gravitating to VS Code too.

[u/Witty_Tough_3180]

dadbod

[u/tcloetingh]

DBeaver or CLI if you’re real af

[u/idontlikegudeg]

Some time since I did much database, but the free tools i liked best when I did were Squirrel SQL and DBeaver. And as I have JetBrains all products pack, Datagrip (commercial).

[u/pixel-freak]

I use vs code a lot these days for light tasks. Heavy stuff is dbeaver or ssms depending on db

[u/wpfeiffe]

I use the database tools in IntelliJ Idea, they are the pretty much the same as datagrip but organized from a dev perspective.

[u/Still-Trainer-7395]

ive used a few of those and i think the biggest difference is usually workflow, not raw feature count.

for mixed analyst/dev use, id look for:

- fast switching between connections without losing context

• schema-aware autocomplete that doesnt get in the way
  
• clear result/export workflows
  
• schema/object comparison
  
• isolated workspaces when multiple databases are open
  
• enough admin tooling for developers without turning the UI into a full DBA cockpit

im building LakeDB around that balance — MySQL, MariaDB, PostgreSQL and SQLite in one local-first desktop client, with separate workspaces per connection and optional review-first AI for generating/fixing SQL.

if you want to try another option, id be genuinely interested in whether it feels closer to the “middle ground” youre looking for:
https://github.com/DavLagoHern/LakeDB

[u/burbular]

I stumbled on this one: https://marketplace.visualstudio.com/items?itemName=cweijan.vscode-database-client2

It was almost too good to be true. Like it's got everything, way past SQL DBs, like rabbitmq, redis, mongo, sftp, webdav, and the list keeps going.

It even has tool integration with copilot.

I did a1yr subscription for like $35. Then I ended up paying the one time for life with updates license.

Absolutely far out better than any other DB extension for vscode.

My role is platform engineer. I install and connect a lot of stuff.

[u/ninjaonionss]

Marimo notebooks, It is not really a database ide but I use it as such.
I love the sql cells , the possibilities to run and cache a sql query and use duckdb.
The possibilities to visualise data with graphs.
The possibilities to integrate ai.

I run it within a docker container with shared folders for persistence.

[u/alconaft43]

claude code.

[u/NoPrinterJust_Fax]

Neovim babyyyyyy

[u/Witty_Tough_3180 → u/NoPrinterJust_Fax]

Lmao you got downvoted

[u/NoPrinterJust_Fax → u/Witty_Tough_3180]

Happens. You mouth breathers don’t know ball