logo

dbcli/litecli

CLI for SQLite Databases with auto-completion and syntax highlighting

View on GitHub ↗Jump to charts ↓Open shareable report →

dbcli/litecli has 3k+ stars and 100+ forks on GitHub, is written in Python, and was last pushed on Jun 18, 2026. Data as of . Signed-in members get hourly updates — create a free account.

Summary Information

Updated 2 hours ago
Type:CLI ToolCategory(s):ORMs, Migrations & DB ClientsDatabases & Storage
Added to GitGenius on September 21st, 2026
Created on May 13th, 2018
Open Issues & Pull Requests: 46 (+0)
GitHub issues: Enabled
Number of forks: 101
Total Stargazers: 3,317 (+0)
Total Subscribers: 21 (+0)

Repository Insights (GitGenius)

Median issue/PR response: 30.0 days
Mean response time: 159.3 days
90th percentile: 788.2 days
Tracked items: 37

Most active contributors

Sign in to see contributor activity.
Sign in

Related repositories by overlapping contributors

Maintainer activity

1 person did triage or write work on this repository in the last 12 months.

Counts unlabeled, assigned, unassigned, milestoned, demilestoned, locked, unlocked over the last 12 months. These are issue and pull request events that require triage or write permission. Commits and code review are not counted. labeled and renamed are excluded because GitHub issue forms record the issue author as the actor. Figures from October 11, 2026. This count is not comparable across projects: each project's automation decides which of these events a person emits. How this is counted.

Charts & Analytics

Fetching additional details & charts...

Issue Activity (beta)

Open issues: 10
New in 7 days: 0
Closed in 7 days: 0
Avg open age: 369 days
Stale 30+ days: 10
Stale 90+ days: 10

Recent activity

Opened in 7 days: 0
Closed in 7 days: 0
Comments in 7 days: 0
Events in 7 days: 0

Top labels

  • symphony:review (4)
  • good first issue (1)
  • symphony:todo (1)

Most active issues this week

Sign in to see which issues are moving.
Sign in
Explore full issue details

Detailed Description

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

SQLite databases are typically accessed through basic command-line tools that lack modern developer conveniences. litecli solves this by wrapping SQLite database interactions with intelligent auto-completion of table names, column names, and SQL keywords, alongside syntax highlighting for query readability. The tool uses prompt-toolkit to deliver these features in an interactive terminal interface.

Anyone working regularly with SQLite databases should consider litecli if they value faster query writing and fewer typos. It suits developers who spend time in the terminal and want a more polished experience than the default sqlite3 command-line tool. The project is straightforward to install via standard Python package managers or Homebrew on macOS. Configuration happens through a simple config file created automatically on first launch, with platform-specific locations for Linux, macOS, and Windows.

The project maintains steady activity with regular commits addressing bug fixes and feature improvements. Pull requests receive timely review and integration. Issues are actively triaged and responded to by maintainers. The codebase shows consistent refinement rather than periods of abandonment, indicating ongoing commitment to the tool's stability and usability.