repos

29 rows where topics contains "datasette-tool"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: owner, homepage, size, stargazers_count, watchers_count, has_projects, has_wiki, forks_count, archived, open_issues_count, topics, forks, open_issues, watchers, default_branch, created_at (date), updated_at (date), pushed_at (date), topics (array)

id ▼ node_id name full_name private owner html_url description fork created_at updated_at pushed_at homepage size stargazers_count watchers_count language has_issues has_projects has_downloads has_wiki has_pages has_discussions forks_count archived disabled open_issues_count license allow_forking is_template web_commit_signoff_required topics visibility forks open_issues watchers default_branch organization
110509816 MDEwOlJlcG9zaXRvcnkxMTA1MDk4MTY= csvs-to-sqlite simonw/csvs-to-sqlite 0 simonw 9599 https://github.com/simonw/csvs-to-sqlite Convert CSV files into a SQLite database 0 2017-11-13T06:38:21Z 2024-01-24T03:05:21Z 2023-12-27T11:39:54Z   145 846 846 Python 1 1 1 1 0 0 70 0 0 48 Apache License 2.0 apache-2.0 1 0 0 ["click", "csv", "datasette", "datasette-io", "datasette-tool", "pandas", "python", "sqlite"] public 70 48 846 main  
140912432 MDEwOlJlcG9zaXRvcnkxNDA5MTI0MzI= sqlite-utils simonw/sqlite-utils 0 simonw 9599 https://github.com/simonw/sqlite-utils Python CLI utility and library for manipulating SQLite databases 0 2018-07-14T03:21:46Z 2024-01-26T10:04:31Z 2024-01-14T17:28:25Z https://sqlite-utils.datasette.io 1781 1393 1393 Python 1 1 1 0 0 0 101 0 0 95 Apache License 2.0 apache-2.0 1 0 0 ["cli", "click", "datasette", "datasette-io", "datasette-tool", "python", "sqlite", "sqlite-database"] public 101 95 1393 main  
166159072 MDEwOlJlcG9zaXRvcnkxNjYxNTkwNzI= db-to-sqlite simonw/db-to-sqlite 0 simonw 9599 https://github.com/simonw/db-to-sqlite CLI tool for exporting tables or queries from any SQL database to a SQLite file 0 2019-01-17T04:16:48Z 2024-01-22T12:09:02Z 2023-02-28T07:16:21Z   72 329 329 Python 1 1 1 1 0 0 27 0 0 17 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "sqlalchemy", "sqlite"] public 27 17 329 main  
167759846 MDEwOlJlcG9zaXRvcnkxNjc3NTk4NDY= markdown-to-sqlite simonw/markdown-to-sqlite 0 simonw 9599 https://github.com/simonw/markdown-to-sqlite CLI tool for loading markdown files into a SQLite database 0 2019-01-27T02:04:54Z 2024-01-05T12:52:52Z 2022-05-13T18:09:22Z   13 72 72 Python 1 1 1 1 0 0 3 0 0 2 Apache License 2.0 apache-2.0 1 0 0 ["datasette-io", "datasette-tool", "markdown", "sqlite", "yaml"] public 3 2 72 main  
168474970 MDEwOlJlcG9zaXRvcnkxNjg0NzQ5NzA= dbf-to-sqlite simonw/dbf-to-sqlite 0 simonw 9599 https://github.com/simonw/dbf-to-sqlite CLI tool for converting DBF files (dBase, FoxPro etc) to SQLite 0 2019-01-31T06:30:46Z 2023-12-26T20:38:21Z 2022-06-30T19:34:07Z   8 42 42 Python 1 1 1 1 0 0 12 0 0 5 Apache License 2.0 apache-2.0 1 0 0 ["datasette-io", "datasette-tool", "dbase", "dbf", "foxpro", "sqlite"] public 12 5 42 master  
175550127 MDEwOlJlcG9zaXRvcnkxNzU1NTAxMjc= yaml-to-sqlite simonw/yaml-to-sqlite 0 simonw 9599 https://github.com/simonw/yaml-to-sqlite Utility for converting YAML files to SQLite 0 2019-03-14T04:49:08Z 2023-10-20T09:19:10Z 2022-04-08T18:11:14Z   19 68 68 Python 1 1 1 1 0 0 9 0 0 3 Apache License 2.0 apache-2.0 1 0 0 ["datasette-io", "datasette-tool", "sqlite", "yaml"] public 9 3 68 main  
195145678 MDEwOlJlcG9zaXRvcnkxOTUxNDU2Nzg= sqlite-diffable simonw/sqlite-diffable 0 simonw 9599 https://github.com/simonw/sqlite-diffable Tools for dumping/loading a SQLite database to diffable directory structure 0 2019-07-04T00:58:46Z 2023-12-13T11:09:03Z 2022-08-18T22:49:29Z   30 88 88 Python 1 1 1 1 0 0 3 0 0 4 Apache License 2.0 apache-2.0 1 0 0 ["datasette-io", "datasette-tool", "sqlite"] public 3 4 88 main  
197431109 MDEwOlJlcG9zaXRvcnkxOTc0MzExMDk= dogsheep-beta dogsheep/dogsheep-beta 0 dogsheep 53015001 https://github.com/dogsheep/dogsheep-beta Build a search index across content from multiple SQLite database tables and run faceted searches against it using Datasette 0 2019-07-17T17:07:26Z 2024-01-25T12:20:58Z 2021-09-03T17:47:45Z https://dogsheep.github.io/ 61 176 176 Python 1 0 1 0 0 0 6 0 0 15   1 0 0 ["datasette", "datasette-io", "datasette-plugin", "datasette-tool", "dogsheep", "search"] public 6 15 176 main  
197882382 MDEwOlJlcG9zaXRvcnkxOTc4ODIzODI= healthkit-to-sqlite dogsheep/healthkit-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/healthkit-to-sqlite Convert an Apple Healthkit export zip to a SQLite database 0 2019-07-20T05:03:12Z 2024-01-22T12:33:18Z 2023-01-01T17:29:57Z https://datasette.io/tools/healthkit-to-sqlite 29 182 182 Python 1 1 1 1 0 0 7 0 0 12 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "healthkit", "sqlite"] public 7 12 182 main  
205429375 MDEwOlJlcG9zaXRvcnkyMDU0MjkzNzU= swarm-to-sqlite dogsheep/swarm-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/swarm-to-sqlite Create a SQLite database containing your checkin history from Foursquare Swarm 0 2019-08-30T17:37:29Z 2024-01-11T15:23:44Z 2023-04-11T03:18:16Z   34 56 56 Python 1 1 1 1 0 0 3 0 0 4 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "foursquare", "foursquare-api", "sqlite", "swarm"] public 3 4 56 main  
206156866 MDEwOlJlcG9zaXRvcnkyMDYxNTY4NjY= twitter-to-sqlite dogsheep/twitter-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/twitter-to-sqlite Save data from Twitter to a SQLite database 0 2019-09-03T19:30:08Z 2024-01-14T00:00:20Z 2022-12-28T23:33:31Z   307 391 391 Python 1 1 1 1 0 0 22 0 0 20 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite", "twitter", "twitter-api"] public 22 20 391 main  
206202864 MDEwOlJlcG9zaXRvcnkyMDYyMDI4NjQ= inaturalist-to-sqlite dogsheep/inaturalist-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/inaturalist-to-sqlite Create a SQLite database containing your observation history from iNaturalist 0 2019-09-04T01:21:21Z 2023-06-08T10:00:25Z 2020-10-22T00:08:58Z   17 6 6 Python 1 1 1 1 0 0 0 0 0 2 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "inaturalist", "sqlite"] public 0 2 6 master  
206649770 MDEwOlJlcG9zaXRvcnkyMDY2NDk3NzA= google-takeout-to-sqlite dogsheep/google-takeout-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/google-takeout-to-sqlite Save data from Google Takeout to a SQLite database 0 2019-09-05T20:15:15Z 2024-01-22T12:33:23Z 2023-09-06T17:59:16Z   14 87 87 Python 1 1 1 1 0 0 8 0 0 13 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "google", "sqlite"] public 8 13 87 master  
207052882 MDEwOlJlcG9zaXRvcnkyMDcwNTI4ODI= github-to-sqlite dogsheep/github-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/github-to-sqlite Save data from GitHub to a SQLite database 0 2019-09-08T02:50:28Z 2024-01-24T01:41:51Z 2024-01-15T05:56:13Z https://github-to-sqlite.dogsheep.net/ 143 363 363 Python 1 1 1 1 0 0 41 0 0 25 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "github-api", "sqlite"] public 41 25 363 main  
209590345 MDEwOlJlcG9zaXRvcnkyMDk1OTAzNDU= genome-to-sqlite dogsheep/genome-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/genome-to-sqlite Import your genome into a SQLite database 0 2019-09-19T15:38:39Z 2023-10-07T13:11:49Z 2019-09-19T15:41:17Z   9 20 20 Python 1 1 1 1 0 0 1 0 0 2 Apache License 2.0 apache-2.0 1 0 0 ["23andme", "datasette", "datasette-io", "datasette-tool", "dogsheep", "genetics", "personal-analytics", "sqlite"] public 1 2 20 master  
213286752 MDEwOlJlcG9zaXRvcnkyMTMyODY3NTI= pocket-to-sqlite dogsheep/pocket-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/pocket-to-sqlite Create a SQLite database containing data from your Pocket account 0 2019-10-07T03:24:14Z 2024-01-15T17:53:41Z 2023-07-10T19:24:26Z   25 98 98 Python 1 1 1 1 0 0 5 0 0 5 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "pocket", "pocket-api", "sqlite"] public 5 5 98 main  
219372133 MDEwOlJlcG9zaXRvcnkyMTkzNzIxMzM= sqlite-transform simonw/sqlite-transform 0 simonw 9599 https://github.com/simonw/sqlite-transform Tool for running transformations on columns in a SQLite database 0 2019-11-03T22:07:53Z 2023-01-28T07:04:45Z 2021-08-02T22:07:57Z   64 30 30 Python 1 1 1 1 0 0 0 1 0 0 Apache License 2.0 apache-2.0 1 0 0 ["datasette-io", "datasette-tool", "sqlite"] public 0 0 30 main  
237321267 MDEwOlJlcG9zaXRvcnkyMzczMjEyNjc= geojson-to-sqlite simonw/geojson-to-sqlite 0 simonw 9599 https://github.com/simonw/geojson-to-sqlite CLI tool for converting GeoJSON files to SQLite (with SpatiaLite) 0 2020-01-30T22:51:05Z 2024-01-12T20:42:05Z 2022-04-13T23:39:25Z   117 50 50 Python 1 1 1 1 0 0 5 0 0 4 Apache License 2.0 apache-2.0 1 0 0 ["datasette-io", "datasette-tool", "geojson", "gis", "sqlite"] public 5 4 50 main  
240815938 MDEwOlJlcG9zaXRvcnkyNDA4MTU5Mzg= shapefile-to-sqlite simonw/shapefile-to-sqlite 0 simonw 9599 https://github.com/simonw/shapefile-to-sqlite Load shapefiles into a SQLite (optionally SpatiaLite) database 0 2020-02-16T01:55:29Z 2024-01-13T01:52:47Z 2023-01-08T20:24:46Z   61 27 27 Python 1 1 1 1 0 0 3 0 0 4 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "gis", "shapefiles", "spatialite", "sqlite"] public 3 4 27 main  
245670670 MDEwOlJlcG9zaXRvcnkyNDU2NzA2NzA= fec-to-sqlite simonw/fec-to-sqlite 0 simonw 9599 https://github.com/simonw/fec-to-sqlite Save FEC campaign finance data to a SQLite database 0 2020-03-07T16:52:49Z 2023-08-10T17:00:54Z 2023-08-10T17:00:47Z   17 9 9 Python 1 1 1 1 0 0 0 0 0 1 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "fec", "sqlite"] public 0 1 9 master  
248903544 MDEwOlJlcG9zaXRvcnkyNDg5MDM1NDQ= hacker-news-to-sqlite dogsheep/hacker-news-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/hacker-news-to-sqlite Create a SQLite database containing data pulled from Hacker News 0 2020-03-21T04:02:05Z 2023-08-06T05:38:49Z 2023-03-26T22:22:39Z   19 43 43 Python 1 1 1 1 0 0 5 0 0 5 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "hacker-news"] public 5 5 43 main  
255460347 MDEwOlJlcG9zaXRvcnkyNTU0NjAzNDc= datasette-clone simonw/datasette-clone 0 simonw 9599 https://github.com/simonw/datasette-clone Create a local copy of database files from a Datasette instance 0 2020-04-13T23:05:41Z 2023-09-21T04:26:56Z 2021-02-22T19:32:36Z   20 6 6 Python 1 1 1 1 0 0 0 0 0 0 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool"] public 0 0 6 main  
256834907 MDEwOlJlcG9zaXRvcnkyNTY4MzQ5MDc= dogsheep-photos dogsheep/dogsheep-photos 0 dogsheep 53015001 https://github.com/dogsheep/dogsheep-photos Upload your photos to S3 and import metadata about them into a SQLite database 0 2020-04-18T19:22:13Z 2024-01-22T12:00:59Z 2024-01-05T18:52:26Z   68 169 169 Python 1 1 1 1 0 0 15 0 0 22 Apache License 2.0 apache-2.0 1 0 0 ["datasette", "datasette-io", "datasette-tool", "dogsheep", "sqlite"] public 15 22 169 master  
274264484 MDEwOlJlcG9zaXRvcnkyNzQyNjQ0ODQ= sqlite-generate simonw/sqlite-generate 0 simonw 9599 https://github.com/simonw/sqlite-generate Tool for generating demo SQLite databases 0 2020-06-22T23:36:44Z 2023-10-27T22:48:17Z 2021-02-27T15:25:24Z https://sqlite-generate-demo.datasette.io/ 56 22 22 Python 1 1 1 1 0 0 0 0 0 0 Apache License 2.0 apache-2.0 1 0 0 ["datasette-io", "datasette-tool", "sqlite"] public 0 0 22 main  
303218369 MDEwOlJlcG9zaXRvcnkzMDMyMTgzNjk= evernote-to-sqlite dogsheep/evernote-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/evernote-to-sqlite Tools for converting Evernote content to SQLite 0 2020-10-11T21:45:49Z 2023-06-26T01:36:28Z 2021-11-02T20:04:32Z   51 35 35 Python 1 1 1 1 0 0 5 0 0 6 Apache License 2.0 apache-2.0 1 0 0 ["datasette-io", "datasette-tool", "dogsheep", "evernote", "sqlite"] public 5 6 35 main  
305199661 MDEwOlJlcG9zaXRvcnkzMDUxOTk2NjE= sphinx-to-sqlite simonw/sphinx-to-sqlite 0 simonw 9599 https://github.com/simonw/sphinx-to-sqlite Create a SQLite database from Sphinx documentation 0 2020-10-18T21:26:55Z 2023-07-14T19:47:31Z 2020-10-22T04:55:45Z   9 6 6 Python 1 1 1 1 0 0 0 0 0 2 Apache License 2.0 apache-2.0 1 0 0 ["datasette-io", "datasette-tool", "sphinx", "sqlite"] public 0 2 6 main  
346597557 MDEwOlJlcG9zaXRvcnkzNDY1OTc1NTc= tableau-to-sqlite simonw/tableau-to-sqlite 0 simonw 9599 https://github.com/simonw/tableau-to-sqlite Fetch data from Tableau into a SQLite database 0 2021-03-11T06:12:02Z 2023-09-08T18:19:38Z 2021-07-29T13:56:42Z   212 9 9 Python 1 1 1 1 0 0 2 0 0 2 Apache License 2.0 apache-2.0 1 0 0 ["datasette-io", "datasette-tool"] public 2 2 9 main  
347263722 MDEwOlJlcG9zaXRvcnkzNDcyNjM3MjI= django-sql-dashboard simonw/django-sql-dashboard 0 simonw 9599 https://github.com/simonw/django-sql-dashboard Django app for building dashboards using raw SQL queries 0 2021-03-13T03:38:23Z 2024-01-27T03:25:26Z 2023-12-16T07:03:32Z https://django-sql-dashboard.datasette.io/ 346 425 425 Python 1 1 1 1 0 0 35 0 0 31 Apache License 2.0 apache-2.0 1 0 0 ["dashboards", "datasette-io", "datasette-tool", "django", "sql"] public 35 31 425 main  
611552758 R_kgDOJHON9g apple-notes-to-sqlite dogsheep/apple-notes-to-sqlite 0 dogsheep 53015001 https://github.com/dogsheep/apple-notes-to-sqlite Export Apple Notes to SQLite 0 2023-03-09T03:44:10Z 2024-01-25T08:38:14Z 2023-09-04T23:48:28Z   21 161 161 Python 1 1 1 1 0 0 5 0 0 8 Apache License 2.0 apache-2.0 1 0 0 ["apple-notes", "datasette", "datasette-tool", "dogsheep", "sqlite"] public 5 8 161 main  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "repos" (
   [id] INTEGER PRIMARY KEY,
   [node_id] TEXT,
   [name] TEXT,
   [full_name] TEXT,
   [private] INTEGER,
   [owner] INTEGER REFERENCES [users]([id]),
   [html_url] TEXT,
   [description] TEXT,
   [fork] INTEGER,
   [created_at] TEXT,
   [updated_at] TEXT,
   [pushed_at] TEXT,
   [homepage] TEXT,
   [size] INTEGER,
   [stargazers_count] INTEGER,
   [watchers_count] INTEGER,
   [language] TEXT,
   [has_issues] INTEGER,
   [has_projects] INTEGER,
   [has_downloads] INTEGER,
   [has_wiki] INTEGER,
   [has_pages] INTEGER,
   [has_discussions] INTEGER,
   [forks_count] INTEGER,
   [archived] INTEGER,
   [disabled] INTEGER,
   [open_issues_count] INTEGER,
   [license] TEXT REFERENCES [licenses]([key]),
   [allow_forking] INTEGER,
   [is_template] INTEGER,
   [web_commit_signoff_required] INTEGER,
   [topics] TEXT,
   [visibility] TEXT,
   [forks] INTEGER,
   [open_issues] INTEGER,
   [watchers] INTEGER,
   [default_branch] TEXT,
   [organization] INTEGER REFERENCES [users]([id])
);
CREATE INDEX [idx_repos_organization]
    ON [repos] ([organization]);
CREATE INDEX [idx_repos_license]
    ON [repos] ([license]);
CREATE INDEX [idx_repos_owner]
    ON [repos] ([owner]);