4yk5

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

Ghostman、キーボード操作中心のTUI製APIクライアント兼Webhookインスペクタ。Webhookの開発中はリクエストを受けて中身を見て、また叩き直す往復が多い。それをターミナルから出ずに回せるのが良さそう。SSH先のサーバー上でもそのまま使えるのが地味に効きそう。 4yk5/Ghostman

Show HN: Ghostman – A fast, keyboard-driven TUI API client and webhook inspector (github.com) Discussion | Main Link

I got tired of Postman eating 1.2GB of RAM and forcing cloud logins just to test an endpoint. So I built Ghostman 👻 — a lightweight, keyboard-driven terminal API client with an embedded webhook receiver. 100% local-first, zero bloat. 🔗 4yk5/Ghostman t.co

Show HN: Ghostman – A fast, keyboard-driven TUI API client and webhook inspector

4yk5/Ghostman A fast, keyboard-driven TUI API client & webhook inspector. No cloud, no Electron, 100% local-first. 4yk5/Ghostman

Show HN: Ghostman – A fast, keyboard-driven TUI API client and webhook inspector 4yk5/Ghostman

Show HN: Ghostman – A fast, keyboard-driven TUI API client and webhook inspector comments · posted on 2026.10.30 at 03:48:40 (c=1, p=3)

Show HN: Ghostman – A fast, keyboard-driven TUI API client and webhook inspector Discussion