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
s3-credentials
A tool for creating credentials for accessing S3 buckets
⭐ 82
Latest: 0.9 on 18th January 2022
sqlite-utils
Python CLI utility and library for manipulating SQLite databases
⭐ 620
Latest: 3.22 on 11th January 2022
github-to-sqlite
Save data from GitHub to a SQLite database
⭐ 168
Latest: 2.8.3 on 1st December 2021
twitter-to-sqlite
Save data from Twitter to a SQLite database
⭐ 269
Latest: 0.22 on 21st September 2021
evernote-to-sqlite
Tools for converting Evernote content to SQLite
⭐ 24
Latest: 0.3.2 on 26th August 2021
healthkit-to-sqlite
Convert an Apple Healthkit export zip to a SQLite database
⭐ 91
Latest: 1.0.1 on 20th August 2021
sqlite-transform
Tool for running transformations on columns in a SQLite database
⭐ 29
Latest: 1.2.1 on 2nd August 2021
django-sql-dashboard
Django app for building dashboards using raw SQL queries
⭐ 272
Latest: 1.0.1 on 6th July 2021
dogsheep-beta
Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
⭐ 78
Latest: 0.10.2 on 13th June 2021
markdown-to-sqlite
CLI tool for loading markdown files into a SQLite database
⭐ 32
Latest: 1.0 on 13th June 2021
db-to-sqlite
CLI tool for exporting tables or queries from any SQL database to a SQLite file
⭐ 226
Latest: 1.4 on 11th June 2021
geojson-to-sqlite
CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)
⭐ 28
Latest: 0.3.1 on 20th May 2021
airtable-export
Export Airtable data to YAML, JSON or SQLite files on disk
⭐ 33
Latest: 0.7.1 on 9th April 2021
tableau-to-sqlite
Fetch data from Tableau into a SQLite database
⭐ 8
Latest: 0.2.1 on 22nd March 2021
hacker-news-to-sqlite
Create a SQLite database containing data pulled from Hacker News
⭐ 25
Latest: 0.4 on 13th March 2021
csv-diff
Python CLI tool and library for diffing CSV and JSON files
⭐ 140
Latest: 1.1 on 23rd February 2021
download-tiles
Download map tiles and store them in an MBTiles database
⭐ 9
Latest: 0.4.1 on 16th February 2021
swarm-to-sqlite
Create a SQLite database containing your checkin history from Foursquare Swarm
⭐ 37
Latest: 0.3.3 on 18th January 2021
sphinx-to-sqlite
Create a SQLite database from Sphinx documentation
⭐ 2
Latest: 0.1a1 on 22nd October 2020
inaturalist-to-sqlite
Create a SQLite database containing your observation history from iNaturalist
⭐ 2
Latest: 0.2.1 on 22nd October 2020
pocket-to-sqlite
Create a SQLite database containing data from your Pocket account
⭐ 49
Latest: 0.2.1 on 22nd October 2020
shapefile-to-sqlite
Load shapefiles into a SQLite (optionally SpatiaLite) database
⭐ 15
Latest: 0.4.1 on 23rd August 2020
datasette-clone
Create a local copy of database files from a Datasette instance
⭐ 2
Latest: 0.5 on 22nd July 2020
dogsheep-photos
Upload your photos to S3 and import metadata about them into a SQLite database
⭐ 124
Latest: 0.4.1 on 25th May 2020
sqlite-diffable
Tools for dumping/loading a SQLite database to diffable directory structure
⭐ 20
Latest: 0.2 on 4th July 2019