DEV Community: Ashish Srivastava

DB Explorer: A Lightweight Database Viewer I Built for Everyday Development Work

Ashish Srivastava — Sat, 19 Sep 2026 13:14:24 +0000

I have spent a good chunk of my career jumping between different databases — PostgreSQL, MySQL, SQL Server, Oracle, SQLite. And over time, I realized something simple:
Most database clients are way heavier than what I actually need on a daily basis.

Sometimes I just want to:

quickly inspect a schema

browse a few tables

run a couple of queries

check column types

validate some test data

But the tools available feel like full IDEs. They’re powerful, sure, but they come with long startup times, big memory footprints, and a lot of UI clutter.

So I ended up building something small and focused.

What is DB Explorer?
DB Explorer is a lightweight, open‑source database explorer that tries to keep things simple. It’s not meant to replace full‑blown DB management tools. It’s meant for the everyday stuff — the quick checks, the small tasks, the moments when you don’t want to wait for a giant tool to boot up.

You can download it here:
👉 https://sourceforge.net/projects/db-explorer/

Why I built it
This started as a personal itch. I was working on multiple projects, each with different databases, and I kept switching tools. Some were too slow, some were too complex, and some only supported one database engine.

I wanted something that:

opens fast

doesn’t eat RAM

works across multiple databases

has a clean, predictable UI

doesn’t try to do everything

So I built DB Explorer around those ideas.

What it currently supports
Right now, DB Explorer lets you:

connect to multiple database engines

browse schemas and tables

view table data

inspect columns and constraints

run SQL queries

switch between databases easily

It’s intentionally minimal. I’d rather keep it fast and focused than turn it into another heavyweight tool.

Who might find it useful
If you’re a developer who frequently checks data during development, or a tester validating records, or a student learning SQL, this might fit nicely into your workflow.

It’s also handy if you prefer tools that don’t require a ton of setup or configuration.

What’s next
I’m actively improving it. A few things on my list:

more database engines

smoother query editor

better table data viewer

small UI refinements

community suggestions

If you try it and have feedback, I’d genuinely appreciate it. Even small comments help shape the direction.

Closing thoughts
This isn’t meant to compete with the big tools. It’s just something I built because I needed it — and I figured others might find it useful too.

If you want to check it out or give feedback:
👉 https://sourceforge.net/projects/db-explorer/

Thanks for reading. If you end up using it, I’d love to hear how it works for you.

One Free Database Client That Replaced Five Tools in My Daily Workflow

Ashish Srivastava — Sun, 10 May 2026 05:02:38 +0000

If you work with more than one database engine, you know the pain. PostgreSQL means pgAdmin. MySQL means Workbench. SQL Server means SSMS. Oracle means SQL Developer. DynamoDB means the AWS Console.

Demo : https://www.youtube.com/watch?v=_NXphANViKM
Download : https://sourceforge.net/projects/db-explorer/

That’s five tools, five interfaces, five sets of shortcuts — and none of them talk to each other.

I switched to DB Explorer six months ago and haven’t opened any of those tools since. Here’s what makes it different from everything else I’ve tried.

It Connects to Everything From One Window

PostgreSQL, MySQL, SQL Server, Oracle, SQLite, and Amazon DynamoDB. One interface. One set of keyboard shortcuts. One mental model.

You add a connection, pick the database type, and you’re in. The schema tree, query editor, and results panel work identically regardless of which engine you’re connected to. No context switching, no re-learning where things are.

The DynamoDB support alone is worth mentioning — try finding another free GUI that lets you query DynamoDB tables with a familiar SQL-like experience. I couldn’t.

AI Writes Queries Using Your Actual Schema

This isn’t a generic ChatGPT wrapper. DB Explorer reads your database schema — tables, columns, types, relationships — and feeds that context to the AI model. When you type “show me all orders from last week with customer names,” it generates a query using your real table and column names, properly qualified with the schema.

It supports OpenAI, Claude, DeepSeek, Gemini, and any OpenAI-compatible API. You bring your own key, pick your model, and the AI assistant lives right inside the app. No copy-pasting schema definitions into a separate chat window.

For someone who writes dozens of queries a day across unfamiliar schemas, this saves real time.

It Starts in One Second and Uses 100MB of RAM

I’m not exaggerating. Double-click the JAR, and you’re looking at the query editor in about a second. Memory stays under 200MB even with multiple tabs and large result sets open.

Compare that to DBeaver (5+ seconds to start, 500MB+ RAM idle) or DataGrip (8+ seconds, easily over 1GB). When you need to quickly check something in production, startup time matters.

The entire application is a single 25MB JAR file. No installer, no Electron runtime, no 500MB download. It runs on Windows, macOS, and Linux — anywhere Java 17 is available.

Each Tab Gets Its Own Connection

This sounds like a small thing until you’ve been bitten by it. In most database tools, tabs share a connection. Run a long query in one tab, and your other tabs freeze or throw “portal does not exist” errors.

DB Explorer gives each query tab its own dedicated JDBC connection. Run five queries in parallel across five tabs — they don’t interfere with each other. No cursor collisions, no transaction leaks between tabs.

Execution Plans That Actually Help

Click the “Explain Plan” tab and the plan executes automatically — no extra button click. PostgreSQL plans render as interactive trees with cost fractions, row estimates, and color-coded nodes so you can spot sequential scans instantly. MySQL plans display as formatted tables with type indicators.

If the plan fails (like when you accidentally have multiple statements selected), the error shows right in the panel instead of being buried in a log file somewhere.

Real-Time Health Dashboard Without Prometheus

Click the Health tab and you get live metrics: active sessions, cache hit ratio, lock waits, currently running queries with elapsed time, and JVM memory usage. Updates every 2 seconds.

No Grafana. No Prometheus. No docker-compose file with six services. Just click a tab and see what your database is doing right now. During a production incident, this is the fastest path to “what’s happening.”

The Small Things That Add Up

Cell selection and copy — Click individual cells, Ctrl+C copies tab-delimited text that pastes perfectly into Excel or Google Sheets. Right-click for “Copy with Headers.”
13 themes — Dark, light, and everything in between. Switches instantly.
Schema tree with icons — Primary keys get 🔑, foreign keys get 🔗. Expand a table to see columns, indexes, constraints, foreign keys, and triggers in organized sub-folders.
Data export — DDL, INSERT, UPDATE, or CSV. Streams to disk so large tables don’t blow up memory.
Self-update — Check for updates from the Help menu. Downloads and installs without leaving the app.
Find in editor — Ctrl+F with match highlighting, next/previous navigation.

Who Is This For?

Developers who work with multiple database engines and want one tool instead of five
DBAs who need quick health checks without setting up monitoring infrastructure
Data analysts who write ad-hoc queries and want fast results with easy copy-paste to spreadsheets
Anyone who’s tired of waiting 8 seconds for their database tool to start

Try It

DB Explorer is free, open source, and requires no installation. Download the JAR, double-click it, add a connection, and start querying.
SourceForge: https://sourceforge.net/projects/db-explorer/
Demo : https://sourceforge.net/projects/db-explorer/

If you try it, I’d genuinely like to hear what you think — what works, what’s missing, what would make you switch from your current tool permanently.

🚀 DB Explorer 3.0.1 — The AI‑First SQL Editor You’ll Want to Try

Ashish Srivastava — Fri, 10 Apr 2026 21:59:09 +0000

Developers spend a surprising amount of time writing SQL, debugging queries, and navigating schemas.
DB Explorer 3.0.1 aims to change that.
This release introduces a fully schema‑aware AI SQL Generator with support for OpenAI, Claude, DeepSeek, Gemini, and custom endpoints.
Other highlights:

Multi‑database support
Execution plan viewer
Health dashboard
Multi‑tab SQL editor
13 themes
JVM‑bundled builds If you work with databases daily, this tool is worth exploring. We’re actively collecting feedback to shape the next version.

https://sourceforge.net/projects/db-explorer/

I built a free desktop SQL client with a live database health dashboard

Ashish Srivastava — Sat, 28 Mar 2026 23:50:50 +0000

What is DB Explorer?

DB Explorer is a free, open desktop database client built in Java. It supports
PostgreSQL, MySQL/MariaDB, Oracle, SQL Server, SQLite, and AWS DynamoDB — all from
one tool, with no subscription, no telemetry, and no account required.

What's new in v2.1

The big addition is a live Database Health Dashboard. When you enable it for a
connection, it opens a dedicated background JDBC connection (separate from your
query connection) and polls your database's own system views on a configurable
interval (5–30 seconds).

What it shows:

Active sessions — pulled from pg_stat_activity, SHOW PROCESSLIST, v$session, sys.dm_exec_sessions depending on your DB. Your own session is highlighted.
Server stats — cache hit ratios, commits, rollbacks, wait events
Connection health — green/red indicator, reconnect count, last check timestamp
JVM resources — heap usage bar (amber >70%, red >90%), thread count, GC stats
SQL warnings log — circular buffer of the last 100 warnings

The dashboard is opt-in and disabled by default. Stopping it immediately closes the
background thread and JDBC connection — no background activity unless you turn it on.

Download

https://sourceforge.net/projects/db-explorer/

It's a single fat JAR — just java -jar db-explorer-2.1.jar and you're running.

Feedback welcome, especially from Oracle and SQL Server users.