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
30,786 downloads this week ⭐ 1033
shot-scraper by simonw
A command-line utility for taking automated screenshots of websites
3,133 downloads this week ⭐ 775
django-sql-dashboard by simonw
Django app for building dashboards using raw SQL queries
846 downloads this week ⭐ 335
twitter-to-sqlite by dogsheep
Save data from Twitter to a SQLite database
156 downloads this week ⭐ 269
github-to-sqlite by dogsheep
Save data from GitHub to a SQLite database
169 downloads this week ⭐ 235
db-to-sqlite by simonw
CLI tool for exporting tables or queries from any SQL database to a SQLite file
132 downloads this week ⭐ 226
csv-diff by simonw
Python CLI tool and library for diffing CSV and JSON files
9,718 downloads this week ⭐ 198
google-drive-to-sqlite by simonw
Create a SQLite database containing metadata from Google Drive
45 downloads this week ⭐ 133
s3-credentials by simonw
A tool for creating credentials for accessing S3 buckets
155 downloads this week ⭐ 129
dogsheep-photos by dogsheep
Upload your photos to S3 and import metadata about them into a SQLite database
15 downloads this week ⭐ 124
healthkit-to-sqlite by dogsheep
Convert an Apple Healthkit export zip to a SQLite database
75 downloads this week ⭐ 91
dogsheep-beta by dogsheep
Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
179 downloads this week ⭐ 78
pocket-to-sqlite by dogsheep
Create a SQLite database containing data from your Pocket account
40 downloads this week ⭐ 63
google-takeout-to-sqlite by dogsheep
Save data from Google Takeout to a SQLite database
18 downloads this week ⭐ 51
markdown-to-sqlite by simonw
CLI tool for loading markdown files into a SQLite database
27 downloads this week ⭐ 49
sqlite-diffable by simonw
Tools for dumping/loading a SQLite database to diffable directory structure
657 downloads this week ⭐ 42
swarm-to-sqlite by dogsheep
Create a SQLite database containing your checkin history from Foursquare Swarm
45 downloads this week ⭐ 37
geojson-to-sqlite by simonw
CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)
105 downloads this week ⭐ 34
airtable-export by simonw
Export Airtable data to YAML, JSON or SQLite files on disk
105 downloads this week ⭐ 33
sqlite-transform by simonw
Tool for running transformations on columns in a SQLite database
131 downloads this week ⭐ 29
hacker-news-to-sqlite by dogsheep
Create a SQLite database containing data pulled from Hacker News
37 downloads this week ⭐ 25
dbf-to-sqlite by simonw
CLI tool for converting DBF files (dBase, FoxPro etc) to SQLite
16 downloads this week ⭐ 25
evernote-to-sqlite by dogsheep
Tools for converting Evernote content to SQLite
67 downloads this week ⭐ 24
shapefile-to-sqlite by simonw
Load shapefiles into a SQLite (optionally SpatiaLite) database
26 downloads this week ⭐ 15
download-tiles by simonw
Download map tiles and store them in an MBTiles database
55 downloads this week ⭐ 9
tableau-to-sqlite by simonw
Fetch data from Tableau into a SQLite database
74 downloads this week ⭐ 8
fec-to-sqlite by simonw
Save FEC campaign finance data to a SQLite database
17 downloads this week ⭐ 8
sqlite-comprehend by simonw
Tools for running data in a SQLite database through AWS Comprehend
148 downloads this week ⭐ 6
pypi-to-sqlite by simonw
Load data about Python packages from PyPI into SQLite
49 downloads this week ⭐ 2
sphinx-to-sqlite by simonw
Create a SQLite database from Sphinx documentation
45 downloads this week ⭐ 2
inaturalist-to-sqlite by dogsheep
Create a SQLite database containing your observation history from iNaturalist
17 downloads this week ⭐ 2
datasette-clone by simonw
Create a local copy of database files from a Datasette instance
41 downloads this week ⭐ 2