SQL

sqlit – lazygit of SQL databases

Connect and query your database from your terminal in seconds.

sqlit supports a wide range of databases, including PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, Oracle, DuckDB, CockroachDB, ClickHouse, Snowflake, FirebirdSQL, Turso, Supabase, Cloudflare D1, Databricks, BigQuery, Amazon Athena, Redshift, IBM Db2, SAP HANA, Trino and Presto.

This is free and open source software.

Key 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.
  • 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: 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.
  • Cloud CLI integration – discover and connect to databases using AWS, Azure and Google Cloud command-line tools.
  • External credential commands – retrieve database passwords from compatible secret managers rather than storing them directly in connection settings.

Website: github.com/Maxteabag/sqlit
Support:
Developer: Peter
License: MIT License

sqlit demo
Click animation for full size

sqlit is written in Python. Learn Python with our recommended free books and free tutorials.


Related Software

MySQL Tools
DBeaverUniversal database tool
phpMyAdminMySQL web administration tool
MySQL WorkbenchComplete visual database design tool
mycliCommand line interface for MySQL, MariaDB, and Percona
gh-ostGitHub's Online Schema Migrations for MySQL
Beekeeper Studio Cross-platform SQL editor and database manager
usqlCommand-line database client
sqlitlazygit of SQL databases
MySQLTunerAnalyse MySQL performance and suggest configuration changes
HarlequinEasy, fast, and beautiful database client for the terminal
DbGateDatabase manager for MySQL, PostgreSQL, MongoDB
Percona ToolkitEssential command-line utilities for MySQL
SQuirreL SQL ClientGraphical SQL client written in Java
AdminerFull-featured tool for managing content in MySQL database
dblabInteractive client for PostgreSQL, MySQL, SQLite3, and more
MyDumperParallel utilities for fast MySQL database backups and restores
AntaresSQL client based on Electron.js and Vue.js
XtraBackupBackup utility for MySQL
innotopReal-time, advanced investigation tool
SkeemaManage MySQL and MariaDB schema changes
vi-sqlTerminal SQL client for browsing, querying and editing databases
MySQL ShellAdvanced MySQL console for scripting and database administration
SequelerNative Linux SQL client built in Vala and Gtk

Read our verdict in the software roundup.


Best Free and Open Source Software LinuxLinks helps you discover the best free and open source software for Linux. Explore our extensive collection of recommended applications, including alternatives to popular proprietary software.

We also publish software reviews, Linux tutorials, hardware reviews, free programming books and articles covering the wider open source community. Browse our Linux resources to discover more.

Know a useful free and open source Linux application we haven't covered? Suggest a program for inclusion.

Has your software been featured on LinuxLinks? Display one of our Featured on LinuxLinks badges on your website or GitHub README.
Subscribe

Please read our Comment Policy before commenting.

Notify of
guest
0 Comments
Oldest
Newest Most Voted