New plugin for sqlite-utils that lets you ask questions of a SQLite database (or a even against one or more CSV/TSV/JSON files) in human language and have an LLM write a SQL query for you to get the answer. simonwillison.net/2024/Nov/25/...
Ask questions of SQLite databases and CSV/JSON files in your terminal
I built a new plugin for my sqlite-utils CLI tool that lets you ask human-language questions directly of SQLite databases and CSV/JSON files on your computer. It’s called sqlite-utils-ask. Here’s …
simonwillison.net
November 25, 2024 at 1:34 AM
New plugin for sqlite-utils that lets you ask questions of a SQLite database (or a even against one or more CSV/TSV/JSON files) in human language and have an LLM write a SQL query for you to get the answer. simonwillison.net/2024/Nov/25/...
uv is in there too: chatgpt.com/share/6977c1...
January 26, 2026 at 7:34 PM
uv is in there too: chatgpt.com/share/6977c1...
I just released the first release candidate for sqlite-utils v4, adding a migrations system (previously released independently as sqlite-migrate) and support for nested transactions: simonwillison.net/2026/Jun/21/...
sqlite-utils 4.0rc1 adds migrations and nested transactions
sqlite-utils is my combined Python library and CLI tool for working with SQLite databases. It provides an extensive set of higher-level operations on top of Python’s default sqlite3 package, including...
simonwillison.net
June 21, 2026 at 11:36 PM
I just released the first release candidate for sqlite-utils v4, adding a migrations system (previously released independently as sqlite-migrate) and support for nested transactions: simonwillison.net/2026/Jun/21/...
Somewhat humbling to have Claude Fable do a final review of some software that you're about to release and have it then find (and fix) FIVE release blockers, for an estimated (unsubsidized) cost of $149.25 simonwillison.net/2026/Jul/5/s...
sqlite-utils 4.0rc2, mostly written by Claude Fable
I wrote about the sqlite-utils 4.0rc1 release a couple of weeks ago. Since we only have Claude Fable on our Max subscriptions for a few more days, I decided to …
simonwillison.net
July 5, 2026 at 1:06 AM
Somewhat humbling to have Claude Fable do a final review of some software that you're about to release and have it then find (and fix) FIVE release blockers, for an estimated (unsubsidized) cost of $149.25 simonwillison.net/2026/Jul/5/s...
I released sqlite-utils 4.0, the 124th release but the first major version bump since 3.0 back in 2020
I managed to keep things backwards-compatible all the way up to version 3.39 before the accumulated design mistakes forced me to bump that number! simonwillison.net/2026/Jul/7/s...
I managed to keep things backwards-compatible all the way up to version 3.39 before the accumulated design mistakes forced me to bump that number! simonwillison.net/2026/Jul/7/s...
sqlite-utils 4.0, now with database schema migrations
This morning I released sqlite-utils 4.0, the 124th release of that project and the first major version bump since 3.0 in November 2020. In addition to some small but significant …
simonwillison.net
July 7, 2026 at 7:38 PM
I released sqlite-utils 4.0, the 124th release but the first major version bump since 3.0 back in 2020
I managed to keep things backwards-compatible all the way up to version 3.39 before the accumulated design mistakes forced me to bump that number! simonwillison.net/2026/Jul/7/s...
I managed to keep things backwards-compatible all the way up to version 3.39 before the accumulated design mistakes forced me to bump that number! simonwillison.net/2026/Jul/7/s...
Managed to get a ChatGPT Canvas to use my sqlite-utils.datasette.io library by installing it using micropip (after first using micropip to enable SQLite itself)
December 11, 2024 at 2:29 AM
Managed to get a ChatGPT Canvas to use my sqlite-utils.datasette.io library by installing it using micropip (after first using micropip to enable SQLite itself)
Annotated release notes for the new sqlite-utils alpha, which includes several minor backwards incompatible changes that will be released in the stable 4.0 version once the new alpha has baked for a while simonwillison.net/2025/Nov/24/...
sqlite-utils 4.0a1 has several (minor) backwards incompatible changes
I released a new alpha version of sqlite-utils last night—the 128th release of that package since I started building it back in 2018. sqlite-utils is two things in one package: …
simonwillison.net
November 24, 2025 at 2:54 PM
Annotated release notes for the new sqlite-utils alpha, which includes several minor backwards incompatible changes that will be released in the stable 4.0 version once the new alpha has baked for a while simonwillison.net/2025/Nov/24/...
New release of sqlite-utils, my combined CLI tool and Python library for doing useful things with SQLite databases sqlite-utils.datasette.io/en/stable/ch...
November 23, 2024 at 10:54 PM
New release of sqlite-utils, my combined CLI tool and Python library for doing useful things with SQLite databases sqlite-utils.datasette.io/en/stable/ch...
Quick TIL: if you have uv installed and you want to try out ANY Python package in an ipython REPL, you can do so just by running
uvx --with llm --with sqlite-utils ipython
Pass as many --with package options as you like
I wrapped it in a shell script, "itry llm"
til.simonwillison.net/python/itry
uvx --with llm --with sqlite-utils ipython
Pass as many --with package options as you like
I wrapped it in a shell script, "itry llm"
til.simonwillison.net/python/itry
Trying out Python packages with ipython and uvx
I figured out a really simple pattern for experimenting with new Python packages today:
til.simonwillison.net
February 14, 2025 at 7:38 AM
Quick TIL: if you have uv installed and you want to try out ANY Python package in an ipython REPL, you can do so just by running
uvx --with llm --with sqlite-utils ipython
Pass as many --with package options as you like
I wrapped it in a shell script, "itry llm"
til.simonwillison.net/python/itry
uvx --with llm --with sqlite-utils ipython
Pass as many --with package options as you like
I wrapped it in a shell script, "itry llm"
til.simonwillison.net/python/itry
Ruff 0.16.0 - Astral's fast Python linter - came out a few days ago and increased the number of default-enabled rules from 59 to 413, which highlighted all sorts of problems across my projects (1618 in sqlite-utils alone) simonwillison.net/2026/Jul/25/...
Ruff v0.16.0
Astral shipped a significant new version of their Ruff Python linting tool a few days ago on July 23rd. I noticed today because my various CI jobs all started failing …
simonwillison.net
July 25, 2026 at 11:05 PM
Ruff 0.16.0 - Astral's fast Python linter - came out a few days ago and increased the number of default-enabled rules from 59 to 413, which highlighted all sorts of problems across my projects (1618 in sqlite-utils alone) simonwillison.net/2026/Jul/25/...
Have you tried sqlite-vec for that? til.simonwillison.net/sqlite/sqlit...
Using sqlite-vec with embeddings in sqlite-utils and Datasette
Alex Garcia's sqlite-vec SQLite extension provides a bunch of useful functions for working with vectors inside SQLite.
til.simonwillison.net
November 27, 2024 at 2:42 PM
Have you tried sqlite-vec for that? til.simonwillison.net/sqlite/sqlit...
Mon tips : le paquet CLI sqlite-utils dispo dans debian stable permet de faire du PoC super facilement. Genre ingérer un json en sqlite avec déduction auto du schéma sqlite-utils.datasette.io/en/stable/
sqlite-utils
sqlite-utils.datasette.io
July 7, 2025 at 10:58 AM
Mon tips : le paquet CLI sqlite-utils dispo dans debian stable permet de faire du PoC super facilement. Genre ingérer un json en sqlite avec déduction auto du schéma sqlite-utils.datasette.io/en/stable/
Super exciting update to nbsanity. I've incorporated @simonwillison.net 's shotscraper. Now, all new renders get a fancy social card! This makes nbsanity a nice microblogging utility
Examples of rendered notebooks:
1/3
nbsanity.com/static/6a987...
Examples of rendered notebooks:
1/3
nbsanity.com/static/6a987...
The sqlite-utils tutorial
nbsanity: A modern way to view public Jupyter notebooks on GitHub
nbsanity.com
December 8, 2024 at 6:32 PM
Super exciting update to nbsanity. I've incorporated @simonwillison.net 's shotscraper. Now, all new renders get a fancy social card! This makes nbsanity a nice microblogging utility
Examples of rendered notebooks:
1/3
nbsanity.com/static/6a987...
Examples of rendered notebooks:
1/3
nbsanity.com/static/6a987...
I'm sponsoring @simonwillison.net on GitHub because he writes probably the best unbiased notes/blog on being hands-on with LLMs as a dev. For those sponsoring he sends out a neat monthly digest of what he reads/been thinking about (a nice bonus!)
github.com/sponsors/sim...
github.com/sponsors/sim...
Sponsor @simonw on GitHub Sponsors
I'm building Datasette, LLM, sqlite-utils and a host of other related tools to make data analysis for small data (where small = "less than a TB") as productive as possible, and publishing a signifi...
github.com
July 10, 2025 at 8:13 PM
I'm sponsoring @simonwillison.net on GitHub because he writes probably the best unbiased notes/blog on being hands-on with LLMs as a dev. For those sponsoring he sends out a neat monthly digest of what he reads/been thinking about (a nice bonus!)
github.com/sponsors/sim...
github.com/sponsors/sim...
Since this is a slightly backwards-incompatible change here's a detailed upgrade guide - which you can read, or feed into your coding agent and have it apply the upgrades for you sqlite-utils.datasette.io/en/stable/up...
Upgrading - sqlite-utils
sqlite-utils.datasette.io
July 7, 2026 at 7:53 PM
Since this is a slightly backwards-incompatible change here's a detailed upgrade guide - which you can read, or feed into your coding agent and have it apply the upgrades for you sqlite-utils.datasette.io/en/stable/up...
I had access over the weekend but with hindsight didn't do a great job of evaluation because I used it for real work: Most of the sqlite-utils 4 alpha release was written with help from Opus
I learned that production coding like that doesn't help identify new model strengths!
I learned that production coding like that doesn't help identify new model strengths!
November 24, 2025 at 7:48 PM
I had access over the weekend but with hindsight didn't do a great job of evaluation because I used it for real work: Most of the sqlite-utils 4 alpha release was written with help from Opus
I learned that production coding like that doesn't help identify new model strengths!
I learned that production coding like that doesn't help identify new model strengths!
You actually don't need multiple --with. A comma separated list of packages also works (though looks a bit uglier)
uvx --with llm,sqlite-utils ipython
uvx --with llm,sqlite-utils ipython
February 14, 2025 at 12:52 PM
You actually don't need multiple --with. A comma separated list of packages also works (though looks a bit uglier)
uvx --with llm,sqlite-utils ipython
uvx --with llm,sqlite-utils ipython
🤖 Claude Fable helps SQLite utility library fix major bugs before release
Developers are using AI tools like Claude Fable to automate debugging and ensure stable releases of software libraries. The recent sqlite utils...
#GenerativeAI #DeepLearning #AIInference #AI #AIPulse
Developers are using AI tools like Claude Fable to automate debugging and ensure stable releases of software libraries. The recent sqlite utils...
#GenerativeAI #DeepLearning #AIInference #AI #AIPulse
Read the full article →
www.synestesia.uk
July 5, 2026 at 3:34 AM
🤖 Claude Fable helps SQLite utility library fix major bugs before release
Developers are using AI tools like Claude Fable to automate debugging and ensure stable releases of software libraries. The recent sqlite utils...
#GenerativeAI #DeepLearning #AIInference #AI #AIPulse
Developers are using AI tools like Claude Fable to automate debugging and ensure stable releases of software libraries. The recent sqlite utils...
#GenerativeAI #DeepLearning #AIInference #AI #AIPulse
I don't need LLMs to be original, I need them to be able to do boring predictable coding tasks faster than if I were to do them by hand
I'm so glad I didn't have to write this whole change myself the other day! github.com/simonw/sqlit...
I'm so glad I didn't have to write this whole change myself the other day! github.com/simonw/sqlit...
Use double quotes not braces for tables and columns (#678) · simonw/sqlite-utils@fb93452
Closes #677
github.com
November 26, 2025 at 6:39 AM
I don't need LLMs to be original, I need them to be able to do boring predictable coding tasks faster than if I were to do them by hand
I'm so glad I didn't have to write this whole change myself the other day! github.com/simonw/sqlit...
I'm so glad I didn't have to write this whole change myself the other day! github.com/simonw/sqlit...
if you're a vim gremlin like me and hate having to open another terminal to read a sqlite db, just do :%!sqlite-utils dump %. just be sure to convert is back afterwards lol
July 2, 2026 at 1:11 AM
if you're a vim gremlin like me and hate having to open another terminal to read a sqlite db, just do :%!sqlite-utils dump %. just be sure to convert is back afterwards lol
I prototyped one of the new features using a Claude code for web running on my phone while out walking the dog! Here's the prompt I used for that github.com/simonw/resea...
Add sqlite-utils iterator support research by simonw · Pull Request #31 · simonw/research
Prompt to Claude Code for web:
Experiment with modifying simonw/sqlite-utils from github such that the insert_all and upsert_all methods can optionally be passed a Python iterator that yields list...
github.com
November 24, 2025 at 3:04 PM
I prototyped one of the new features using a Claude code for web running on my phone while out walking the dog! Here's the prompt I used for that github.com/simonw/resea...
rc4 for sqlite-utils 4.0, incorporating feedback from claude fable 5. interesting to see how these tools evolve. #opensource #opensource #
sqlite-utils 4.0rc4
Release: sqlite-utils 4.0rc4
The last RC before the 4.0 stable release. Mainly implements feedback from a detailed review by Claude Fable 5.
Tags: sqlite-utils, claude-mythos-fable
simonwillison.net
July 9, 2026 at 5:00 PM
rc4 for sqlite-utils 4.0, incorporating feedback from claude fable 5. interesting to see how these tools evolve. #opensource #opensource #
Quick TIL: if you have uv installed and you want to try out ANY Python package in an ipython REPL, you can do so just by running
uvx --with llm --with sqlite-utils ipython
Pass as many --with package options as you like
I wrapped it in a shell script, "itry llm" […]
uvx --with llm --with sqlite-utils ipython
Pass as many --with package options as you like
I wrapped it in a shell script, "itry llm" […]
Original post on fedi.simonwillison.net
fedi.simonwillison.net
February 14, 2025 at 7:38 AM
Quick TIL: if you have uv installed and you want to try out ANY Python package in an ipython REPL, you can do so just by running
uvx --with llm --with sqlite-utils ipython
Pass as many --with package options as you like
I wrapped it in a shell script, "itry llm" […]
uvx --with llm --with sqlite-utils ipython
Pass as many --with package options as you like
I wrapped it in a shell script, "itry llm" […]
Got a neat project using Datasette, LLM, sqlite-utils or any of the other tools in the Datasette ecosystem? We'd love to see your demo!
We're running another Public Office Hours session tomorrow (Friday) at 2pm Pacific - we have room for a few more demos simonwillison.net/2025/Jan/30/...
We're running another Public Office Hours session tomorrow (Friday) at 2pm Pacific - we have room for a few more demos simonwillison.net/2025/Jan/30/...
Datasette Public Office Hours 31st Jan at 2pm Pacific
We're running another Datasette Public Office Hours session on Friday 31st January at 2pm Pacific ([more timezones here](https://www.timeanddate.com/worldclock/converter.html?iso=20250131T220000&p1=22...
simonwillison.net
January 30, 2025 at 9:47 PM
Got a neat project using Datasette, LLM, sqlite-utils or any of the other tools in the Datasette ecosystem? We'd love to see your demo!
We're running another Public Office Hours session tomorrow (Friday) at 2pm Pacific - we have room for a few more demos simonwillison.net/2025/Jan/30/...
We're running another Public Office Hours session tomorrow (Friday) at 2pm Pacific - we have room for a few more demos simonwillison.net/2025/Jan/30/...