sqlit is a terminal user interface for SQL databases written in Python that supports SQL Server, MySQL, PostgreSQL, SQLite, Turso, and many other database systems.
The tool addresses the friction of accessing databases during development work. Rather than launching heavy GUI applications or complex IDE extensions, sqlit provides a lightweight terminal interface that connects to a database and executes queries in seconds. It handles connection management by storing credentials securely in the OS keyring, supports SSH tunnels for remote access, and can auto-detect running database containers through Docker integration. The interface includes syntax highlighting, searchable query history with vim-style keybindings, and the ability to filter and fuzzy-search through result sets containing millions of rows.
Developers who spend time querying databases from the command line should consider this tool, particularly those working across multiple database systems or frequently switching between local and remote instances. It suits projects where quick ad-hoc queries are common and where a full-featured GUI feels like overkill. The connection manager eliminates the need to pass credentials via CLI arguments each time. The tool's support for cloud CLI integration with Azure, AWS, and GCP makes it practical for teams using managed database services. Those preferring modal editing and keyboard-driven workflows will find the vim-style keybindings and context-aware help particularly useful.
The project shows consistent development activity with regular updates addressing user feedback and expanding database support. The maintainer actively responds to issues and implements feature requests from the community. The codebase remains focused on core functionality rather than feature bloat, maintaining the tool's lightweight character. Documentation includes animated demonstrations of key workflows, suggesting attention to user onboarding and clarity.
