I Built a 25MB Terminal Database Studio to Replace 1.5GB DBeaver Bloat

Description and use

GhostBase is a lightweight terminal database studio that launches in under 120 ms, uses ~25 MB RAM, is keyboard-driven, and includes safety guards against accidental destructive queries.

Problem

Heavy GUI database clients like DBeaver and DataGrip launch slowly and consume excessive memory, causing delays and risk of accidental destructive queries on production databases.

Outcome

GhostBase provides a lightweight, instant-launch terminal database studio that reduces memory usage from 1.5 GB to ~25 MB, eliminates GUI delays, and adds safety features to prevent accidental destructive operations.

Workflow

• Install GhostBase via pip: pip install ghostbase-cli
• Run ghostbase in a project folder to auto-detect DATABASE_URL from .env or provide a connection string directly
• Use keyboard shortcuts: Ctrl+S for safety guard, Ctrl+B for SQL beautifier, Ctrl+P for query plan, Ctrl+I/M/E/J for exporting results
• Execute queries and review results in the terminal

Evidence

Every time I needed to run a quick SELECT, inspect an index, or check foreign key constraints, I found myself waiting 15+ seconds for heavy GUI clients like DBeaver or DataGrip to launch.

Source

By the time the splash screen disappeared, my laptop fans were spinning and my RAM had swallowed 1.5 GB+ of memory just to show a 4-row SQLite table.

Source

I wanted something different: Instant cold boot (under 120 ms). Lightweight footprint (~25 MB of RAM). Keyboard-driven workflow (no mouse hunting across menus). Built-in safety guard against accidental data loss.

Source

GhostBase is an open-source, keyboard-driven terminal database studio built with Python and Textual. It connects natively to SQLite, PostgreSQL, and MySQL.

Source

GhostBase inspects queries before execution. If it detects a dangerous statement (DELETE or UPDATE without a WHERE clause, DROP TABLE, TRUNCATE), it intercepts it immediately and demands double confirmation.

Source

Install directly from PyPI: pip install ghostbase-cli

Source