Amjith's Avatar

Amjith

@amjith.bsky.social

Creator of dbcli.com. Love CLI tools. Pythonista. இந்தியன்.

102 Followers  |  185 Following  |  23 Posts  |  Joined: 21.10.2024  |  1.7068

Latest posts by amjith.bsky.social on Bluesky

Launched back in December as part of the 12 days of shipmas.

27.07.2025 00:36 — 👍 0    🔁 0    💬 1    📌 0
Post image

Just discovered litecli (https://github.com/dbcli/litecli), it feels like a big improvement over the default SQLite REPL (autocompletion! support for multiline queries! syntax highlighting!)

07.11.2024 14:39 — 👍 2    🔁 4    💬 0    📌 0
New Project Lead for mycli

New project lead for mycli. Roland Walker is taking the reins of leading mycli.

www.mycli.net/new-project-...

24.04.2025 03:18 — 👍 0    🔁 0    💬 0    📌 0

“My account remains and I may return when the Nazis leave”

Absolute banger of a response 👏

04.03.2025 16:29 — 👍 75    🔁 5    💬 0    📌 0

Awesome! Could you please schedule my slot after 2:30pm? I have to pick up my kid from school. I'll be back around 2:25pm and able to join the office hours at 2:30.

31.01.2025 00:56 — 👍 1    🔁 0    💬 1    📌 0

@simonwillison.net and @alexgarcia.xyz I'd love to do a lightning talk to show how llm tool is used in LiteCLI to help with writing SQL queries. I filled out the google form to enroll in the office hours. I haven't heard back from you folks.

31.01.2025 00:01 — 👍 2    🔁 0    💬 1    📌 0
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 ...

The LLM feature in LiteCLI can plug in any model (including local models). Details: amjith.com/blog/2025/ll...

29.01.2025 16:02 — 👍 1    🔁 0    💬 0    📌 0
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', documen...

Latest litecli release with a new LLM feature. Ask questions about your DB and get a SQL query from an LLM to answer.

amjith.com/blog/2025/ll...

29.01.2025 15:59 — 👍 1    🔁 0    💬 1    📌 0
Preview
Show the default model when listing all available models. by amjith · Pull Request #688 · simonw/llm Show the current default model in the list of models in the list printed by llm models.

@simonwillison.net Any chance I could get you to merge this very small PR to your llm tool?

github.com/simonw/llm/p...

Tests are passing and I'm happy to address any feedback you have.

05.01.2025 19:21 — 👍 0    🔁 0    💬 0    📌 0
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 mod...

Figured out how to autocomplete subcommands in a click based CLI.

amjith.com/blog/2025/au...

This is an intermediate step to embedding @simonwillison.net's llm tool in litecli to use LLMs to write SQL queries.

05.01.2025 03:09 — 👍 2    🔁 0    💬 0    📌 0
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 cli...

TIL: How to restart a Python CLI from within the CLI.

amjith.com/blog/2025/re...

05.01.2025 00:05 — 👍 1    🔁 0    💬 0    📌 0

@simonwillison.net How are you able to cross post your messages between twitter, bluesky and mastadon?

05.01.2025 00:01 — 👍 1    🔁 0    💬 1    📌 0
Preview
Show the default model when listing all available models. by amjith · Pull Request #688 · simonw/llm Show the current default model in the list of models in the list printed by llm models.

Fixed the CI failure. The PR is now ready for review.
github.com/simonw/llm/p...

30.12.2024 02:42 — 👍 0    🔁 0    💬 0    📌 0
Preview
Show the default model when listing all available models. · simonw/llm@cf8e3e3 Access large language models from the command-line - Show the default model when listing all available models. · simonw/llm@cf8e3e3

Excellent! The PR I opened does just that. I'm trying to figure out how to fix that one pesky CI failure. I can't seem to figure out why it is failing. github.com/simonw/llm/a...

29.12.2024 19:40 — 👍 0    🔁 0    💬 1    📌 0
Preview
Show the default model when listing all available models. by amjith · Pull Request #687 · simonw/llm Show the current default model in the list of models in the list printed by llm models

I realize there is `llm models default` which tells you (and lets you change) the current default. But I thought listing the default model in the top level sub-command would be a nice UX improvement. github.com/simonw/llm/p...

29.12.2024 19:22 — 👍 2    🔁 0    💬 1    📌 0

@simonwillison.net Thoughts about listing the default model when invoking `llm models`?

Kinda like:
```
$ llm models
Default: gpt-4o
OpenAI Chat: gpt-4o (aliases: 4o)
OpenAI Chat: gpt-4o-mini (aliases: 4o-mini)
```

29.12.2024 19:19 — 👍 1    🔁 0    💬 1    📌 0

What does it mean when you say the affinity is greater? How does that affect performance?

28.12.2024 14:56 — 👍 0    🔁 0    💬 1    📌 0

I’ve seen you type code during your talks. For the rest of us mere mortals who type slightly less than the speed of light it is quite useful. 😆

24.12.2024 23:43 — 👍 1    🔁 0    💬 1    📌 0
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 ...

Introducing LLMs to LiteCLI.

amjith.com/blog/2024/in...

Ask questions to your database and get back a SQL query to answer that question.

16.12.2024 08:58 — 👍 1    🔁 0    💬 0    📌 0
Goodbye Netflix “People are exhausting. But you’re not people.” A direct quote from my teammate during a dinner at a conference. We became very good friends after that trip. Back in 2017 I joined Netflix and moved ou...

Goodbye, Netflix.

amjith.com/blog/2024/go...

15.12.2024 17:37 — 👍 0    🔁 0    💬 1    📌 0

American fascism. Bend the knee.

Makes you just want to vomit.

15.12.2024 02:49 — 👍 45    🔁 4    💬 1    📌 0
Post image

Experimenting with adding LLM support to litecli. Heavily inspired by
@simonwillison.net's sqlite-utils-ask plugin.

14.12.2024 06:29 — 👍 0    🔁 0    💬 0    📌 0

This quote from @antirez 's blog post is absolute chef kiss.


"great use of AI is not making machines do what you can do better."




https://antirez.com/news/144

11.12.2024 01:37 — 👍 1    🔁 0    💬 0    📌 0
Ghostty Terminal I got beta access to Ghostty and set it up on my MacOS (Sonoma) laptop. The terminal is nice out of the box. It has tab support and splits. The default color theme is pleasing. I still needed to adjus...

My initial thoughts and config with screenshots.
amjith.com/blog/2024/gh...

29.11.2024 01:55 — 👍 2    🔁 0    💬 0    📌 0
Post image

I got early access to ghostty terminal. I verified my CLI tools dbcli.com works in them. It looks slick.

29.11.2024 01:54 — 👍 2    🔁 0    💬 1    📌 0
Preview
DBCLI Commandline Clients for Databases.

I make CLI tools using Python. Check them out on www.dbcli.com

All free and OpenSource (BSD licensed).

16.11.2024 22:51 — 👍 0    🔁 0    💬 0    📌 0

@amjith is following 20 prominent accounts