sqlit

The lazygit of SQL databases. Connect and query your database from your terminal in seconds.

• Connect: Supports all major databases: SQL Server, PostgreSQL, MySQL, SQLite, MariaDB, FirebirdSQL, Oracle, DuckDB, CockroachDB, ClickHouse, Snowflake, Supabase, CloudFlare D1, Turso, Athena, BigQuery and Redshift.
• Query: Syntax highlighting. History. Vim-style keybindings.
• Results: Load millions of rows. Inspect data, filter by content, fuzzy search.
• Docker Discovery: Automatically finds running database containers. Press 'Enter' to connect, sqlit figures out the details for you.

Features:

• Connection manager: Save and switch connections without CLI args
• Just run sqlit: No CLI config needed, pick a connection and go
• Multi-database support: PostgreSQL, MySQL, SQLite, SQL Server, and 10+ more
• Docker integration: Auto-detect running database containers - Cloud CLI integration: Easily browse and connect to your external databases through Azure, AWS and GCP CLI's
• SSH tunnels: Connect to remote databases securely with password or key auth
• Secure credentials: Passwords stored in your OS keyring
• Vim-style editing: Modal editing for terminal purists
• Query history: Searchable, per-connection history
• Filter results: Fuzzy search through millions of rows
• Context-aware help: Keybindings shown on screen
• Browse databases: Tables, views, procedures, indexes, triggers, sequences
• Autocomplete: Sophisticated SQL completion engine for tables, columns, and procedures
• CLI mode: Execute SQL from the command line
• Themes: Rose Pine, Tokyo Night, Nord, Gruvbox
• Dependency wizard: Auto-install missing drivers