I Built a 25MB Terminal Database Studio to Replace 1.5GB DBeaver Bloat
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.
Even worse? The constant dread of accidentally executing a destructive UPDATE or DELETE statement without a WHERE clause on a production database.
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.
So I built GhostBase 👻.
---
⚡ What is GhostBase?
GhostBase is an open-source, keyboard-driven terminal database studio built with Python and Textual. It connects natively to SQLite, PostgreSQL, and MySQL.
No Java runtimes. No Electron wrapper. Zero telemetry.
---
🛡️ Key Features
1. Production Safety Guard & Safe Mode (Ctrl + S)
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. In Safe Mode, all destructive operations are strictly blocked.
2. 1-Key SQL Beautifier (Ctrl + B)
Messy, one-line queries? Hit Ctrl + B to auto-capitalize keywords (SELECT, FROM, WHERE, JOIN, ORDER BY) and indent sub-clauses instantly.
3. 1-Key Query Plan Inspector (Ctrl + P)
Press Ctrl + P to execute an instant EXPLAIN QUERY PLAN on any query to detect missing indexes and table scan bottlenecks.
4. Zero-Config .env Auto-Connect
Run ghostbase in any project folder; it automatically discovers your DATABASE_URL from your local .env file without typing credentials.
5. Multi-Format Exports
Export any query results directly from the terminal:
- SQL INSERTs (Ctrl + I): Generates executable INSERT INTO statements.
- Markdown Tables (Ctrl + M): Ready to paste directly into GitHub Issues, PRs, or Notion.
- CSV (Ctrl + E) & JSON (Ctrl + J)
---
🚀 Quick Start
Install directly from PyPI:
pip install ghostbase-cli
Launch it with your database:
# Auto-detect local .env
ghostbase
# Or connect directly
ghostbase path/to/database.db
ghostbase postgresql://user:password@localhost:5432/my_db
ghostbase mysql://user:password@localhost:3306/my_db
---
🤝 Open Source & Feedback
GhostBase is completely open-source under the MIT License.
⭐ GitHub Repository: 4yk5/GhostBase
If you find it useful, feel free to drop a star on GitHub! I'd love to hear your feedback, feature ideas, and suggestions in the comments below.
Mentions
I Built a 25MB Terminal Database Studio to Replace 1.5GB DBeaver Bloat 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. Even worse? The constant dread of accidentally executing a destructive UPDATE or DELETE statement without a WHERE clause on a production database. 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. So I built GhostBase 👻. --- ⚡ What is GhostBase? GhostBase is an open-source, keyboard-driven terminal database studio built with Python and Textual. It connects natively to SQLite, PostgreSQL, and MySQL. No Java runtimes. No Electron wrapper. Zero telemetry. --- 🛡️ Key Features 1. Production Safety Guard & Safe Mode (Ctrl + S) 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. In Safe Mode, all destructive operations are strictly blocked. 2. 1-Key SQL Beautifier (Ctrl + B) Messy, one-line queries? Hit Ctrl + B to auto-capitalize keywords (SELECT, FROM, WHERE, JOIN, ORDER BY) and indent sub-clauses instantly. 3. 1-Key Query Plan Inspector (Ctrl + P) Press Ctrl + P to execute an instant EXPLAIN QUERY PLAN on any query to detect missing indexes and table scan bottlenecks. 4. Zero-Config .env Auto-Connect Run ghostbase in any project folder; it automatically discovers your DATABASE_URL from your local .env file without typing credentials. 5. Multi-Format Exports Export any query results directly from the terminal: - SQL INSERTs (Ctrl + I): Generates executable INSERT INTO statements. - Markdown Tables (Ctrl + M): Ready to paste directly into GitHub Issues, PRs, or Notion. - CSV (Ctrl + E) & JSON (Ctrl + J) --- 🚀 Quick Start Install directly from PyPI: pip install ghostbase-cli Launch it with your database: # Auto-detect local .env ghostbase # Or connect directly ghostbase path/to/database.db ghostbase postgresql://user:password@localhost:5432/my_db ghostbase mysql://user:password@localhost:3306/my_db --- 🤝 Open Source & Feedback GhostBase is completely open-source under the MIT License. ⭐ GitHub Repository: 4yk5/GhostBase If you find it useful, feel free to drop a star on GitHub! I'd love to hear your feedback, feature ideas, and suggestions in the comments below.
Show HN: GhostBase – 25MB terminal database studio for SQLite, Postgres, MySQL