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: https://github.com/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.