I’m Amjith 👋

LLM in Litecli - 2

Part 1 LiteCLI has an optional feature to use LLM powered SQL generation to get answers from your database. The default LLM used by LiteCLI is OpenAI’s gpt-4o-mini. This can be changed to a different model including a local LLM running on Ollama. Here are the steps to show how to switch your LLM model. Run \llm to enable the feature. sqlite> \llm This will offer to enable this feature by installing the necessary libraries....

LLM in Litecli

** This feature is ONLY enabled when it is used for the first time. ** LiteCLI v1.14.2 now has an LLM feature to help you write SQL. AsciinemaPlayer.create('/llm-in-litecli-1/litecli1.cast', document.getElementById('demo1'), { idleTimeLimit: 2, poster: 'npt:0:07', terminalFontSize: "15px", fit: false, }); Getting Started: Upgrade litecli to the latest version (at least v1.14.2 or higher). uv tool install litecli@latest Open a SQLite database with litecli. $ litecli your_database_file.db Run the special command \llm in the LiteCLI prompt....

Auto-Completing Click Commands

Click is a python library for creating command line applications in Python. The llm tool created by Simon uses click and it has a lot of subcommands. eg: $ llm keys set openai Enter key: ... $ llm models default gpt-4o I am building a wrapper around this CLI tool that let’s me use it in an interactive REPL. I wanted autocompletion to help me remind the available subcommands and their appropriate nested subcommands....

Restart a Python CLI

A simple snippet to restart a Python CLI from within the CLI. import os import sys import click @click.command() def cli(): click.echo("CLI is running.") # Logic that determines when to restart if click.confirm("Do you want to restart the CLI?"): click.echo("Restarting CLI...") executable = sys.executable args = sys.argv os.execv(executable, [executable] + args) else: click.echo("Exiting CLI.") if __name__ == '__main__': cli() os.execv is the system call that can replace the current process with a new one....

Introducing LLMs to Litecli

LiteCLI is a command-line client for SQLite databases that has auto-completion and syntax highlighting. I’ve added the ability to use an LLM to create a SQL query. Disclaimer: This is an EXPERIMENTAL feature. Not yet released. Ask a question about your database in English and get a SQL query back to find out the answer. This is the SQLite db used by Chrome. AsciinemaPlayer.create('/introducing-llm-to-litecli/litecli1.cast', document.getElementById('demo1'), { idleTimeLimit: 2, poster: 'npt:0:07', terminalFontSize: "...