# Maxteabag/sqlit

A user friendly TUI for SQL databases. Written in python. Supports SQL server, Mysql, PostreSQL, SQLite, Turso and more.

Repository: https://github.com/Maxteabag/sqlit
Canonical: https://ross.abutalabs.com/products/sqlit
Language: Python
License: MIT
License Family: permissive
Topics: cockroachdb, command-line-tool, duckdb, mariadb, mysql, oracle, postgresql, python, sql, sqlite, ssh, tui, turso
Last push: 2026-08-26T19:51:18+00:00

## Health v2 (maintenance only)
Score: 79/100 (v2, computed 2026-09-03T02:39:23.370411+00:00)
- activity 99, release rhythm 87, longevity 18
- inputs: {"age_days": 264, "days_push": 7, "days_rel": 7, "gap_med": 0.0, "n_releases_24m": 61}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 4720, forks 156 (observed 2026-08-28T04:08:57.485818+00:00)

## What it is
sqlit is a terminal user interface (TUI) for connecting to and querying SQL databases, described as 'the lazygit of SQL databases'. It supports a wide range of databases including PostgreSQL, MySQL, SQLite, SQL Server, and many cloud and analytical engines, with features like Docker auto-discovery, SSH tunnels, and secure credential storage.

## Use cases
- query sql databases from the terminal
- browse tables and views in postgres or mysql without a gui
- auto-discover and connect to database containers in docker
- connect to remote databases over ssh tunnels
- fuzzy search and filter millions of query result rows
- manage saved database connections with secure password storage
- run sql queries with vim-style keybindings and syntax highlighting

## When to choose
- you want a fast, keyboard-driven alternative to heavy database GUIs like SSMS or pgAdmin
- you work with many different database engines and want one consistent terminal client
- you frequently connect to databases running in Docker containers
- you need SSH tunneling and OS keyring credential storage built in

## When to avoid
- you need a graphical interface with charts, ER diagrams, or visual table editing
- you require advanced database administration features like user management or backup scheduling
- you need a web-based or shared team database client

## Facets
- artifact type: cli-tool
- maturity: active
- function: database, cli, terminal-ui, search-engine
- domain: databases, developer-tools
- platform: windows, cli, python
- tags: tui, sql-client, database-client, docker-discovery, ssh-tunnels, vim-keybindings, lazygit-style, command-line, linux, macos

## Member repositories
- Maxteabag/sqlit (main) score 79

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:08:57.485818+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T18:19:05.720144+00:00, confidence not recorded.
  - readme: https://github.com/Maxteabag/sqlit (fetched 2026-08-28T04:08:57.485818+00:00, sha b73de0369e19)
- Data as of 2026-08-30T08:39:29.467469+00:00.