nabsk911

nabsk911 / pgterm

Public

A terminal-based interface (TUI) for PostgreSQL, written in Go. It allows you to connect to a PostgreSQL database, run queries, and browse tables directly from your terminal.

31
1
100% credibility
Found Feb 07, 2026 at 14 stars 2x -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
Go
AI Summary

pgterm is a terminal-based tool for connecting to PostgreSQL databases, browsing tables, running queries, and viewing results in a user-friendly interface.

How It Works

1
🔍 Discover pgterm

You hear about pgterm, a handy tool for checking and managing your database right from the terminal.

2
🚀 Launch the app

You open your terminal, start pgterm, and see a simple form to connect to your database.

3
🔗 Enter connection details

You type in your database's address, port number, username, password, and database name to link up.

4
✅ Connect and explore

It connects smoothly, showing a list of your tables on one side so you can pick what to look at.

5
✏️ Write and run a query

You type a question about your data in the query box and hit the special key to see the answers.

6
📊 View your results

The answers pop up in a clear table below, easy to read and scroll through.

🎉 Master your data

Now you can quickly browse tables, ask questions, and handle your database anytime from the terminal.

Sign up to see the full architecture

5 more

Sign Up Free

Star Growth

See how this repo grew from 14 to 31 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 pgterm?

pgterm is a terminal-based interface for PostgreSQL, built in Go as a TUI that lets you connect to a database, browse tables, run queries, and view results directly from your terminal. It solves the pain of firing up bulky GUI tools like pgAdmin for quick checks—instead, you get a full-screen text-based interface with split panes for tables, query input, and formatted results. Just run `pgterm` after a simple `go install`, fill a connection form, and you're querying away.

Why is it gaining traction?

It stands out from plain psql or enhanced CLIs like pgcli with visual table browsing, a dedicated query editor, and instant result tables, all driven by efficient Alt-key shortcuts for focusing panes and executing queries. Developers dig the keyboard navigation—no mouse needed—and the way it loads public schema tables on connect, auto-populates sample results, and handles both SELECTs and updates cleanly. The clean, dim-themed layout keeps your terminal workflow smooth without web-based terminal distractions.

Who should use this?

Backend engineers SSH'd into servers needing fast Postgres peeks without GUI overhead. DevOps folks scripting quick table browses or query tests during deploys. Terminal purists ditching DBeaver for lightweight, always-available DB access on remote machines.

Verdict

With 20 stars and a 1.0% credibility score, pgterm feels early-stage—docs are basic, no tests visible—but it's a solid prototype for terminal-based Postgres work. Try it if TUIs are your jam; otherwise, stick to mature alternatives until it matures.

(198 words)

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.