PyRank
simonw

sqlite-utils

Python CLI utility and library for manipulating SQLite databases
PyPI GitHub
No known security advisories. The current version has no OSV.dev malware reports and no critical or high-severity vulnerabilities.

sqlite-utils has 915K monthly downloads and 2K GitHub stars. Version 3.39 supports Python 3.10+, first published in 2018.

It is actively maintained under a permissive license, last released in Nov 2025.

It is built on top of click, click-default-group and pip. It is used by 237 tracked packages, including llm, sqlite-migrate and rekipedia.

GitHub topics include sqlite, datasette and sqlite-database.

Downloads
Day
34.8K
Week
203.8K
Month
914.7K
Stars
2.1K
Forks
151
Issues
107
Version
3.39

Package Insights

What's this?
Score breakdown - each component scores 0-100, weighted by percentage
Maintenance
100
Popularity
68
Adoption
69
Community
50
Provenance
0
How the maintenance status was determined
Last commit
1 days ago
Monthly downloads
914,658
• Active
Activity within 30 days
Stable
Activity within 31-180 days
Minimal
Activity within 181-365 days, or no activity data
At Risk
No activity for > 365 days, but > 10,000 monthly downloads
Archived
Repository flagged as archived on GitHub
How the popularity category was determined
Monthly downloads
914,658
Stars
2,087
Stars per 1k downloads
2.28
Industry Standard
> 10,000,000 monthly downloads
Hidden Gem
< 0.5 stars per 1k downloads and > 100,000 monthly downloads
Community Favorite
> 5 stars per 1k downloads
• Rising Star
Balanced ratio of stars to downloads
Unknown
Fewer than 1,000 monthly downloads, or no star data
How download momentum is calculated
Week daily avg
29,109
Month daily avg
30,489
Momentum
-4.5%
((week_daily_avg - month_daily_avg) / month_daily_avg) * 100
Python version support tiers
requires_python
>=3.10
Cutting Edge
Minimum supported version is 3.12 or newer
• Modern
Minimum supported version is 3.9, 3.10, or 3.11
Legacy
Supports 3.8 or older (or Python 2)
Unknown
No requires_python specified or unparseable
License categories
License
Apache License, Version 2.0
• Permissive
MIT, Apache, BSD, ISC, Unlicense, CC0, etc.
Copyleft
GPL, LGPL, AGPL, MPL, EPL, etc.
Proprietary
Commercial, all rights reserved, custom EULAs
Unknown
No license specified, or none of the above match
How the release cadence was determined
Last release
224 days ago
Total releases
130
Releases/year
16.4
• Rapid
Last release within 365 days and > 12 releases/year
Regular
Last release within 365 days
Slow
Last release 366-730 days ago
Stalled
Last release > 730 days ago, or no releases
Unknown
No usable release date available
How contributor risk was determined
Contributors
46
Monthly downloads
914,658
High Load
≤ 2 contributors and ≥ 50,000 monthly downloads
Moderate Load
< 10 contributors and ≥ 500,000 monthly downloads
Low Load
< 25 contributors and ≥ 5,000,000 monthly downloads, or sole maintainer with ≥ 10,000 monthly downloads
• Balanced
Enough contributors for the package's popularity
Unknown
No contributor data available
Engagement
56
 
Issue Burden
51.3
per 1k stars
Discussions
0.0
per 1k stars
Fork Ratio
30.5%
contrib / forks
Stale Release
222d
 
PR Velocity
Active
 

Weekly Downloads

GitHub Stars

Not all downloads include detailed metadata. Breakdowns reflect the subset that does.

Downloads by OS

Linux 23.9K
Windows 711
macOS 639

Python Versions

3.11
39.0% 9.7K
3.12
25.9% 6.4K
3.14
15.8% 3.9K
3.10
9.7% 2.4K
3.13
9.6% 2.4K

Top Countries

1. US US
20.6K
2. IE IE
1.6K
3. SG SG
769
4. AU AU
663
5. DE DE
391
6. GB GB
389
7. IN IN
272
8. CN CN
133
9. HK HK
127
10. CA CA
95
GitHub Topics
Tags from the package's GitHub repository describing what it does.

Package Information

License
Apache License, Version 2.0
First Release
July 29, 2018
Last Release
7 months ago
Last Commit
Yesterday
Latest Version
3.39
Total Releases
130
Contributors
46
Open PRs
41
Archived
No
Author
Simon Willison
Python Versions
3.10 3.11 3.12 3.13 3.14
Wheels
py3
Tracking Since
January 6, 2026
Data Updated
July 5, 2026
Data Freshness
Fresh

Links