pgcli
Focus: postgres. Shares sql and terminal with litecli. Rated 4.6 (litecli: 4.5).
Desktop AppFreemacOS, Linux
4.6Visit
Desktop App
litecli
A friendlier command line for SQLite databases.
Rating
4.5 / 5
Pricing
Free
Difficulty
Intermediate
Works on
macOS, Windows, Linux
Built with love by Shushant Lakhyani. Building bestproductivityresources.com
What is litecli?
litecli is a command-line client for SQLite databases with auto-completion and syntax highlighting. Its README says you can install it with pip or Homebrew and describes a config file created on first launch for Windows, macOS and Linux.
Third-party open-source projects. We are not affiliated with their authors; repositories are provided as-is by their maintainers. Review each project's license, code and security before installing. See our Disclaimer.
Pros: what litecli does well
- Auto-complete saves typing and mistakes
- Highlighted queries are easier to read
- Runs on Windows, macOS and Linux
Cons: where it falls short
- Terminal only, no window
- Works with SQLite only
Who litecli is for
Anyone who pokes around SQLite files and wants a smoother terminal.
Who can skip it
People who prefer a visual database browser.
litecli alternatives
Not sold on litecli? These do a similar job, and each card says what it has in common.
hyperfine
Focus: benchmark, speed test and performance. Shares command line and open source with litecli. Rated 4.6 (litecli: 4.5).
Desktop AppFreemacOS, Windows
4.6Visit
Miller
Focus: csv, json and data wrangling. Shares command line and open source with litecli. Rated 4.6 (litecli: 4.5).
Desktop AppFreemacOS, Linux
4.6Visit
Harlequin
Focus: sql editor, database and tui. Shares terminal and open source with litecli. Same 4.5 rating.
Desktop AppFreemacOS, Windows
4.5Visit
qsv
Focus: csv, data cleaning and data analysis. Shares command line and open source with litecli. Same 4.5 rating.
Desktop AppFreemacOS, Windows
4.5Visit
Atuin
Focus: shell history and sync. Shares terminal and command line with litecli. Rated 4.7 (litecli: 4.5).
Desktop AppFreemacOS, Linux
4.7Visit
Free alternatives to litecli
Want to spend nothing? These free picks cover similar ground.
htop
Focus: process viewer and system monitor. Shares terminal and command line with litecli. Rated 4.7 (litecli: 4.5).
Desktop AppFreemacOS, Linux
4.7Visit
zoxide
Focus: navigation and shell. Shares terminal and command line with litecli. Rated 4.7 (litecli: 4.5).
Desktop AppFreemacOS, Linux
4.7Visit
Alacritty
Focus: gpu and minimal. Shares terminal and command line with litecli. Rated 4.6 (litecli: 4.5).
Desktop AppFreemacOS, Windows
4.6Visit
fish shell
Focus: shell and autocomplete. Shares terminal and command line with litecli. Rated 4.6 (litecli: 4.5).
Desktop AppFreemacOS, Linux
4.6Visit
kitty
Focus: gpu. Shares terminal and command line with litecli. Rated 4.6 (litecli: 4.5).
Desktop AppFreemacOS, Linux
4.6Visit
Tabby
Focus: ssh and serial. Shares terminal and command line with litecli. Rated 4.6 (litecli: 4.5).
Desktop AppFreemacOS, Windows
4.6Visit
Are you the maker of litecli?Get a free Featured badge for your site, a share image and ready-to-paste posts. No sign-up.
Free Notion database
1,100+ ways people are making money online
Real online businesses, creators and projects, broken down by how they make money: apps, online stores, AI tools and more. Free on Gumroad.
Get the free databaseFree Notion database
399+ ways to make money online
Hundreds of online income methods in one place, so you can compare options and pick one to try. Free on Gumroad.
Get the free listFor research and ideas only. Results vary and nothing here is a promise of income. See our Disclaimer.
Weekly newsletter
Everything new, every Monday.
One short email every Monday with everything shipped that week: new free tools and websites, new guides, new free browser tools and what's new in my free Gumroad libraries, plus how the site is growing. Free, and you can unsubscribe anytime.
Join the newsletterYou sign up on Gumroad, which stores your email to send the newsletter. See our Privacy Policy.