https://github.com/dbcli/litecli

Skip to content

Navigation Menu

Toggle navigation
 
Sign in

  * Product
      +  
        Actions
        Automate any workflow
      +  
        Packages
        Host and manage packages
      +  
        Security
        Find and fix vulnerabilities
      +  
        Codespaces
        Instant dev environments
      +  
        GitHub Copilot
        Write better code with AI
      +  
        Code review
        Manage code changes
      +  
        Issues
        Plan and track work
      +  
        Discussions
        Collaborate outside of code
    Explore
      + All features
      + Documentation
      + GitHub Skills
      + Blog
  * Solutions
    By size
      + Enterprise
      + Teams
      + Startups
    By industry
      + Healthcare
      + Financial services
      + Manufacturing
    By use case
      + CI/CD & Automation
      + DevOps
      + DevSecOps
  * Resources
    Topics
      + AI
      + DevOps
      + Security
      + Software Development
      + View all
    Explore
      + Learning Pathways
      + White papers, Ebooks, Webinars
      + Customer Stories
      + Partners
  * Open Source
      +  
        GitHub Sponsors
        Fund open source developers
      +  
        The ReadME Project
        GitHub community articles
    Repositories
      + Topics
      + Trending
      + Collections
  * Enterprise
      +  
        Enterprise platform
        AI-powered developer platform
    Available add-ons
      +  
        Advanced Security
        Enterprise-grade security features
      +  
        GitHub Copilot
        Enterprise-grade AI features
      +  
        Premium Support
        Enterprise-grade 24/7 support
  * Pricing

Search or jump to...

Search code, repositories, users, issues, pull requests...

Search
[                    ]
Clear

Search syntax tips

Provide feedback

We read every piece of feedback, and take your input very seriously.

[                    ] [ ] Include my email address so I can be
contacted
Cancel Submit feedback

Saved searches

Use saved searches to filter your results more quickly

Name [                    ] 
Query [                    ]

To see all available qualifiers, see our documentation.

Cancel Create saved search
Sign in
Sign up Reseting focus
You signed in with another tab or window. Reload to refresh your
session. You signed out in another tab or window. Reload to refresh
your session. You switched accounts on another tab or window. Reload
to refresh your session. Dismiss alert
{{ message }}
dbcli / litecli Public

  * Notifications You must be signed in to change notification
    settings
  * Fork 68
  * Star 2.1k

CLI for SQLite Databases with auto-completion and syntax highlighting

litecli.com

License

BSD-3-Clause license
2.1k stars 68 forks Branches Tags Activity
Star
Notifications You must be signed in to change notification settings

  * Code
  * Issues 34
  * Pull requests 0
  * Discussions
  * Actions
  * Projects 0
  * Security
  * Insights

Additional navigation options

  * Code
  * Issues
  * Pull requests
  * Discussions
  * Actions
  * Projects
  * Security
  * Insights

dbcli/litecli

This commit does not belong to any branch on this repository, and may
belong to a fork outside of the repository.
 main
BranchesTags
  
Go to file
Code

Folders and files

                                                Last commit   Last
         Name                    Name             message    commit
                                                              date
Latest commit

 

History

361 Commits
 
.github                 .github                              
litecli                 litecli                              
screenshots             screenshots                          
tests                   tests                                
.git-blame-ignore-revs  .git-blame-ignore-revs               
.gitignore              .gitignore                           
.pre-commit-config.yaml .pre-commit-config.yaml              
CHANGELOG.md            CHANGELOG.md                         
CONTRIBUTING.md         CONTRIBUTING.md                      
LICENSE                 LICENSE                              
MANIFEST.in             MANIFEST.in                          
README.md               README.md                            
TODO.md                 TODO.md                              
pyproject.toml          pyproject.toml                       
release.py              release.py                           
tox.ini                 tox.ini                              
View all files

Repository files navigation

  * README
  * BSD-3-Clause license

litecli

 

Build Status

Docs

A command-line client for SQLite databases that has auto-completion
and syntax highlighting.

Completion CompletionGif

Installation

 

If you already know how to install python packages, then you can
install it via pip:

You might need sudo on linux.

$ pip install -U litecli

The package is also available on Arch Linux through AUR in two
versions: litecli is based the latest release (git tag) and
litecli-git is based on the master branch of the git repo. You can
install them manually or with an AUR helper such as yay:

$ yay -S litecli

or

$ yay -S litecli-git

For MacOS users, you can also use Homebrew to install it:

$ brew install litecli

Usage

 

$ litecli --help

Usage: litecli [OPTIONS] [DATABASE]

Examples:
  - litecli sqlite_db_name

A config file is automatically created at ~/.config/litecli/config at
first launch. For Windows machines a config file is created at ~\
AppData\Local\dbcli\litecli\config at first launch. See the file
itself for a description of all available options.

Docs

 

Visit: litecli.com/features

About

CLI for SQLite Databases with auto-completion and syntax highlighting

litecli.com

Topics

python syntax-highlighting linux sqlite prompt-toolkit

Resources

Readme

License

BSD-3-Clause license
Activity
Custom properties

Stars

2.1k stars

Watchers

25 watching

Forks

68 forks
Report repository

Releases 2

 
v1.12.2 Latest
Sep 8, 2024
+ 1 release

Packages 0

No packages published

Contributors 27

  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 
  * 

+ 13 contributors

Languages

  * Python 100.0%

Footer

 (c) 2024 GitHub, Inc.

Footer navigation

  * Terms
  * Privacy
  * Security
  * Status
  * Docs
  * Contact
  * Manage cookies
  * Do not share my personal information

You can't perform that action at this time.