Datasette Tools

Datasette is built on top of SQLite. The Datasette ecosystem includes a growing collection of tools for creating and manipulating SQLite databases, and importing data into them from a variety of different sources.

Sort by most recent release · downloads this week · stars

llm by simonw

Access large language models from the command-line

⭐ 7487

Latest: 0.26a0 on 14th May 2025

sqlite-utils by simonw

Python CLI utility and library for manipulating SQLite databases

⭐ 1817

Screenshot of simonw/sqlite-utils

Latest: 4.0a0 on 9th May 2025

sqlite-diffable by simonw

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

⭐ 120

Latest: 0.6 on 5th May 2025

csvs-to-sqlite by simonw

Convert CSV files into a SQLite database

⭐ 902

Latest: 1.3.1 on 10th April 2025

shot-scraper by simonw

A command-line utility for taking automated screenshots of websites

⭐ 1928

Screenshot of simonw/shot-scraper

Latest: 1.8 on 25th March 2025

strip-tags by simonw

CLI tool for stripping tags from HTML

⭐ 319

Latest: 0.6 on 28th February 2025

csv-diff by simonw

Python CLI tool and library for diffing CSV and JSON files

⭐ 311

Latest: 1.2 on 6th September 2024

ttok by simonw

Count and truncate text based on tokens

⭐ 348

Latest: 0.3 on 2nd May 2024

openai-to-sqlite by simonw

Save OpenAI API results to a SQLite database

⭐ 232

Latest: 0.4.2 on 17th April 2024

s3-credentials by simonw

A tool for creating credentials for accessing S3 buckets

⭐ 211

Screenshot of simonw/s3-credentials

Latest: 0.16.1 on 5th April 2024

pypi-to-sqlite by simonw

Load data about Python packages from PyPI into SQLite

⭐ 14

Latest: 0.2.3 on 6th March 2024

django-sql-dashboard by simonw

Django app for building dashboards using raw SQL queries

⭐ 451

Screenshot of simonw/django-sql-dashboard

Latest: 1.2 on 16th December 2023

github-to-sqlite by dogsheep

Save data from GitHub to a SQLite database

⭐ 423

Screenshot of dogsheep/github-to-sqlite

Latest: 2.9 on 10th December 2023

pocket-to-sqlite by dogsheep

Create a SQLite database containing data from your Pocket account

⭐ 105

Latest: 0.2.3 on 9th July 2023

swarm-to-sqlite by dogsheep

Create a SQLite database containing your checkin history from Foursquare Swarm

⭐ 62

Latest: 0.3.4 on 11th April 2023

apple-notes-to-sqlite by dogsheep

Export Apple Notes to SQLite

⭐ 204

Latest: 0.1 on 9th March 2023

db-to-sqlite by simonw

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

⭐ 399

Latest: 1.5 on 7th February 2023

git-history by simonw

Tools for analyzing Git history using SQLite

⭐ 205

Latest: 0.7a0 on 11th January 2023

json-to-files by simonw

Create separate files on disk based on a JSON object

⭐ 6

Latest: 0.1 on 10th January 2023

shapefile-to-sqlite by simonw

Load shapefiles into a SQLite (optionally SpatiaLite) database

⭐ 31

Latest: 0.4.2 on 8th January 2023

geocode-sqlite by eyeseast

Geocode rows in a SQLite database table

⭐ 236

Latest: 0.8.2 on 7th November 2022

s3-ocr by simonw

Tools for running OCR against files stored in S3

⭐ 119

Screenshot of simonw/s3-ocr

Latest: 0.6.3 on 10th August 2022

sqlite-comprehend by simonw

Tools for running data in a SQLite database through AWS Comprehend

⭐ 6

Latest: 0.2.2 on 12th July 2022

geojson-to-sqlite by simonw

CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)

⭐ 63

Latest: 1.1.1 on 13th April 2022

google-drive-to-sqlite by simonw

Create a SQLite database containing metadata from Google Drive

⭐ 159

Latest: 0.4 on 20th February 2022

twitter-to-sqlite by dogsheep

Save data from Twitter to a SQLite database

⭐ 408

Latest: 0.22 on 21st September 2021

evernote-to-sqlite by dogsheep

Tools for converting Evernote content to SQLite

⭐ 37

Latest: 0.3.2 on 26th August 2021

healthkit-to-sqlite by dogsheep

Convert an Apple Healthkit export zip to a SQLite database

⭐ 214

Latest: 1.0.1 on 20th August 2021

sqlite-transform by simonw

Tool for running transformations on columns in a SQLite database

⭐ 31

Latest: 1.2.1 on 2nd August 2021

dogsheep-beta by dogsheep

Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette

⭐ 194

Latest: 0.10.2 on 13th June 2021

yaml-to-sqlite by simonw

Utility for converting YAML files to SQLite

⭐ 75

Latest: 1.0 on 13th June 2021

markdown-to-sqlite by simonw

CLI tool for loading markdown files into a SQLite database

⭐ 84

Latest: 1.0 on 13th June 2021

airtable-export by simonw

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

⭐ 124

Latest: 0.7.1 on 9th April 2021

tableau-to-sqlite by simonw

Fetch data from Tableau into a SQLite database

⭐ 11

Latest: 0.2.1 on 22nd March 2021

hacker-news-to-sqlite by dogsheep

Create a SQLite database containing data pulled from Hacker News

⭐ 51

Latest: 0.4 on 13th March 2021

download-tiles by simonw

Download map tiles and store them in an MBTiles database

⭐ 41

Latest: 0.4.1 on 16th February 2021

sphinx-to-sqlite by simonw

Create a SQLite database from Sphinx documentation

⭐ 6

Latest: 0.1a1 on 22nd October 2020

inaturalist-to-sqlite by dogsheep

Create a SQLite database containing your observation history from iNaturalist

⭐ 8

Latest: 0.2.1 on 22nd October 2020

datasette-clone by simonw

Create a local copy of database files from a Datasette instance

⭐ 7

Latest: 0.5 on 22nd July 2020

sqlite-generate by simonw

Tool for generating demo SQLite databases

⭐ 24

Latest: 1.1.1 on 23rd June 2020

dogsheep-photos by dogsheep

Upload your photos to S3 and import metadata about them into a SQLite database

⭐ 177

Latest: 0.4.1 on 25th May 2020

fec-to-sqlite by simonw

Save FEC campaign finance data to a SQLite database

⭐ 11

Latest: 0.2 on 7th March 2020

genome-to-sqlite by dogsheep

Import your genome into a SQLite database

⭐ 21

Latest: 0.1 on 19th September 2019

datasette-app by simonw

The Datasette macOS application

⭐ 126

Screenshot of simonw/datasette-app