https://github.com/simonw/sqlite-utils

cli click datasette datasette-io datasette-tool python sqlite sqlite-database

Score: 25.56748286976763

Last synced: about 21 hours ago
JSON representation

Repository metadata:

Python CLI utility and library for manipulating SQLite databases

Host: GitHub
URL: https://github.com/simonw/sqlite-utils
Owner: simonw
License: apache-2.0
Created: 2018-07-14T03:21:46.000Z (over 8 years ago)
Default Branch: main
Last Pushed: 2026-10-11T00:15:55.000Z (23 days ago)
Last Synced: 2026-10-27T09:53:32.595Z (6 days ago)
Topics: cli, click, datasette, datasette-io, datasette-tool, python, sqlite, sqlite-database
Language: Python
Homepage: https://sqlite-utils.datasette.io
Size: 1.97 MB
Stars: 2,180
Watchers: 22
Forks: 205
Open Issues: 161
Metadata Files:
- Readme: README.md
- Contributing: docs/contributing.rst
- Funding: .github/FUNDING.yml
- License: LICENSE
Funding:
- Github: simonw

Owner metadata:

Name: Simon Willison
Login: simonw
Email:
Kind: user
Description:
Website: https://simonwillison.net/
Location: Half Moon Bay, CA
Twitter: simonw
Company: Datasette
Icon url: https://avatars.githubusercontent.com/u/9599?u=b14820695cc6ae03f8a831990697bc040596c0f4&v=4
Repositories: 744
Last Synced at: 2024-05-01T10:38:17.142Z
Profile URL: https://github.com/simonw

GitHub Events

Total

Create event: 22
Delete event: 11
Fork event: 19
Issue comment event: 94
Issues event: 54
Pull request event: 29
Pull request review comment event: 9
Pull request review event: 12
Push event: 160
Release event: 4
Watch event: 251
Total: 665

Last Year

Create event: 15
Delete event: 7
Fork event: 10
Issue comment event: 33
Issues event: 27
Pull request event: 20
Pull request review comment event: 5
Pull request review event: 7
Push event: 115
Watch event: 42
Total: 281

Committers metadata

Last synced: 2 days ago

Total Commits: 1,198
Total Committers: 55
Avg Commits per committer: 21.782
Development Distribution Score (DDS): 0.111

Commits in past year: 196
Committers in past year: 13
Avg Commits per committer in past year: 15.077
Development Distribution Score (DDS) in past year: 0.245

Name	Email	Commits
Simon Willison	s**n@g**m	1065
Simon Willison	s**w@e**m	38
Claude	n**y@a**m	33
Chris Amico	e**t@g**m	4
Rami Abdelrazzaq	r**q@g**m	3
Simon Wiles	s**s@g**m	3
fry69	1****9	2
ikatyal2110	1****0	2
Thomas Sibley	t**m@z**g	2
Adam Wolf	a**f@f**m	1
John Vandenberg	j**b@g**m	1
Jeff Triplett	j****t	1
Jacob Chapman	7****d	1
Harald Nezbeda	h**n@n**m	1
Gert Goet	g**t@t**l	1
Gavin Wahl	g**l@g**m	1
Forest Gregg	f****g	1
Edward Betts	e**d@4**m	1
Dylan Wu	6****u	1
Alex Chan	a**x@a**t	1
Alex Garcia	a**a@g**m	1
Amjith Ramanujam	a**r@g**m	1
Andreas Madsack	a**s@m**e	1
Benson Muite	b****t	1
Bunlong Heng	b**e@g**m	1
Copilot	1****t	1
Damien Ready	d**y@g**m	1
David	1****y	1
rhoboro	r**o@g**m	1
nyxst4ck	n**k@g**m	1
and 25 more...

Issue and Pull Request metadata

Last synced: about 21 hours ago

Total issues: 233
Total pull requests: 197
Average time to close issues: 8 months
Average time to close pull requests: about 2 months
Total issue authors: 77
Total pull request authors: 85
Average comments per issue: 3.05
Average comments per pull request: 1.42
Merged pull request: 77
Bot issues: 0
Bot pull requests: 0

Past year issues: 45
Past year pull requests: 135
Past year average time to close issues: about 1 month
Past year average time to close pull requests: 22 days
Past year issue authors: 18
Past year pull request authors: 58
Past year average comments per issue: 0.93
Past year average comments per pull request: 0.7
Past year merged pull request: 33
Past year bot issues: 0
Past year bot pull requests: 0

More stats: https://issues.ecosyste.ms/repositories/lookup?url=https://github.com/simonw/sqlite-utils

Top Issue Authors

simonw (126)
chapmanjacobd (11)
ikatyal2110 (5)
feiiiiii5 (4)
glaziermag (4)
fgregg (4)
saeedesmaili (3)
tobych (2)
xavdid (2)
asg017 (2)
mcarpenter (2)
mhalle (2)
alexwlchan (2)
ArsTapatun (1)
kristomi (1)

Top Pull Request Authors

simonw (53)
ikatyal2110 (20)
KooshaPari (10)
RamiNoodle733 (5)
harsh-thakkar7 (4)
chapmanjacobd (4)
SAY-5 (3)
c-tonneslan (3)
ChrisJr404 (3)
feiiiiii5 (3)
eval (2)
kbaikov (2)
parkergurney (2)
matdmiller (2)
JOhnsonKC201 (2)

Top Issue Labels

enhancement (79)
bug (45)
cli-tool (31)
python-library (26)
transform (25)
documentation (21)
ci (15)
plugins (9)
research (8)
help wanted (7)
refactor (3)
design (3)
question (2)
spatialite (2)
breaking-change-for-v5 (1)
wontfix (1)
duplicate (1)

Top Pull Request Labels

enhancement (15)
ci (4)
bug (3)
python-library (3)
documentation (2)
cli-tool (1)

Package metadata

Total packages: 26
Total downloads:
- conda: 98,591 total
- pypi: 887,326 last-month
- homebrew: 74 last-month
Total docker downloads: 48
Total dependent packages: 132 (may contain duplicates)
Total dependent repositories: 221 (may contain duplicates)
Total versions: 215
Total maintainers: 3

nixpkgs-23.05: python311Packages.sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-23.05/pkgs/development/python-modules/sqlite-utils/default.nix#L50
Licenses: Apache-2.0
Latest release: 3.31 (published 9 months ago)
Last Synced: 2026-08-14T07:30:01.102Z (3 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 1.175%
- Stargazers count: 2.018%
- Forks count: 2.684%
Maintainers (2)
- techknowlogick
- meatcar

nixpkgs-23.11: sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-23.11/pkgs/development/python-modules/sqlite-utils/default.nix#L58
Licenses: Apache-2.0
Latest release: 3.35.2 (published 9 months ago)
Last Synced: 2026-08-15T11:31:20.373Z (3 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 1.369%
- Stargazers count: 2.378%
- Forks count: 3.1%
Maintainers (2)
- techknowlogick
- meatcar

pypi.org: sqlite-utils

CLI tool and Python library for manipulating SQLite databases

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://sqlite-utils.datasette.io/en/stable/
Licenses: Apache-2.0
Latest release: 4.2.1 (published 3 months ago)
Last Synced: 2026-10-31T14:33:12.685Z (2 days ago)
Versions: 139
Dependent Packages: 128
Dependent Repositories: 219
Downloads: 887,326 Last month
Docker Downloads: 48
Rankings:
- Dependent packages count: 0.235%
- Downloads: 0.606%
- Dependent repos count: 1.026%
- Stargazers count: 1.823%
- Average: 1.954%
- Docker downloads count: 3.277%
- Forks count: 4.759%
Maintainers (1)
- simonw

proxy.golang.org: github.com/simonw/sqlite-utils

Homepage:
Status: removed
Documentation: https://pkg.go.dev/github.com/simonw/sqlite-utils#section-documentation
Licenses: apache-2.0
Latest release: v0.0.0-20260812234401-fcfccea8132e (published 3 months ago)
Last Synced: 2026-10-31T14:33:15.058Z (2 days ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent packages count: 4.482%
- Average: 4.633%
- Dependent repos count: 4.783%

conda-forge.org: sqlite-utils

Homepage: https://github.com/simonw/sqlite-utils
Licenses: Apache-2.0
Latest release: 3.25.1 (published over 4 years ago)
Last Synced: 2026-04-02T04:13:46.378Z (7 months ago)
Versions: 28
Dependent Packages: 3
Dependent Repositories: 1
Downloads: 98,591 Total
Rankings:
- Stargazers count: 11.952%
- Dependent packages count: 15.649%
- Average: 17.94%
- Forks count: 19.761%
- Dependent repos count: 24.397%

formulae.brew.sh: sqlite-utils

CLI utility for manipulating SQLite databases

Homepage: https://sqlite-utils.datasette.io/
Licenses: Apache-2.0
Latest release: 4.2.1 (published 2 months ago)
Last Synced: 2026-10-31T20:22:46.192Z (2 days ago)
Versions: 19
Dependent Packages: 1
Dependent Repositories: 1
Downloads: 74 Last month
Rankings:
- Downloads: 17.987%
- Dependent packages count: 19.371%
- Average: 22.376%
- Dependent repos count: 29.769%

nixpkgs-24.11: sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-24.11/pkgs/development/python-modules/sqlite-utils/default.nix#L52
Licenses: Apache-2.0
Latest release: 3.37 (published 9 months ago)
Last Synced: 2026-03-08T15:27:11.731Z (8 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
Maintainers (2)
- techknowlogick
- meatcar

nixpkgs-unstable: sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-unstable/pkgs/development/python-modules/sqlite-utils/default.nix#L53
Licenses: Apache-2.0
Latest release: 4.2.1 (published 1 day ago)
Last Synced: 2026-11-01T12:59:04.863Z (1 day ago)
Versions: 3
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
Maintainers (2)
- techknowlogick
- meatcar

nixpkgs-23.05: python310Packages.sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-23.05/pkgs/development/python-modules/sqlite-utils/default.nix#L50
Licenses: Apache-2.0
Latest release: 3.31 (published 9 months ago)
Last Synced: 2026-04-09T22:01:18.721Z (7 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
Maintainers (2)
- techknowlogick
- meatcar

guix: python-sqlite-utils

CLI tool and Python utility functions for manipulating SQLite databases

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://git.savannah.gnu.org/cgit/guix.git/tree/gnu/packages/databases.scm#n4543
Licenses: asl2.0
Latest release: 3.38 (published 8 months ago)
Last Synced: 2026-04-07T12:02:46.735Z (7 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%

nixpkgs-unstable: python314Packages.sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-unstable/pkgs/development/python-modules/sqlite-utils/default.nix#L53
Licenses: Apache-2.0
Latest release: 4.2.1 (published 1 day ago)
Last Synced: 2026-11-01T11:47:45.162Z (1 day ago)
Versions: 3
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
Maintainers (2)
- techknowlogick
- meatcar

nixpkgs-24.05: python312Packages.sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-24.05/pkgs/development/python-modules/sqlite-utils/default.nix#L55
Licenses: Apache-2.0
Latest release: 3.36 (published 9 months ago)
Last Synced: 2026-09-01T06:30:20.847Z (2 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
Maintainers (2)
- techknowlogick
- meatcar

nixpkgs-23.11: python311Packages.sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-23.11/pkgs/development/python-modules/sqlite-utils/default.nix#L58
Licenses: Apache-2.0
Latest release: 3.35.2 (published 9 months ago)
Last Synced: 2026-07-27T16:01:26.797Z (3 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
Maintainers (2)
- techknowlogick
- meatcar

nixpkgs-24.05: python311Packages.sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-24.05/pkgs/development/python-modules/sqlite-utils/default.nix#L55
Licenses: Apache-2.0
Latest release: 3.36 (published 9 months ago)
Last Synced: 2026-08-07T07:03:38.319Z (3 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
Maintainers (2)
- techknowlogick
- meatcar

ubuntu-23.10: sqlite-utils

Homepage: https://github.com/simonw/sqlite-utils
Licenses: apache-2.0
Latest release: 3.34-1 (published 9 months ago)
Last Synced: 2026-03-14T05:18:27.384Z (8 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%

nixpkgs-23.05: sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-23.05/pkgs/development/python-modules/sqlite-utils/default.nix#L50
Licenses: Apache-2.0
Latest release: 3.31 (published 9 months ago)
Last Synced: 2026-08-10T20:03:57.607Z (3 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
Maintainers (2)
- techknowlogick
- meatcar

nixpkgs-24.05: sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-24.05/pkgs/development/python-modules/sqlite-utils/default.nix#L55
Licenses: Apache-2.0
Latest release: 3.36 (published 9 months ago)
Last Synced: 2026-09-06T19:26:48.116Z (about 2 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
Maintainers (2)
- techknowlogick
- meatcar

ubuntu-24.10: sqlite-utils

Homepage: https://github.com/simonw/sqlite-utils
Licenses: apache-2.0
Latest release: 3.36-1 (published 9 months ago)
Last Synced: 2026-09-06T21:27:34.640Z (about 2 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%

nixpkgs-24.11: python312Packages.sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-24.11/pkgs/development/python-modules/sqlite-utils/default.nix#L52
Licenses: Apache-2.0
Latest release: 3.37 (published 9 months ago)
Last Synced: 2026-03-06T08:46:37.005Z (8 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
Maintainers (2)
- techknowlogick
- meatcar

debian-12: sqlite-utils

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://packages.debian.org/bookworm/sqlite-utils
Licenses: apache-2.0
Latest release: 3.30-1 (published 9 months ago)
Last Synced: 2026-03-14T01:35:51.407Z (8 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%

ubuntu-23.04: sqlite-utils

Homepage: https://github.com/simonw/sqlite-utils
Licenses: apache-2.0
Latest release: 3.30-1 (published 9 months ago)
Last Synced: 2026-03-11T08:08:30.482Z (8 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%

nixpkgs-24.11: python311Packages.sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-24.11/pkgs/development/python-modules/sqlite-utils/default.nix#L52
Licenses: Apache-2.0
Latest release: 3.37 (published 9 months ago)
Last Synced: 2026-07-31T01:07:12.102Z (3 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
Maintainers (2)
- techknowlogick
- meatcar

nixpkgs-23.11: python310Packages.sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-23.11/pkgs/development/python-modules/sqlite-utils/default.nix#L58
Licenses: Apache-2.0
Latest release: 3.35.2 (published 9 months ago)
Last Synced: 2026-08-04T21:00:14.751Z (3 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
Maintainers (2)
- techknowlogick
- meatcar

nixpkgs-unstable: python313Packages.sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-unstable/pkgs/development/python-modules/sqlite-utils/default.nix#L53
Licenses: Apache-2.0
Latest release: 4.2.1 (published 1 day ago)
Last Synced: 2026-11-01T11:13:39.691Z (1 day ago)
Versions: 3
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
Maintainers (2)
- techknowlogick
- meatcar

debian-13: sqlite-utils

Homepage: https://github.com/simonw/sqlite-utils
Documentation: https://packages.debian.org/trixie/sqlite-utils
Licenses: apache-2.0
Latest release: 3.38-1 (published 9 months ago)
Last Synced: 2026-03-12T18:08:12.469Z (8 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%

ubuntu-24.04: sqlite-utils

Homepage: https://github.com/simonw/sqlite-utils
Licenses: apache-2.0
Latest release: 3.35.2-1 (published 9 months ago)
Last Synced: 2026-03-13T05:12:15.429Z (8 months ago)
Versions: 1
Dependent Packages: 0
Dependent Repositories: 0
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%

Dependencies

.github/workflows/codeql-analysis.yml actions

actions/checkout v2 composite
github/codeql-action/analyze v1 composite
github/codeql-action/autobuild v1 composite
github/codeql-action/init v1 composite

.github/workflows/documentation-links.yml actions

readthedocs/actions/preview v1 composite

.github/workflows/publish.yml actions

actions/cache v3 composite
actions/checkout v3 composite
actions/setup-python v4 composite

.github/workflows/spellcheck.yml actions

actions/cache v2 composite
actions/checkout v2 composite
actions/setup-python v2 composite

.github/workflows/test-coverage.yml actions

actions/cache v2 composite
actions/checkout v2 composite
actions/setup-python v2 composite
codecov/codecov-action v1 composite

.github/workflows/test.yml actions

actions/cache v3 composite
actions/checkout v3 composite
actions/setup-python v4 composite

pyproject.toml pypi

click >=8.3.1
click-default-group >=1.2.3
pip *
pluggy *
python-dateutil *
sqlite-fts4 *
tabulate *

.github/workflows/test-sqlite-support.yml actions

./.github/actions/setup-sqlite-version * composite
actions/checkout v7 composite
actions/setup-python v6 composite

.github/actions/setup-sqlite-version/action.yml actions

actions/cache v6 composite