DB Explorer — Database Query Tool & Explorer

Version: 3.0.6   |   Released: April 2026   |   © 2026 Astro Adept AI Labs

---

What is DB Explorer?

DB Explorer is a free, cross-platform tool for working with databases. Connect to your databases, write and run SQL queries, explore table structures, and let AI generate queries for you — all from a single, clean interface.

Works with PostgreSQL, MySQL, Oracle, SQL Server, SQLite, DynamoDB, and any JDBC-compatible database.

Getting Started

1. Download the latest JAR from GitHub Releases
2. Double-click the JAR or run: java -jar db-explorer-3.0.6.jar
3. Click the + button to add a database connection
4. Start writing queries

Requires Java 17 or newer.

Features

Multi-Tab Query Editor

Write SQL in a tabbed editor with syntax highlighting, auto-complete for keywords and table/column names, and undo/redo. Each tab uses its own independent database connection so you can run queries in parallel across multiple databases without tabs interfering with each other.

• Ctrl+Enter to run a query
• Ctrl+F to find text in the editor
• Ctrl+Z / Ctrl+Y to undo and redo
• Tab inserts spaces (4-space indent)

Fast Results

Query results load instantly, even on tables with millions of rows. Scroll down to load more data as you need it — there's no fixed row limit. Columns are sortable by clicking the header.

Schema Explorer

Browse your database structure in a tree: schemas, tables, views, materialized views, sequences, indexes, functions, and procedures. Expand a table to see its columns and types — primary key columns show a 🔑 icon and foreign key columns show a 🔗 icon. Right-click for quick actions like opening a query tab, viewing data, or exporting DDL.

Schema Diagram

Right-click any schema to open an interactive ER diagram showing tables and their foreign key relationships. Drag tables to rearrange, scroll to zoom, and click Fit to auto-layout. Export the diagram as a PNG image or copy it as Mermaid markup for docs and wikis.

AI SQL Generator

Describe what you want in plain English and get a ready-to-run SQL query. The AI knows your database schema and generates queries using your actual table and column names, always qualified with the schema name.

Supports OpenAI, Claude, DeepSeek, Gemini, and any OpenAI-compatible API. Configure your API key in Settings → AI Configuration.

Execution Plans

Analyze query performance with database-native explain plans. Each database type gets its own formatted view — interactive trees for PostgreSQL, color-coded tables for MySQL, and formatted text for SQL Server and Oracle.

Data Export

Export tables as DDL (CREATE TABLE), INSERT statements, UPDATE statements, or CSV. Exports stream to disk so even large tables won't run out of memory. Copy to clipboard or save to file.

Database Health Dashboard

Monitor your database in real time: active sessions, cache hit ratio, lock waits, running queries with duration, and JVM memory usage. Auto-refreshes every 2 seconds.

Themes

13 built-in themes you can switch instantly from the toolbar: Flat Dark, Flat Darcula, Flat Light, Flat IntelliJ, Ocean Blue, Forest Green, Sunset Purple, Cherry Red, Amber Warm, Arctic Frost, Rose Garden, System, and Metal. Your choice is remembered across restarts.

Self-Update

Check for new versions from the Help menu. Downloads and installs updates automatically with progress tracking.

Keyboard Shortcuts

Shortcut	Action
Ctrl+Enter	Run query
Ctrl+F	Find in editor
Ctrl+Z	Undo
Ctrl+Y / Ctrl+Shift+Z	Redo
Ctrl+Space	Auto-complete
Escape	Close find bar

License

Copyright © 2026 Astro Adept AI Labs. All rights reserved.

For licensing inquiries: ashish@astroadept.com