sqlit is a keyboard-driven terminal interface for working with databases directly from your command line. It eliminates the need for heavy GUI applications by providing a lightweight, fast alternative that developers and database administrators can use to query, inspect and manage data across multiple database systems.
The tool supports an extensive range of databases including PostgreSQL, MySQL, SQLite, SQL Server, MariaDB, DuckDB, ClickHouse, Snowflake, Supabase, Turso, BigQuery, Redshift and many others through a flexible adapter system. This makes it ideal for teams working with diverse database technologies.
Key capabilities include:
The interface keeps keybindings visible on screen and requires no complex configuration. Simply run sqlit, select a connection and start querying. It's designed for developers who want to inspect schemas, run quick queries and work with multiple databases without launching resource-heavy applications.
$ pipx install sqlit-tui