litecli - command-line client for SQLite databases

litecli is a command-line client for SQLite databases that has auto-completion and syntax highlighting.

This is free and open source software.

Features include:

AutoCompletion – auto-completion is on by default. The REPL will pop up a suggestion menu as soon as you start typing. The suggestions are context sensitive based on the position of the cursor.
Color themes.
Ships with sane defaults.
Favorite Queries are a way to save frequently used queries with a short name.
There are two types of keybindings available. Emacs mode and Vi mode. This determines the various shortcuts that are available in the REPL.
Tabular output – the output of an SQL query is displayed as a table.

Website: github.com/dbcli/litecli
Support:
Developer: dbcli
License: BSD 3-Clause “New” or “Revised” License

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

Explore Linux
	Best Free and Open Source Software - A huge collection of recommended free and open source software covering every major category.
	In-depth Linux Software Reviews - Detailed assessments of Linux software covering features, usability and overall quality.
	The Big List of Active Linux Distros - An extensive collection of actively developed Linux distributions.
	Open Source Alternatives - Alternatives to software and services from Google, Microsoft, Apple, Adobe, IBM, Autodesk, Oracle and others.
	Essential Linux System Tools - Indispensable utilities for monitoring, maintaining and managing Linux systems.
	Linux Productivity Tools - Useful utilities for improving productivity and streamlining everyday tasks.
	Alternatives to Popular CLI Tools - Modern alternatives to familiar command-line utilities supplied with Linux systems.
	Awesome Free Linux Game Tools - Tools, utilities and companion software that improve gaming on Linux.
	Machine Learning on Linux - Machine learning and deep learning software, self-hosted applications and practical tools.
	Saving Money with Linux - Practical ways to reduce electricity consumption and lower computing costs with Linux.
	Linux Candy - Fun, entertaining and sometimes delightfully quirky software from the lighter side of Linux.