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.
See also 21 results in plugins
sqlite-utils by simonw
Python CLI utility and library for manipulating SQLite databases
⭐ 1817
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
openai-to-sqlite by simonw
Save OpenAI API results to a SQLite database
⭐ 232
Latest: 0.4.2 on 17th 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
github-to-sqlite by dogsheep
Save data from GitHub to a SQLite database
⭐ 423
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
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
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
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
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
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