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

Python CLI utility and library for manipulating SQLite databases

19,031 downloads this week        ⭐ 559

Screenshot of simonw/sqlite-utils

Latest: 3.17.1 on 22nd September 2021

twitter-to-sqlite

Save data from Twitter to a SQLite database

310 downloads this week        ⭐ 253

Latest: 0.22 on 21st September 2021

datasette-app

The Datasette macOS application

⭐ 55

Screenshot of simonw/datasette-app

Latest: 0.2.1 on 13th September 2021

evernote-to-sqlite

Tools for converting Evernote content to SQLite

48 downloads this week        ⭐ 24

Latest: 0.3.2 on 26th August 2021

healthkit-to-sqlite

Convert an Apple Healthkit export zip to a SQLite database

95 downloads this week        ⭐ 91

Latest: 1.0.1 on 20th August 2021

sqlite-transform

Tool for running transformations on columns in a SQLite database

76 downloads this week        ⭐ 29

Latest: 1.2.1 on 2nd August 2021

django-sql-dashboard

Django app for building dashboards using raw SQL queries

536 downloads this week        ⭐ 272

Screenshot of simonw/django-sql-dashboard

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

187 downloads this week        ⭐ 78

Latest: 0.10.2 on 13th June 2021

yaml-to-sqlite

Utility for converting YAML files to SQLite

35 downloads this week        ⭐ 36

Latest: 1.0 on 13th June 2021

markdown-to-sqlite

CLI tool for loading markdown files into a SQLite database

65 downloads this week        ⭐ 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

199 downloads this week        ⭐ 226

Latest: 1.4 on 11th June 2021

geojson-to-sqlite

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

54 downloads this week        ⭐ 28

Latest: 0.3.1 on 20th May 2021

airtable-export

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

121 downloads this week        ⭐ 33

Latest: 0.7.1 on 9th April 2021

tableau-to-sqlite

Fetch data from Tableau into a SQLite database

55 downloads this week        ⭐ 8

Latest: 0.2.1 on 22nd March 2021

hacker-news-to-sqlite

Create a SQLite database containing data pulled from Hacker News

42 downloads this week        ⭐ 25

Latest: 0.4 on 13th March 2021

csv-diff

Python CLI tool and library for diffing CSV and JSON files

4,601 downloads this week        ⭐ 140

Latest: 1.1 on 23rd February 2021

download-tiles

Download map tiles and store them in an MBTiles database

57 downloads this week        ⭐ 9

Latest: 0.4.1 on 16th February 2021

swarm-to-sqlite

Create a SQLite database containing your checkin history from Foursquare Swarm

33 downloads this week        ⭐ 37

Latest: 0.3.3 on 18th January 2021

github-to-sqlite

Save data from GitHub to a SQLite database

133 downloads this week        ⭐ 147

Screenshot of dogsheep/github-to-sqlite

Latest: 2.8.2 on 16th December 2020

csvs-to-sqlite

Convert CSV files into a SQLite database

459 downloads this week        ⭐ 612

Latest: 1.2 on 3rd November 2020

sphinx-to-sqlite

Create a SQLite database from Sphinx documentation

13 downloads this week        ⭐ 2

Latest: 0.1a1 on 22nd October 2020

inaturalist-to-sqlite

Create a SQLite database containing your observation history from iNaturalist

30 downloads this week        ⭐ 2

Latest: 0.2.1 on 22nd October 2020

pocket-to-sqlite

Create a SQLite database containing data from your Pocket account

23 downloads this week        ⭐ 49

Latest: 0.2.1 on 22nd October 2020

shapefile-to-sqlite

Load shapefiles into a SQLite (optionally SpatiaLite) database

93 downloads this week        ⭐ 15

Latest: 0.4.1 on 23rd August 2020

datasette-clone

Create a local copy of database files from a Datasette instance

41 downloads this week        ⭐ 2

Latest: 0.5 on 22nd July 2020

sqlite-generate

Tool for generating demo SQLite databases

65 downloads this week        ⭐ 17

Latest: 1.1.1 on 23rd June 2020

dogsheep-photos

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

13 downloads this week        ⭐ 116

Latest: 0.4.1 on 25th May 2020

fec-to-sqlite

Save FEC campaign finance data to a SQLite database

16 downloads this week        ⭐ 8

Latest: 0.2 on 7th March 2020

genome-to-sqlite

Import your genome into a SQLite database

4 downloads this week        ⭐ 13

Latest: 0.1 on 19th September 2019

sqlite-diffable

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

132 downloads this week        ⭐ 20

Latest: 0.2 on 4th July 2019