sadopc

sadopc / gotermsql

Public

A full-featured terminal SQL IDE in Go. Supports PostgreSQL, MySQL, SQLite, and DuckDB. Features schema browser, autocomplete, syntax highlighting, vim keybindings, and single-binary distribution.

bubble-tea cli database duckdb golang
28
2
100% credibility
Found Feb 17, 2026 at 27 stars -- GitGems finds repos before they trend. Get early access to the next one.
Sign Up Free
AI Analysis
Go
AI Summary

gotermsql is a terminal-based SQL IDE supporting PostgreSQL, MySQL, SQLite, and DuckDB with schema browsing, autocomplete, vim keybindings, and streaming results in a single binary.

How It Works

1
📥 Download the app

Grab the single file for your computer from the releases page and run it right away.

2
🚀 Launch and connect

Open the connection screen, pick your database type like PostgreSQL or SQLite, and enter your details to link up.

3
🔍 Explore your data structure

See a clear tree of your databases, tables, columns, and keys – everything organized neatly on the side.

4
✏️ Write your query

Type SQL in the editor with helpful suggestions for tables, columns, and keywords popping up as you go.

5
▶️ Run and view results

Hit enter to execute – watch live results stream in, even for huge tables, with perfect formatting.

6
💾 Save or export

Copy history, tweak settings, or export data easily while keeping everything speedy.

✅ Master your data effortlessly

Now you browse, query, and manage any database like a pro, all from your terminal without hassle.

Sign up to see the full architecture

5 more

Sign Up Free

Star Growth

See how this repo grew from 27 to 28 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 gotermsql?

gotermsql is a full-featured terminal SQL IDE built in Go, delivering a single-binary distribution with zero dependencies for querying PostgreSQL, MySQL, SQLite, and DuckDB. It provides a schema browser for navigating databases/tables/columns, context-aware autocomplete, syntax highlighting, vim keybindings, multi-tab editing, and streaming results to handle massive datasets without memory issues. Download, run, connect via DSN—no installs, instant startup.

Why is it gaining traction?

Unlike Python-based tools like pgcli or Harlequin that require runtimes and slow to launch, gotermsql's pure Go single-binary starts instantly across platforms. It packs pro features like full modal vim editing, resizable panes, query history, audit logging, and CSV/JSON exports into one lightweight package supporting four DBs. Developers love the no-fuss multi-database workflow with real productivity boosters like batch schema loading.

Who should use this?

Backend engineers juggling Postgres and MySQL in terminals, data analysts prototyping with DuckDB or SQLite files, and vim users tired of mouse-driven GUIs like DBeaver. Ideal for quick ad-hoc queries on remote servers or local dev DBs where you need schema exploration, autocomplete, and huge result paging without bloat.

Verdict

Solid foundation for a terminal SQL IDE with thoughtful features, but 27 stars and 1.0% credibility score signal early immaturity—test coverage is strong, docs excellent, yet lacks battle-testing. Try it for personal workflows; hold off for team/prod until stars climb.

(198 words)

Sign up to read the full AI review Sign Up Free

Similar repos coming soon.