Simon Willison, creator of the widely-used sqlite-utils Python library, has shipped version 4.0rc2—and he's being transparent about where the code came from. Most of it was written by Claude Fable, an AI coding agent, at a cost of approximately $149.25. The release candidate marks a significant milestone for the project, which provides utilities for manipulating SQLite databases without writing SQL.

How It Works

Willison detailed his approach in a post on simonwillison.net, explaining that he used Claude Fable to handle much of the implementation work while providing human oversight and guidance. The roughly $150 price tag covers API costs and agent usage—significantly cheaper than traditional development time for comparable features. This represents a real-world test case for AI-assisted software engineering at a practical scale.

sqlite-utils in the Wild

The library has become a staple in the Python ecosystem, particularly among data engineers and developers who prefer working with SQLite's simplicity. It handles common tasks like inserting records from JSON or CSV files, converting between database formats, and running SQL queries directly against files without needing a full database server. The project is frequently cited as an example of pragmatic Python tooling.

The AI Coding Agent Experiment

Using Claude Fable to write most of the code for a production library marks an evolution in how developers are integrating AI agents into their workflows. Rather than having an AI generate snippets or fix bugs, Willison essentially delegated substantial feature development to the agent while remaining responsible for review and direction. The 4.0 release includes breaking changes that reflect this new approach to collaborative development between humans and AI.

Key Takeaways

  • sqlite-utils 4.0rc2 is available now with major improvements to the library's core functionality
  • Claude Fable handled most of the implementation work for approximately $149.25 in API costs
  • The experiment demonstrates AI coding agents can produce production-ready code for real projects
  • Human oversight remains essential for architecture decisions and final review

The Bottom Line

This isn't a gimmick—it's a glimpse at how small-scale open source maintenance might actually get done going forward. Willison's willingness to ship code he didn't type himself, while being upfront about it, sets a precedent worth watching. Whether $150 becomes the new going rate for minor library features remains to be seen, but sqlite-utils just made AI-assisted development look a lot more legitimate.