Connect and query your database from your terminal in seconds.
sqlit supports all major databases: SQL Server, PostgreSQL, MySQL, SQLite, MariaDB, FirebirdSQL, Oracle, DuckDB, CockroachDB, ClickHouse, Snowflake, Supabase, CloudFlare D1, and Turso.
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.
Website: github.com/Maxteabag/sqlit
Support:
Developer: Peter
License: MIT License
sqlit is written in Python. Learn Python with our recommended free books and free tutorials.
Related Software
| MySQL Tools | |
|---|---|
| DBeaver | Universal database tool |
| phpMyAdmin | MySQL web administration tool |
| NocoDB | Build databases as spreadsheets |
| MySQL Workbench | Complete visual database design tool |
| mycli | Command line interface for MySQL, MariaDB, and Percona |
| gh-ost | GitHub's Online Schema Migrations for MySQL |
| Beekeeper Studio | Cross-platform SQL editor and database manager |
| usql | Command-line database client |
| sqlit | lazygit of SQL databases |
| Harlequin | Easy, fast, and beautiful database client for the terminal |
| DbGate | Database manager for MySQL, PostgreSQL, MongoDB |
| Percona Toolkit | Essential command-line utilities for MySQL |
| SQuirreL SQL Client | Graphical SQL client written in Java |
| Adminer | Full-featured tool for managing content in MySQL database |
| dblab | Interactive client for PostgreSQL, MySQL, SQLite3, and more |
| Antares | SQL client based on Electron.js and Vue.js |
| XtraBackup | Backup utility for MySQL |
| innotop | Real-time, advanced investigation tool |
| SQLCheck | Detects common SQL anti-patterns |
| Skeema | Manage MySQL and MariaDB schema changes |
| Sequeler | Native Linux SQL client built in Vala and Gtk |
| orchestrator | High availability and replication management tool |
| OmniDB | Collaborative environment For database management |
Read our verdict in the software roundup.
 Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk. You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more. Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form. |