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
csvs-to-sqlite
Convert CSV files into a SQLite database
718 downloads this week ⭐ 535
Latest: 1.2 on 3rd November 2020
sqlite-utils
Python CLI utility and library for manipulating SQLite databases
6,245 downloads this week ⭐ 350
Latest: 3.6 on 19th February 2021
db-to-sqlite
CLI tool for exporting tables or queries from any SQL database to a SQLite file
127 downloads this week ⭐ 206
Latest: 1.3 on 27th July 2020
twitter-to-sqlite
Save data from Twitter to a SQLite database
53 downloads this week ⭐ 194
Latest: 0.21.3 on 23rd July 2020
csv-diff
Python CLI tool and library for diffing CSV and JSON files
884 downloads this week ⭐ 113
Latest: 1.1 on 23rd February 2021
github-to-sqlite
Save data from GitHub to a SQLite database
161 downloads this week ⭐ 93
Latest: 2.8.2 on 16th December 2020
dogsheep-photos
Upload your photos to S3 and import metadata about them into a SQLite database
15 downloads this week ⭐ 89
Latest: 0.4.1 on 25th May 2020
healthkit-to-sqlite
Convert an Apple Healthkit export zip to a SQLite database
20 downloads this week ⭐ 64
Latest: 1.0 on 17th October 2020
dogsheep-beta
Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette
210 downloads this week ⭐ 44
Latest: 0.10.1 on 19th December 2020
swarm-to-sqlite
Create a SQLite database containing your checkin history from Foursquare Swarm
16 downloads this week ⭐ 35
Latest: 0.3.3 on 18th January 2021
pocket-to-sqlite
Create a SQLite database containing data from your Pocket account
10 downloads this week ⭐ 30
Latest: 0.2.1 on 22nd October 2020
yaml-to-sqlite
Utility for converting YAML files to SQLite
18 downloads this week ⭐ 29
Latest: 0.3.1 on 7th December 2020
markdown-to-sqlite
CLI tool for loading markdown files into a SQLite database
15 downloads this week ⭐ 26
Latest: 0.2 on 14th January 2021
sqlite-transform
Tool for running transformations on columns in a SQLite database
89 downloads this week ⭐ 22
Latest: 0.4 on 22nd February 2021
hacker-news-to-sqlite
Create a SQLite database containing data pulled from Hacker News
12 downloads this week ⭐ 19
Latest: 0.3.1 on 21st March 2020
geojson-to-sqlite
CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)
24 downloads this week ⭐ 17
Latest: 0.2 on 11th February 2020
airtable-export
Export Airtable data to YAML, JSON or SQLite files on disk
234 downloads this week ⭐ 16
Latest: 0.5 on 22nd February 2021
evernote-to-sqlite
Tools for converting Evernote content to SQLite
67 downloads this week ⭐ 15
Latest: 0.3.1 on 11th February 2021
sqlite-generate
Tool for generating demo SQLite databases
43 downloads this week ⭐ 15
Latest: 1.1.1 on 23rd June 2020
sqlite-diffable
Tools for dumping/loading a SQLite database to diffable directory structure
5 downloads this week ⭐ 14
Latest: 0.2 on 4th July 2019
shapefile-to-sqlite
Load shapefiles into a SQLite (optionally SpatiaLite) database
21 downloads this week ⭐ 11
Latest: 0.4.1 on 23rd August 2020
genome-to-sqlite
Import your genome into a SQLite database
1 downloads this week ⭐ 11
Latest: 0.1 on 19th September 2019
fec-to-sqlite
Save FEC campaign finance data to a SQLite database
15 downloads this week ⭐ 8
Latest: 0.2 on 7th March 2020
download-tiles
Download map tiles and store them in an MBTiles database
85 downloads this week ⭐ 3
Latest: 0.4.1 on 16th February 2021
sphinx-to-sqlite
Create a SQLite database from Sphinx documentation
15 downloads this week ⭐ 2
Latest: 0.1a1 on 22nd October 2020
inaturalist-to-sqlite
Create a SQLite database containing your observation history from iNaturalist
14 downloads this week ⭐ 2
Latest: 0.2.1 on 22nd October 2020
datasette-clone
Create a local copy of database files from a Datasette instance
26 downloads this week ⭐ 1
Latest: 0.5 on 22nd July 2020