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
sqlite-utils by simonw
Python CLI utility and library for manipulating SQLite databases
52,765 downloads this week ⭐ 1480
Latest: 3.36 on 8th December 2023
csv-diff by simonw
Python CLI tool and library for diffing CSV and JSON files
13,758 downloads this week ⭐ 198
Latest: 1.1 on 23rd February 2021
shot-scraper by simonw
A command-line utility for taking automated screenshots of websites
4,520 downloads this week ⭐ 1490
Latest: 1.4 on 5th February 2024
llm by simonw
Access large language models from the command-line
2,125 downloads this week ⭐ 2837
Latest: 0.13.1 on 27th January 2024
django-sql-dashboard by simonw
Django app for building dashboards using raw SQL queries
963 downloads this week ⭐ 420
Latest: 1.2 on 16th December 2023
db-to-sqlite by simonw
CLI tool for exporting tables or queries from any SQL database to a SQLite file
885 downloads this week ⭐ 279
Latest: 1.5 on 7th February 2023
git-history by simonw
Tools for analyzing Git history using SQLite
533 downloads this week ⭐ 172
Latest: 0.7a0 on 11th January 2023
ttok by simonw
Count and truncate text based on tokens
331 downloads this week ⭐ 152
Latest: 0.2 on 10th July 2023
airtable-export by simonw
Export Airtable data to YAML, JSON or SQLite files on disk
320 downloads this week ⭐ 86
Latest: 0.7.1 on 9th April 2021
sqlite-diffable by simonw
Tools for dumping/loading a SQLite database to diffable directory structure
297 downloads this week ⭐ 42
Latest: 0.5 on 18th August 2022
sqlite-comprehend by simonw
Tools for running data in a SQLite database through AWS Comprehend
256 downloads this week ⭐ 6
Latest: 0.2.2 on 12th July 2022
csvs-to-sqlite by simonw
Convert CSV files into a SQLite database
248 downloads this week ⭐ 858
Latest: 1.3 on 18th November 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 downloads this week ⭐ 78
Latest: 0.10.2 on 13th June 2021
s3-credentials by simonw
A tool for creating credentials for accessing S3 buckets
138 downloads this week ⭐ 183
Latest: 0.16.1 on 5th April 2024
strip-tags by simonw
CLI tool for stripping tags from HTML
125 downloads this week ⭐ 114
Latest: 0.5.1 on 9th July 2023
tableau-to-sqlite by simonw
Fetch data from Tableau into a SQLite database
122 downloads this week ⭐ 8
Latest: 0.2.1 on 22nd March 2021
twitter-to-sqlite by dogsheep
Save data from Twitter to a SQLite database
94 downloads this week ⭐ 269
Latest: 0.22 on 21st September 2021
yaml-to-sqlite by simonw
Utility for converting YAML files to SQLite
68 downloads this week ⭐ 36
Latest: 1.0 on 13th June 2021
s3-ocr by simonw
Tools for running OCR against files stored in S3
64 downloads this week ⭐ 63
Latest: 0.6.3 on 10th August 2022
github-to-sqlite by dogsheep
Save data from GitHub to a SQLite database
51 downloads this week ⭐ 361
Latest: 2.9 on 10th December 2023
geocode-sqlite by eyeseast
Geocode rows in a SQLite database table
44 downloads this week ⭐ 223
Latest: 0.8.2 on 7th November 2022
json-to-files by simonw
Create separate files on disk based on a JSON object
32 downloads this week ⭐ 1
Latest: 0.1 on 10th January 2023
download-tiles by simonw
Download map tiles and store them in an MBTiles database
31 downloads this week ⭐ 24
Latest: 0.4.1 on 16th February 2021
hacker-news-to-sqlite by dogsheep
Create a SQLite database containing data pulled from Hacker News
29 downloads this week ⭐ 25
Latest: 0.4 on 13th March 2021
datasette-clone by simonw
Create a local copy of database files from a Datasette instance
29 downloads this week ⭐ 2
Latest: 0.5 on 22nd July 2020
geojson-to-sqlite by simonw
CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)
27 downloads this week ⭐ 34
Latest: 1.1.1 on 13th April 2022
pypi-to-sqlite by simonw
Load data about Python packages from PyPI into SQLite
24 downloads this week ⭐ 9
Latest: 0.2.3 on 6th March 2024
apple-notes-to-sqlite by dogsheep
Export Apple Notes to SQLite
23 downloads this week ⭐ 27
Latest: 0.1 on 9th March 2023
sqlite-generate by simonw
Tool for generating demo SQLite databases
22 downloads this week ⭐ 17
Latest: 1.1.1 on 23rd June 2020
shapefile-to-sqlite by simonw
Load shapefiles into a SQLite (optionally SpatiaLite) database
20 downloads this week ⭐ 23
Latest: 0.4.2 on 8th January 2023
sqlite-transform by simonw
Tool for running transformations on columns in a SQLite database
20 downloads this week ⭐ 29
Latest: 1.2.1 on 2nd August 2021
openai-to-sqlite by simonw
Save OpenAI API results to a SQLite database
19 downloads this week ⭐ 211
Latest: 0.4.2 on 17th April 2024
pocket-to-sqlite by dogsheep
Create a SQLite database containing data from your Pocket account
16 downloads this week ⭐ 89
Latest: 0.2.3 on 9th July 2023
google-drive-to-sqlite by simonw
Create a SQLite database containing metadata from Google Drive
13 downloads this week ⭐ 133
Latest: 0.4 on 20th February 2022
evernote-to-sqlite by dogsheep
Tools for converting Evernote content to SQLite
13 downloads this week ⭐ 24
Latest: 0.3.2 on 26th August 2021
swarm-to-sqlite by dogsheep
Create a SQLite database containing your checkin history from Foursquare Swarm
12 downloads this week ⭐ 53
Latest: 0.3.4 on 11th April 2023
healthkit-to-sqlite by dogsheep
Convert an Apple Healthkit export zip to a SQLite database
12 downloads this week ⭐ 91
Latest: 1.0.1 on 20th August 2021
dbf-to-sqlite by simonw
CLI tool for converting DBF files (dBase, FoxPro etc) to SQLite
10 downloads this week ⭐ 25
Latest: 0.1 on 31st January 2019
dogsheep-photos by dogsheep
Upload your photos to S3 and import metadata about them into a SQLite database
9 downloads this week ⭐ 124
Latest: 0.4.1 on 25th May 2020
sphinx-to-sqlite by simonw
Create a SQLite database from Sphinx documentation
6 downloads this week ⭐ 2
Latest: 0.1a1 on 22nd October 2020
markdown-to-sqlite by simonw
CLI tool for loading markdown files into a SQLite database
5 downloads this week ⭐ 49
Latest: 1.0 on 13th June 2021
fec-to-sqlite by simonw
Save FEC campaign finance data to a SQLite database
5 downloads this week ⭐ 9
Latest: 0.2 on 7th March 2020
inaturalist-to-sqlite by dogsheep
Create a SQLite database containing your observation history from iNaturalist
3 downloads this week ⭐ 2
Latest: 0.2.1 on 22nd October 2020
genome-to-sqlite by dogsheep
Import your genome into a SQLite database
2 downloads this week ⭐ 13
Latest: 0.1 on 19th September 2019
google-takeout-to-sqlite by dogsheep
Save data from Google Takeout to a SQLite database
2 downloads this week ⭐ 51
Latest: 0.2 on 8th September 2019