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

25,041 downloads this week        ⭐ 827

Screenshot of simonw/sqlite-utils

Latest: on 2nd May 2022

csvs-to-sqlite by simonw

Convert CSV files into a SQLite database

511 downloads this week        ⭐ 655

Latest: on 18th November 2021

shot-scraper by simonw

Tools for taking automated screenshots of websites

1,713 downloads this week        ⭐ 510

Screenshot of simonw/shot-scraper

Latest: on 18th April 2022

django-sql-dashboard by simonw

Django app for building dashboards using raw SQL queries

591 downloads this week        ⭐ 335

Screenshot of simonw/django-sql-dashboard

Latest: on 20th April 2022

twitter-to-sqlite by dogsheep

Save data from Twitter to a SQLite database

52 downloads this week        ⭐ 269

Latest: on 21st September 2021

db-to-sqlite by simonw

CLI tool for exporting tables or queries from any SQL database to a SQLite file

149 downloads this week        ⭐ 226

Latest: on 11th June 2021

geocode-sqlite by eyeseast

Geocode rows in a SQLite database table

63 downloads this week        ⭐ 218

Latest: on 16th March 2022

github-to-sqlite by dogsheep

Save data from GitHub to a SQLite database

50 downloads this week        ⭐ 180

Screenshot of dogsheep/github-to-sqlite

Latest: on 1st December 2021

csv-diff by simonw

Python CLI tool and library for diffing CSV and JSON files

3,471 downloads this week        ⭐ 140

Latest: on 23rd February 2021

dogsheep-photos by dogsheep

Upload your photos to S3 and import metadata about them into a SQLite database

8 downloads this week        ⭐ 124

Latest: on 25th May 2020

s3-credentials by simonw

A tool for creating credentials for accessing S3 buckets

100 downloads this week        ⭐ 110

Latest: on 1st May 2022

git-history by simonw

Tools for analyzing Git history using SQLite

922 downloads this week        ⭐ 92

Latest: on 8th December 2021

healthkit-to-sqlite by dogsheep

Convert an Apple Healthkit export zip to a SQLite database

13 downloads this week        ⭐ 91

Latest: on 20th 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

88 downloads this week        ⭐ 78

Latest: on 13th June 2021

datasette-app by simonw

The Datasette macOS application

⭐ 69

Screenshot of simonw/datasette-app

google-takeout-to-sqlite by dogsheep

Save data from Google Takeout to a SQLite database

4 downloads this week        ⭐ 51

Latest: on 8th September 2019

markdown-to-sqlite by simonw

CLI tool for loading markdown files into a SQLite database

13 downloads this week        ⭐ 49

Latest: on 13th June 2021

pocket-to-sqlite by dogsheep

Create a SQLite database containing data from your Pocket account

17 downloads this week        ⭐ 49

Latest: on 22nd October 2020

swarm-to-sqlite by dogsheep

Create a SQLite database containing your checkin history from Foursquare Swarm

8 downloads this week        ⭐ 37

Latest: on 18th January 2021

yaml-to-sqlite by simonw

Utility for converting YAML files to SQLite

12 downloads this week        ⭐ 36

Latest: on 13th June 2021

geojson-to-sqlite by simonw

CLI tool for converting GeoJSON files to SQLite (with SpatiaLite)

66 downloads this week        ⭐ 34

Latest: on 13th April 2022

airtable-export by simonw

Export Airtable data to YAML, JSON or SQLite files on disk

77 downloads this week        ⭐ 33

Latest: on 9th April 2021

sqlite-transform by simonw

Tool for running transformations on columns in a SQLite database

49 downloads this week        ⭐ 29

Latest: on 2nd August 2021

hacker-news-to-sqlite by dogsheep

Create a SQLite database containing data pulled from Hacker News

20 downloads this week        ⭐ 25

Latest: on 13th March 2021

dbf-to-sqlite by simonw

CLI tool for converting DBF files (dBase, FoxPro etc) to SQLite

10 downloads this week        ⭐ 25

Latest: on 31st January 2019

sqlite-diffable by simonw

Tools for dumping/loading a SQLite database to diffable directory structure

611 downloads this week        ⭐ 24

Latest: on 21st February 2022

evernote-to-sqlite by dogsheep

Tools for converting Evernote content to SQLite

33 downloads this week        ⭐ 24

Latest: on 26th August 2021

sqlite-generate by simonw

Tool for generating demo SQLite databases

41 downloads this week        ⭐ 17

Latest: on 23rd June 2020

shapefile-to-sqlite by simonw

Load shapefiles into a SQLite (optionally SpatiaLite) database

25 downloads this week        ⭐ 15

Latest: on 23rd August 2020

genome-to-sqlite by dogsheep

Import your genome into a SQLite database

2 downloads this week        ⭐ 13

Latest: on 19th September 2019

google-drive-to-sqlite by simonw

Create a SQLite database containing metadata from Google Drive

15 downloads this week        ⭐ 12

Latest: on 20th February 2022

download-tiles by simonw

Download map tiles and store them in an MBTiles database

23 downloads this week        ⭐ 9

Latest: on 16th February 2021

tableau-to-sqlite by simonw

Fetch data from Tableau into a SQLite database

39 downloads this week        ⭐ 8

Latest: on 22nd March 2021

fec-to-sqlite by simonw

Save FEC campaign finance data to a SQLite database

5 downloads this week        ⭐ 8

Latest: on 7th March 2020

pypi-to-sqlite by simonw

Load data about Python packages from PyPI into SQLite

29 downloads this week        ⭐ 2

Latest: on 8th April 2022

sphinx-to-sqlite by simonw

Create a SQLite database from Sphinx documentation

3 downloads this week        ⭐ 2

Latest: on 22nd October 2020

inaturalist-to-sqlite by dogsheep

Create a SQLite database containing your observation history from iNaturalist

⭐ 2

Latest: on 22nd October 2020

datasette-clone by simonw

Create a local copy of database files from a Datasette instance

19 downloads this week        ⭐ 2

Latest: on 22nd July 2020