Simon Willison

Access large language models from the command-line

A command-line tool and Python library for sending prompts to dozens of AI models from your terminal, with automatic conversation history saved to a local SQLite database and a plugin system for adding more models.

An open source multi-tool for exploring and publishing data

Datasette turns any SQLite database file into a browsable website and JSON API with a single command, no web development required, so you can share datasets publicly in minutes.

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

A command-line utility for taking automated screenshots of websites

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

CLI tool for interacting with the web

Research projects

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

Cutting-edge web scraping techniques workshop at NICAR 2025

CLI tool for stripping tags from HTML

LLM plugin for models hosted by OpenRouter

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

Support for MLX models in LLM

Save OpenAI API results to a SQLite database

Opinionated cookiecutter template for creating a new Python library

LLM access to models by Anthropic, including the Claude series

Tools for analyzing Git history using SQLite

LLM plugin providing access to Mistral models using the Mistral API

Tracking fire data from www.fire.ca.gov

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

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

JavaScript port of EmilStenstrom/justhtml

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

Create a SQLite database containing metadata from Google Drive

Prices of various LLMs

Python library for running a MicroPython sandbox using WebAssembly

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

LLM plugin for running models using llama.cpp

A memcached backed rate limiting decorator for Django.

The official project website for Datasette

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

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

Template repository for setting up a new git scraper

Wrap Go binaries in Python wheels

LLM plugin for pulling content from Hacker News

Track changes to SQLite tables using triggers

Copilot-assisted Advent of Code 2022 to learn Rust

A plugin system for Django

Datasette plugin providing an automatic GraphQL API for your SQLite databases

Access OpenAI models via an existing Codex subscription

Scan for secrets in files you plan to share

Codespaces with LLM pre-configured using GitHub models

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

No description.

SwiftUI presentation software, every slide is a URL

Unofficial documentation for GitHub Spark, generated with GitHub Spark

CLI tool for loading markdown files into a SQLite database

Run models distributed as GGUF files using LLM

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

Scrape HN to track links from specific domains

LLM plugin for clustering embeddings

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

SwiftUI menu bar app for monitoring application bandwidth use

LLM plugin for embeddings using sentence-transformers

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

Load GitHub repository contents as LLM fragments

Keeping track of the latest versions of various GitHub Actions

Ask questions of your data with LLM assistance

Cookiecutter template for creating renamed PyPI packages

LLM plugin for models hosted on Replicate

Embedding models from Jina AI

Datasette plugin for visualizing data using Vega

Handout for a talk I gave about LLM and CLI tools

CLI tool for converting DBF files (dBase, FoxPro etc) to SQLite

What you get when you run different uv init commands

Concatenated documentation for use with LLMs

Tracking PG&E outages

Use triggers to track when rows in a SQLite table were updated or deleted

Convert a Claude.ai export to SQLite

LLM tools for running queries against SQLite

LLM fragment plugin to turn a video into images of different frames

Download map tiles and store them in an MBTiles database

CLI tool for creating charts

Tracking the history of trees in San Francisco

Vercel app for taking screenshots of web pages using Puppeteer

Backups of the database for simonwillison.net

Datasette plugin for publishing data using Vercel

Load email from .mbox files into SQLite

Show GPU usage with a macOS menu icon

Skills for coding agents

Run prompts against models hosted on AWS Bedrock

"llm python" is a command to run a Python interpreter in the LLM virtual environment

Access the Cohere Command R family of models

Scrape various open data directories to create an index of what's available out there

Building software on top of Large Language Models tutorial from PyCon 2025

Run async workflows using pytest-fixtures-style dependency injection

Grant LLM access to a Docker container for running commands

GitHub template repository for creating new Python Click CLI tools, using the simonw/click-app cookiecutter template

Load LLM templates from Fabric

LLM fragments plugin to load a PDF as a sequence of images

Run embedding models using ONNX

https://ollama.com/search?o=newest

A cookiecutter template for building plugins for LLM

Run JavaScript code and WASM in a Deno sandbox

LLM plugin for interacting with llama-server models

Python port of MicroQuickJS

Expose Datasette instances to LLM as a tool

Answer questions against collections stored in LLM using Retrieval Augmented Generation

LLM plugin for asking questions of LLM's own documentation, and related packages

Research into the HTTP APIs from various LLM providers.

JavaScript execution as a tool for LLM

My sponsors-only monthly newsletter on a one month delay

SmolLM2-135M-Instruct.Q4_1 for LLM

Run transcriptions using the OpenAI Whisper API

Datasette plugin for authentication using passwords

GitHub template repository for creating new Datasette plugins, using the simonw/datasette-plugin cookiecutter template

Chat with Mr Chatterbox, trained on a corpus of over 28,000 Victorian-era British texts published between 1837 and 1899

Tracking PG&E power outages

Make simple_eval available as an LLM tool

Scan folders for SQLite database files

SQLite table history tracking using a JSON audit log

Git scrapers for scraping the fediverse

Plugin for LLM adding a Markov chain generating model

Datasette plugin for serving media based on a SQL query

Transcribe audio using the Groq.com Whisper API

Datasette plugin for modifying table schemas

LLM templates to share

Explore 3,500 Facebook ads reported to have been bought by the Russian Internet Research Agency

Terminal UI for sqlite-utils

Datasette plugin adding a llm_embed(model_id, text) SQL function

A fast, helpful, and open-source document parser

A Flask+Elasticsearch UI for exploring the DC Inbox dataset from http://web.stevens.edu/dcinbox/Home.html

Demos of simonw/showcase

No description.

Experimental Datasette output plugin using CSS properties

Datasette plugin for authenticating access using API tokens

Trying things out with GitHub Pages

LLM plugin providing tools for editing files

Datasette plugin for rendering timestamps

Python 3.13, uv and GitHub Copilot in Codespaces

Trigram tokenizer module for SQLite FTS5

Homebrew formulas for installing LLM and related tools

No description.

No description.

Publishing an atom feed of recent California Brown Pelican sightings from iNaturalist

Coding agents for data analysis, a workshop at NICAR 2026

Download statistics for my PyPI packages

No description.

A scraper for implementation details of Claude Artifacts

Scrape highway information from https://roads.dot.ca.gov/

Luau packaged as a Pyodide WebAssembly wheel

Git scraper recording the package versions installed on the defaul GitHub Actions ubuntu-latest worker

Demo for https://github.com/simonw/python-lib

No description.

LLM fragment loader for Python symbols

A plugin to use Local models via LM Studio API with https://llm.datasette.io

Debug plugin for LLM providing an echo model

Skills Catalog for Codex

Turn YouTube URLs into embedded players in Datasette

Create separate files on disk based on a JSON object

Datasette plugin for SHOWBOAT_REMOTE_URL

Register async versions of models from LLM plugins that only provide a sync version

An example repository for running Datasette in GitHub Codespaces

Simple, modern and fast file watching and code reload for Python, written in Rust

SmolVLM for LLM, using transformers

docTR (Document Text Recognition) - a seamless, high-performing & accessible library for OCR-related tasks powered by Deep Learning.

Archive PyPI JSON information for all Datasette related packages

No description.

Datasette instance with data from unitedstates/congress-legislators

Python library for parsing SQLite SELECT queries into an AST

Various Cloudflare Pages redirect sites

https://hugovk.github.io/free-threaded-wheels/results.json

Export pages from Datasette to files on disk

Fast foreign key addition for sqlite-utils

sqlite-utils plugin adding a move-tables command

A language independent conformance suite for implementations of a SQLite SELECT query parser

Spot whales

Markdown exports of the Universal Declaration of Human Rights

A prototype of running Guidepup on macOS in GitHub Actions

DeepSeek 4 Flash local inference engine for Metal and CUDA

No description.

pytest fixture finding an unused local port

A conformance suite for HTTP multipart form data

https://earthquake.usgs.gov/earthquakes/feed/v1.0/summary/all_hour.geojson

No description.

Runs inaturalist-clumper

Sightings of Chonkers

Group iNaturalist sightings into clumps

The Python Package Index