dbcli/litecli

View on GitHub

CLI for SQLite Databases with auto-completion and syntax highlighting

Stars: 3.3k
Forks: 95
Open beginner issues: 0
Indexed issues: 38

Dominant language: Python
License: BSD-3-Clause
Last GitHub push: Jun 7, 2026
Latest indexed: Sep 15, 2026
Contributing guide: Contributing guide
Code of conduct: No code of conduct
Beginner labels: good first issue
PR merge metrics: No merged PRs in 30d

Open All

38 issues indexed so far

SQLcipher support Open

dbcli/litecli#42 · 2 comments · 2 reactions · 0 assignees · Indexed Sep 15, 2026
history_file directive ignored in ini Open

dbcli/litecli#62 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
[Documentation] Clarification of the completion key(s)? Open

good first issue

dbcli/litecli#73 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 15, 2026
hot reload Open

dbcli/litecli#76 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
No output on launch Open

intermediate

dbcli/litecli#78 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Does not work with CSV vtable. Open

intermediate

dbcli/litecli#90 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Ctrl+y in vi mode not working Open

dbcli/litecli#93 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Unecessary usage of pager Open

dbcli/litecli#94 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Dark version of default theme always trigger the pager Open

dbcli/litecli#95 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Enable completion suggestion after SELECT based on the tables Open

dbcli/litecli#98 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
calling a favorite from within a favorite Open

dbcli/litecli#101 · 4 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
litecli is fantastic :) Open

dbcli/litecli#112 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Feature request: sqlite3 .output compatibility Open

dbcli/litecli#115 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
".separator" command missing Open

dbcli/litecli#123 · 0 comments · 2 reactions · 0 assignees · Indexed Sep 15, 2026
spatialite support Open

dbcli/litecli#127 · 3 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
How do I auto-comple Foreign Key? Open

dbcli/litecli#133 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Add support for the `--wrap` and `--wordwrap` options from sqlite3 Open

dbcli/litecli#136 · 0 comments · 5 reactions · 0 assignees · Indexed Sep 15, 2026
No such function: REGEXP Open

dbcli/litecli#139 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Support `.eqp` like in sqlite3 Open

dbcli/litecli#144 · 3 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
feature request: sqlite3.38+ support for json to use its new features Open

dbcli/litecli#152 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
When long wide characters are stored in the database, it will not output some rows if enabled auto_vertical_output Open

dbcli/litecli#156 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
FR: configuration to import custom python functions Open

dbcli/litecli#158 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
FR: support environment variables in (favourite) queries Open

dbcli/litecli#163 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
default prompt broken with very long filename? Open

dbcli/litecli#174 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
`--indent` with `.schema` doesnt work Open

dbcli/litecli#179 · 0 comments · 1 reaction · 0 assignees · Indexed Sep 15, 2026
litecli cutting off long strings Open

dbcli/litecli#189 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
installation on arch linux fails Open

dbcli/litecli#197 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
FR: Support from parameter command and name parameters Open

dbcli/litecli#230 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Feature Request: Customize vi mode keybinds. Open

symphony:review

dbcli/litecli#231 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
FR: Allow opening database readonly Open

symphony:review

dbcli/litecli#236 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Exporting as a dot file (How to ?) Open

dbcli/litecli#238 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Pager options not honored with click>=8.1.8 Open

symphony:review

dbcli/litecli#240 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Automatically decode hex for BLOB fields. Open

dbcli/litecli#244 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 15, 2026
can't run any llm command for my local db. error: Preparing schema information to feed the llm near "1": syntax error Open

dbcli/litecli#253 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Add --json output flag for batch query results Open

dbcli/litecli#263 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
False error when loading an extension module with .load Open

dbcli/litecli#264 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Using extension function in a VIEW causes exception to be printed Open

dbcli/litecli#265 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026
Misleading status message in Multiline mode Open

dbcli/litecli#266 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 15, 2026

dbcli/litecli

Get new issues in your inbox