Favicon of sqlit

sqlit

Fast, lightweight TUI for querying SQL Server, PostgreSQL, MySQL, SQLite, DuckDB, Snowflake and 20+ other databases. Features vim keybindings, Docker discovery, SSH tunneling and connection management.

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:

  • Multi-database support with seamless switching between connections
  • Docker integration that auto-detects running database containers
  • SSH tunneling for secure remote database access
  • Vim-style editing with modal keybindings for efficient query writing
  • Query history that's searchable and connection-specific
  • Results filtering with fuzzy search across millions of rows
  • Syntax highlighting and intelligent autocomplete for SQL
  • Connection manager to save and organize database credentials securely
  • Cloud CLI integration with AWS, Azure and GCP
  • Multiple themes including Rose Pine, Tokyo Night, Nord and Gruvbox

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.

Install

Pipx
$ pipx install sqlit-tui

Features

JSON outputRemote SSH supportScriptable

Shell features

Syntax highlighting

Media

Pros

4
  • Supports over 20 different database types
  • Vim keybindings for efficient navigation
  • Automatic Docker container discovery for databases
  • Secure credential storage using OS keyring

Related tools

Categories:

Share:

Auto-fetched .

Recent releases

Similar to sqlit

Favicon

 

  
 
Favicon

 

  
 
Favicon