GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com β€” GitHub - fezcode/atlas.sql: Terminal-based SQL client for SQLite and PostgreSQL. Featuring interactive tables with horizontal/vertical scrolling, detail inspection for long records, quick CSV export, and a built-in SQL tutorial. Part of the Atlas Suite.

BranchesTags
Open more actions menu

Latest commit

 

History

9 Commits
9 Commits

Folders and files

NameName
Last commit message
Last commit date
internal
internal
 
 
.gitignore
.gitignore
 
 
LICENSE
LICENSE
 
 
README.md
README.md
 
 
Recipe.go
Recipe.go
 
 
banner-image.png
banner-image.png
 
 
go.mod
go.mod
 
 
go.sum
go.sum
 
 
main.go
main.go
 
 
recipe.piml
recipe.piml
 
 

Repository files navigation

Atlas SQL

Banner Image

atlas.sql is a lightweight, keyboard-centric terminal user interface (TUI) for interacting with SQL databases. Part of the Atlas Suite, it provides a streamlined experience for running queries, visualizing results, and managing data directly in your terminal.

Go Version Version Platform

✨ Features

  • πŸ—„οΈ Multi-Engine Support: Seamlessly connect to SQLite and PostgreSQL.
  • 🌈 Syntax Highlighting: Write and view queries with real-time feedback.
  • πŸ“Š Interactive Tables: Navigate query results with arrow-key based horizontal and vertical scrolling.
  • πŸ” Detail View: Press v to see the full content of a selected row in a scrollable vertical viewβ€”perfect for long text fields.
  • πŸ“ Dynamic Resizing: Adjust column widths on the fly using + and - keys.
  • πŸ“‹ CSV Export: Copy entire result sets to your clipboard instantly with c.
  • πŸ›‘οΈ Safety First: Automatically appends LIMIT 500 to SELECT statements if no limit is specified.
  • πŸ“ Full DDL/DML: Support for CREATE, INSERT, UPDATE, and DELETE with "rows affected" reporting.
  • πŸŽ“ Built-in Tutorial: Access a quick SQL cheat sheet directly inside the help menu.
  • πŸ“¦ Cross-Platform: Binaries available for Windows, Linux, and macOS.

πŸš€ Installation

From Source

git clone https://github.com/fezcode/atlas.sql
cd atlas.sql
go build -o atlas.sql .

⌨️ Usage

Run the tool by providing a connection string:

SQLite

./atlas.sql sqlite://path/to/db.sqlite

PostgreSQL

./atlas.sql "postgres://user:password@localhost:5432/dbname?sslmode=disable"

πŸ•ΉοΈ Controls

Key Action
Enter Execute SQL query
Tab Switch focus between Input and Table
↑ / ↓ Navigate result rows
← / β†’ Scroll table columns horizontally
+ / - Increase / Decrease column width
v Toggle Detail View for selected row
c Copy entire result set as CSV to clipboard
h Toggle the interactive Help & SQL Tutorial
Ctrl+T Quick-list all tables in the database
Ctrl+S Quick-list all schemas/attached databases
Esc Clear Input / Exit focus / Close menus
q / Ctrl+C Quit

πŸ—οΈ Building for all platforms

The project uses gobake to generate binaries for all platforms:

gobake build

Binaries will be placed in the build/ directory.

πŸ“„ License

MIT License - see LICENSE for details.

About

Terminal-based SQL client for SQLite and PostgreSQL. Featuring interactive tables with horizontal/vertical scrolling, detail inspection for long records, quick CSV export, and a built-in SQL tutorial. Part of the Atlas Suite.

Topics

atlas-suitebubbleteacsv-exportdatabase-toolgolangpostgresqlsql-clientsql-tutorialsqliteterminal-uitui

Resources

Readme
MIT license
Activity

Stars

1 star

Watchers

0 watching

Forks

0 forks
Report repository

Releases

Packages

Contributors

Languages

You are visitor 01402503 β€” GeezerVison does not store the pages you look up.
Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800Γ—600. No cookies required.