simonw

Access large language models from the command-line

An open source multi-tool for exploring and publishing data

Concatenate a directory full of files into a single prompt for use with LLMs

A CLI utility for taking screenshots of websites, recording video demos and scraping sites using JavaScript

Python CLI utility and library for manipulating SQLite databases

Assorted useful tools, almost entirely generated using LLMs

Tools for publishing transcripts for Claude Code sessions

Today I Learned

Create executable documents that demonstrate an agent's work

Convert CSV files into a SQLite database

The contents of /mnt/skills in Claude's code interpreter environment

Research projects

CLI tool for interacting with the web

CLI tool for exporting tables or queries from any SQL database to a SQLite file

Use LLM to generate and execute commands in your shell

Django app for building dashboards using raw SQL queries

LLM plugin to access Google's Gemini family of models

https://simonwillison.net/2020/Jul/10/self-updating-profile-readme/

The source code behind my blog

Cookiecutter template for creating new Click command-line tools

Datasette running in your browser using WebAssembly and Pyodide

Count and truncate text based on tokens

LLM plugin for models hosted by OpenRouter

Cutting-edge web scraping techniques workshop at NICAR 2025

CLI tool for stripping tags from HTML

Python CLI tool and library for diffing CSV and JSON files

Find the Python code for specified symbols

LLM plugin for interacting with the Claude 3 family of models

Plugin for LLM adding support for the GPT4All collection of models

Template repository for setting up shot-scraper

A tool for creating credentials for accessing S3 buckets

Utilities functions for node.js that borrow some useful concepts from Django

LLM access to models by Anthropic, including the Claude series

Support for MLX models in LLM

Save OpenAI API results to a SQLite database

Opinionated cookiecutter template for creating a new Python library

Tools for analyzing Git history using SQLite

LLM benchmark: Generate an SVG of a pelican riding a bicycle

Recovered cia.gov/the-world-factbook/about/archives/download/factbook-2020.zip from Internet Archive

LLM plugin providing access to Mistral models using the Mistral API

Tracking fire data from www.fire.ca.gov

Prices of various LLMs

Write and execute jq programs with the help of LLM

LLM plugin for running models using MLC

A tool for creating a repository of transcribed videos

Ultra simple API for geocoding a single string against various web services.

Python library for running a MicroPython sandbox using WebAssembly

JavaScript port of EmilStenstrom/justhtml

CLI tool for running text through OpenAI Text to speech

A modern library for integrating OpenID with Django - incomplete, but really nearly there (promise)

Create a SQLite database containing metadata from Google Drive

async alternatives to browser alert() and prompt() and confirm()

Experimental .transform(fn) method for Django QuerySets, for clever lazily evaluated optimisations.

LLM plugin for running models using llama.cpp

The official project website for Datasette

Tools for dumping/loading a SQLite database to diffable directory structure

A memcached backed rate limiting decorator for Django.

The Datasette macOS application

Wrap Go binaries in Python wheels

Export Airtable data to YAML, JSON or SQLite files on disk

Syntactic sugar for creating Python command line scripts by introspecting a function definition

Template repository for setting up a new git scraper

CLI tool for exploring an MCP server

Turtles all the way down

Track changes to SQLite tables using triggers

An API for identifying cougars v.s. bobcats v.s. other USA cat species

LLM plugin for pulling content from Hacker News

Download ESM modules from npm and jsdelivr

Generate captions for images with Salesforce BLIP

Copilot-assisted Advent of Code 2022 to learn Rust

Tools for running OCR against files stored in S3

A plugin system for Django

Access OpenAI models via an existing Codex subscription

A geographical community site for Django developers.

Datasette plugin providing an automatic GraphQL API for your SQLite databases

Codespaces with LLM pre-configured using GitHub models

Scan for secrets in files you plan to share

Datasette plugin that shows a map for any data with latitude/longitude columns

SwiftUI presentation software, every slide is a URL

Request per second / SQLop per second monitoring for Django, using Redis for storage

CLI tool for loading markdown files into a SQLite database

Run models distributed as GGUF files using LLM

Unofficial documentation for GitHub Spark, generated with GitHub Spark

Scrape HN to track links from specific domains

A simple database migration system for SQLite, based on sqlite-utils

Run the Moebius inpainting model in the browser

Utility for converting YAML files to SQLite

SwiftUI menu bar app for monitoring application bandwidth use

LLM plugin for clustering embeddings

Web interface for searching your code using ripgrep, built as a Datasette plugin

Script for saving a JSON archive of your tweets.

GitHub template repository for creating new Python libraries, using the simonw/python-lib cookiecutter template

Generate embeddings for images and text using CLIP with LLM

LLM plugin for embeddings using sentence-transformers

Integration of jCrop with the Django admin

Ask questions of your data with LLM assistance

Keeping track of the latest versions of various GitHub Actions

Scrape details about Code Interpreter to track any changes