Open CLI

litecli

database
$ pipx install litecli
Summary

SQLite shell, autocomplete, and readable tables from the terminal.

  • litecli fits data & db well, especially for sqlite shell, autocomplete, and readable tables from the terminal.
  • 109 homebrew installs (30d).
  • Verify with `litecli --version` first.
  • Best treated as a human-first terminal tool.
  • Output is mostly text-first, so verify results before scripting around it.
database-litecli-SKILL.md

Litecli guide

SQLite shell, autocomplete, and readable tables from the terminal. Built by dbcli.

Open CLI packages the install path, verify step, and safe-start workflow so this tool can move from “interesting CLI” to something you can actually use. It also integrates with skills.sh so each CLI comes with the right companion skills, not just a binary and a docs link.

When to apply

  • sqlite shell, autocomplete, and readable tables from the terminal.
  • You work with databases and want a fast terminal interface.
  • You need sqlite shell.
  • You need autocomplete.
  • You need readable tables.

Quick reference

Installpipx install litecli
Verifylitecli --version
First real commandlitecli demo.db

Open CLI × skills.sh

Open CLI integrates litecli with the right skills.sh companions so you get the tool and the workflow together.

Database Schema Design

Recommended pairing

Open CLI recommends this skills.sh skill because it fits database workflows. Use better schema and migration decisions when a CLI touches databases.

View on skills.sh
$ npx skills add https://github.com/supercent-io/skills-template --skill database-schema-design
Starter prompt

Use litecli together with the Database Schema Design skills.sh skill. Inspect the current schema or data first, summarize what matters, and ask before any migration or write action.

Also useful from skills.sh
Data Analysisskills.shBackend Testingskills.sh

Why this tool

  • litecli fits data & db well, especially for sqlite shell, autocomplete, and readable tables from the terminal.
  • 109 homebrew installs (30d).
  • Verify with `litecli --version` first.

Watch-outs

  • Automation can be brittle.
  • Output is mostly plain text.
  • Better for local use than CI.

Example workflow

1. litecli demo.db

Safe start

Step 1

Install litecli.

Step 2

Run `litecli --version` first.

Step 3

Start with `litecli demo.db`.

Step 4

Install a CLI that matches your database engine.

Alternatives worth considering

prisma

Schema design, migrations, and type-safe db workflows from the terminal.

drizzle-kit

Migrations, schema diffs, and typescript db tooling from the terminal.

usql

Universal SQL shell, multiple databases, and db scripts from the terminal.