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 stars · downloads this week · last released

sqlite-utils

Python CLI utility and library for manipulating SQLite databases

2,829 downloads this week        ⭐ 323

Screenshot of simonw/sqlite-utils

Latest: 3.3 on 18th January 2021

csvs-to-sqlite

Convert CSV files into a SQLite database

185 downloads this week        ⭐ 535

Latest: 1.2 on 3rd November 2020

github-to-sqlite

Save data from GitHub to a SQLite database

126 downloads this week        ⭐ 93

Screenshot of dogsheep/github-to-sqlite

Latest: 2.8.2 on 16th December 2020

dogsheep-beta

Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette

75 downloads this week        ⭐ 44

Latest: 0.10.1 on 19th December 2020

twitter-to-sqlite

Save data from Twitter to a SQLite database

70 downloads this week        ⭐ 173

Latest: 0.21.3 on 23rd July 2020

sqlite-generate

Tool for generating demo SQLite databases

69 downloads this week        ⭐ 15

Latest: 1.1.1 on 23rd June 2020

db-to-sqlite

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

63 downloads this week        ⭐ 206

Latest: 1.3 on 27th July 2020

swarm-to-sqlite

Create a SQLite database containing your checkin history from Foursquare Swarm

58 downloads this week        ⭐ 35

Latest: 0.3.3 on 18th January 2021

shapefile-to-sqlite

Load shapefiles into a SQLite (optionally SpatiaLite) database

46 downloads this week        ⭐ 11

Latest: 0.4.1 on 23rd August 2020

yaml-to-sqlite

Utility for converting YAML files to SQLite

37 downloads this week        ⭐ 29

Latest: 0.3.1 on 7th December 2020

sqlite-transform

Tool for running transformations on columns in a SQLite database

35 downloads this week        ⭐ 8

Latest: 0.3.1 on 18th January 2021

sphinx-to-sqlite

Create a SQLite database from Sphinx documentation

26 downloads this week        ⭐ 2

Latest: 0.1a1 on 22nd October 2020

healthkit-to-sqlite

Convert an Apple Healthkit export zip to a SQLite database

25 downloads this week        ⭐ 64

Latest: 1.0 on 17th October 2020

evernote-to-sqlite

Tools for converting Evernote content to SQLite

24 downloads this week        ⭐ 12

Latest: 0.2 on 12th October 2020

markdown-to-sqlite

CLI tool for loading markdown files into a SQLite database

20 downloads this week        ⭐ 26

Latest: 0.2 on 14th January 2021

pocket-to-sqlite

Create a SQLite database containing data from your Pocket account

16 downloads this week        ⭐ 30

Latest: 0.2.1 on 22nd October 2020

geojson-to-sqlite

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

15 downloads this week        ⭐ 17

Latest: 0.2 on 11th February 2020

sqlite-diffable

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

15 downloads this week        ⭐ 14

Latest: 0.2 on 4th July 2019

dogsheep-photos

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

10 downloads this week        ⭐ 89

Latest: 0.4.1 on 25th May 2020

hacker-news-to-sqlite

Create a SQLite database containing data pulled from Hacker News

8 downloads this week        ⭐ 19

Latest: 0.3.1 on 21st March 2020

fec-to-sqlite

Save FEC campaign finance data to a SQLite database

6 downloads this week        ⭐ 8

Latest: 0.2 on 7th March 2020

inaturalist-to-sqlite

Create a SQLite database containing your observation history from iNaturalist

5 downloads this week        ⭐ 2

Latest: 0.2.1 on 22nd October 2020

genome-to-sqlite

Import your genome into a SQLite database

5 downloads this week        ⭐ 11

Latest: 0.1 on 19th September 2019