mujib77

mujib77 / cosmo

Public

Cosmo is a terminal user interface (TUI) that provides real-time visibility into PostgreSQL database health, query performance, lock contention, and WAL/MVCC internals. Built in Go.

bubbletea golang lipgloss pgx-v5 postgresql
22
0
100% credibility
Found May 23, 2026 at 22 stars -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
Go
AI Summary

Cosmo is a real-time terminal dashboard for PostgreSQL databases. It connects directly to your database and displays four live panels showing your database overview (size, connections, cache health), active queries with their execution time, WAL (write-ahead log) activity and vacuum statistics, and lock contention details. The program runs entirely in your terminal with a colorful, animated interface that auto-refreshes every two seconds. You can switch between panels using keyboard shortcuts and see health-based color coding that turns green for healthy metrics, amber for warnings, and red for critical issues. It's designed for developers and database administrators who want to understand what's happening inside their PostgreSQL database without opening a browser or external monitoring service.

How It Works

1
🔍 You discover Cosmo

You find this tool online and learn it shows what's happening inside your PostgreSQL database, right in your terminal.

2
💡 You learn what it does

The tool displays four live panels showing your database overview, active queries, write activity, and any lock conflicts — all updating automatically.

3
🔗 You connect your database

You provide your database address and credentials, and Cosmo connects directly to read what's happening inside.

4
🚀 You launch the program

You run a simple command and watch a fun animated startup sequence as Cosmo boots up like a mission control center.

5
👀 You watch your database breathe

The dashboard appears with live data — you see your active connections, running queries with their timers, and your database health at a glance.

6
You explore with simple keys
📊
Check the overview panel

See your database name, size, connection usage, cache performance, and total transactions.

⚡
Monitor active queries

Watch which queries are running, their state, and how long they've been executing in real time.

📝
Review WAL activity

See how fast your database is writing to its transaction log and when vacuuming last ran.

🔒
Spot lock contention

Identify which tables have locks and which processes are waiting for access.

✅ You understand your database

Now you can see exactly what's happening inside your PostgreSQL database — no guessing, no browser, just clear live information in your terminal.

Sign up to see the full architecture

5 more

Sign Up Free

Star Growth

See how this repo grew from 22 to 22 stars Sign Up Free
Repurpose This Repo

Repurpose is a Pro feature

Generate ready-to-use prompts for X threads, LinkedIn posts, blog posts, YouTube scripts, and more -- with full repo context baked in.

Unlock Repurpose
AI-Generated Review

What is cosmo?

Cosmo is a terminal-based dashboard for PostgreSQL that gives you real-time visibility into database health, query performance, lock contention, and WAL/MVCC internals. Built in Go using the Bubbletea framework, it connects directly to your Postgres instance and displays four monitoring panels that update every 2 seconds. No browser, no external service, no configuration beyond a database URL.

Why is it gaining traction?

The appeal here is immediate: you get production-grade Postgres insights without the overhead of external monitoring tools. The interface uses color-coded health indicators and visual progress bars to surface critical metrics at a glance. Developers can jump between panels with TAB, manually refresh with R, or quit with Q—all keyboard-driven for efficiency.

Who should use this?

Backend engineers debugging slow queries or lock contention will find the Active Queries and Locks panels immediately useful. DBAs monitoring WAL activity and cache hit ratios get a lightweight alternative to pgAdmin or external dashboards. Anyone running PostgreSQL 17+ in development or production environments can benefit from quick visibility without additional infrastructure.

Verdict

Cosmo delivers solid functionality for a niche use case, but the 1.0% credibility score and 22 stars suggest limited community validation. The code structure is clean and the feature set is practical, though the lack of extensive testing and documentation makes it feel less battle-tested than established monitoring tools. Worth trying for local development or small deployments, but teams needing enterprise-grade reliability should consider more mature alternatives first.

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.