Show HN: AI Enabled SQLite CLI

1 points by theahura a day ago

I've been working with sqlite recently, and was pretty surprised at how bad a lot of the existing cli tools are. Most don't have tab complete or json pretty printing. Many don't automatically show table headers, which is imo very user unfriendly. And for me, personally, I kept finding myself tabbing over to Claude to ask it how to do basic joins and json extractions because I never bothered to learn/memorize SQL syntax, and didn't need anything performant for just looking through the databases.

I got to thinking it would be very easy to build a better client with AI, that also used AI. And it was -- in less than an hour I put together a cli that supports all of the above.

Most importantly, it has a built in LLM plug-in that has context for your database. You can do things like run `.ai give me the names of my customers` and the cli will make a call to Claude with your table names and table schemas as part of the context.

I've immediately found it useful in my day to day work, so I figured I'd share it here too for others to play with lmk if there's any other features you think are worth adding!