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

Описание и применение

GhostBase – легковесный терминальный редактор баз данных, запускающийся за 120 мс и потребляющий ~25 МБ RAM, с клавиатурным управлением и защитой от случайных разрушительных запросов.

Задача

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.

Результат

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.

Рабочий процесс

• 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

Доказательства

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.

Источник

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.

Источник

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.

Источник

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

Источник

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.

Источник

Install directly from PyPI: pip install ghostbase-cli

Источник