# litecli

> Command-line client for SQLite databases with auto-completion and syntax highlighting.

Stars: 3.3k · Language: Python · License: BSD-3-Clause · Categories: Data

- Repository: https://github.com/dbcli/litecli
- Website: https://litecli.com
- Page: https://www.trmn.sh/tools/litecli

## Install

- Homebrew: `brew install litecli`
- pip: `pip install -U litecli[sqlean]`

## Overview

litecli is an interactive command-line client for SQLite databases. You start it with a database name (`litecli sqlite_db_name`) and get a SQL prompt with auto-completion and syntax highlighting as you type queries.

It is a Python package, installed with pip (the `litecli[sqlean]` extra is shown in the install command) or Homebrew. On first launch it creates a config file at `~/.config/litecli/config` on Linux and macOS, or `~\AppData\Local\dbcli\litecli\config` on Windows. The config file documents the available options.

It suits developers and anyone who inspects or queries SQLite files from a terminal and wants something more convenient than the stock `sqlite3` shell. Further feature documentation is on litecli.com/features.

### Installation

```bash
# via Homebrew
brew install litecli
```

```bash
# via pip
pip install -U litecli[sqlean]
```

![litecli auto-completion demo](https://media.trmn.sh/cached/025b45e87774229e69bdda83f88d9cb98dc5dffb3b56b17ea0c6c906319944c2.gif)

![litecli completion screenshot](https://media.trmn.sh/cached/c25fefe9e876bce7e6166c240b3563ae22b93ee2a7b76823e10865845daab9b4.png)

## Alternatives

- [dolphie](https://www.trmn.sh/tools/dolphie.md): Real-time terminal interface for monitoring MySQL/MariaDB and ProxySQL database performance and analytics (Python, 1.2k stars)
- [jc](https://www.trmn.sh/tools/jc.md): Converts output of CLI tools, file types, and strings to JSON or Python dictionaries so it can be piped to jq and used in scripts. (Python, 8.7k stars)
- [visidata](https://www.trmn.sh/tools/visidata.md): Terminal interface for exploring and arranging tabular data with support for CSV, JSON, SQLite, Excel, and many other formats. (Python, 9.4k stars)
- [mycli](https://www.trmn.sh/tools/mycli.md): MySQL command line client with auto-completion, syntax highlighting, and smart context-aware SQL suggestions (Python, 12.0k stars)
- [pgcli](https://www.trmn.sh/tools/pgcli.md): Interactive PostgreSQL client with auto-completion, syntax highlighting, and smart context-sensitive suggestions. (Python, 13.4k stars)

---

Canonical: https://www.trmn.sh/tools/litecli