René's URL Explorer Experiment


Title: GitHub - simonw/sqlite-utils: Python CLI utility and library for manipulating SQLite databases

Open Graph Title: GitHub - simonw/sqlite-utils: Python CLI utility and library for manipulating SQLite databases

X Title: GitHub - simonw/sqlite-utils: Python CLI utility and library for manipulating SQLite databases

Description: Python CLI utility and library for manipulating SQLite databases - simonw/sqlite-utils

Open Graph Description: Python CLI utility and library for manipulating SQLite databases - simonw/sqlite-utils

X Description: Python CLI utility and library for manipulating SQLite databases - simonw/sqlite-utils

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

X: @github

direct link

Domain: github.com

route-pattern/:user_id/:repository
route-controllerfiles
route-actiondisambiguate
fetch-noncev2:85d6f09b-b135-82ca-679d-a6cc436aba84
current-catalog-service-hashf3abb0cc802f3d7b95fc8762b94bdcb13bf39634c40c357301c4aa1d67a256fb
request-idA718:A5F3B:4B6E074:6638E75:6964EBD1
html-safe-nonce9360ef841391b7d7e66891c78b901b69be1d464559b439d30ae2c2d2f72625c9
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJBNzE4OkE1RjNCOjRCNkUwNzQ6NjYzOEU3NTo2OTY0RUJEMSIsInZpc2l0b3JfaWQiOiIyNDEyNTA0OTUwMzY1Mjg1MzI5IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac5c80329766dd4171a3be11646d331e35092ceb54a26a0c1571e0849e7120d09f
hovercard-subject-tagrepository:140912432
github-keyboard-shortcutsrepository,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location//
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/simonw/sqlite-utils
twitter:imagehttps://repository-images.githubusercontent.com/140912432/871d0480-8b28-11ea-9d87-0068901541de
twitter:cardsummary_large_image
og:imagehttps://repository-images.githubusercontent.com/140912432/871d0480-8b28-11ea-9d87-0068901541de
og:image:altPython CLI utility and library for manipulating SQLite databases - simonw/sqlite-utils
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None3c30097417ecb9dfdab6b2e8bc7dc38d73e183d6ad48f94cb69e4a5daa2dbb87
turbo-cache-controlno-preview
go-importgithub.com/simonw/sqlite-utils git https://github.com/simonw/sqlite-utils.git
octolytics-dimension-user_id9599
octolytics-dimension-user_loginsimonw
octolytics-dimension-repository_id140912432
octolytics-dimension-repository_nwosimonw/sqlite-utils
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id140912432
octolytics-dimension-repository_network_root_nwosimonw/sqlite-utils
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release69fc54a84c74307369dba42af5401200531d116e
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/simonw/sqlite-utils#start-of-content
https://github.com/
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimonw%2Fsqlite-utils
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub SparkBuild and deploy intelligent appshttps://github.com/features/spark
GitHub ModelsManage and compare promptshttps://github.com/features/models
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsimonw%2Fsqlite-utils
Sign up https://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E&source=header-repo&source_repo=simonw%2Fsqlite-utils
Reloadhttps://github.com/simonw/sqlite-utils
Reloadhttps://github.com/simonw/sqlite-utils
Reloadhttps://github.com/simonw/sqlite-utils
simonw https://github.com/simonw
sqlite-utilshttps://github.com/simonw/sqlite-utils
Please reload this pagehttps://github.com/simonw/sqlite-utils
Notifications https://github.com/login?return_to=%2Fsimonw%2Fsqlite-utils
Fork 124 https://github.com/login?return_to=%2Fsimonw%2Fsqlite-utils
Star 2k https://github.com/login?return_to=%2Fsimonw%2Fsqlite-utils
sqlite-utils.datasette.iohttps://sqlite-utils.datasette.io
Apache-2.0 license https://github.com/simonw/sqlite-utils/blob/main/LICENSE
2k stars https://github.com/simonw/sqlite-utils/stargazers
124 forks https://github.com/simonw/sqlite-utils/forks
Branches https://github.com/simonw/sqlite-utils/branches
Tags https://github.com/simonw/sqlite-utils/tags
Activity https://github.com/simonw/sqlite-utils/activity
Star https://github.com/login?return_to=%2Fsimonw%2Fsqlite-utils
Notifications https://github.com/login?return_to=%2Fsimonw%2Fsqlite-utils
Code https://github.com/simonw/sqlite-utils
Issues 107 https://github.com/simonw/sqlite-utils/issues
Pull requests 12 https://github.com/simonw/sqlite-utils/pulls
Actions https://github.com/simonw/sqlite-utils/actions
Projects 0 https://github.com/simonw/sqlite-utils/projects
Security Uh oh! There was an error while loading. Please reload this page. https://github.com/simonw/sqlite-utils/security
Please reload this pagehttps://github.com/simonw/sqlite-utils
Insights https://github.com/simonw/sqlite-utils/pulse
Code https://github.com/simonw/sqlite-utils
Issues https://github.com/simonw/sqlite-utils/issues
Pull requests https://github.com/simonw/sqlite-utils/pulls
Actions https://github.com/simonw/sqlite-utils/actions
Projects https://github.com/simonw/sqlite-utils/projects
Security https://github.com/simonw/sqlite-utils/security
Insights https://github.com/simonw/sqlite-utils/pulse
Brancheshttps://github.com/simonw/sqlite-utils/branches
Tagshttps://github.com/simonw/sqlite-utils/tags
https://github.com/simonw/sqlite-utils/branches
https://github.com/simonw/sqlite-utils/tags
1,036 Commitshttps://github.com/simonw/sqlite-utils/commits/main/
https://github.com/simonw/sqlite-utils/commits/main/
.githubhttps://github.com/simonw/sqlite-utils/tree/main/.github
.githubhttps://github.com/simonw/sqlite-utils/tree/main/.github
docshttps://github.com/simonw/sqlite-utils/tree/main/docs
docshttps://github.com/simonw/sqlite-utils/tree/main/docs
sqlite_utilshttps://github.com/simonw/sqlite-utils/tree/main/sqlite_utils
sqlite_utilshttps://github.com/simonw/sqlite-utils/tree/main/sqlite_utils
testshttps://github.com/simonw/sqlite-utils/tree/main/tests
testshttps://github.com/simonw/sqlite-utils/tree/main/tests
.gitignorehttps://github.com/simonw/sqlite-utils/blob/main/.gitignore
.gitignorehttps://github.com/simonw/sqlite-utils/blob/main/.gitignore
.readthedocs.yamlhttps://github.com/simonw/sqlite-utils/blob/main/.readthedocs.yaml
.readthedocs.yamlhttps://github.com/simonw/sqlite-utils/blob/main/.readthedocs.yaml
Justfilehttps://github.com/simonw/sqlite-utils/blob/main/Justfile
Justfilehttps://github.com/simonw/sqlite-utils/blob/main/Justfile
LICENSEhttps://github.com/simonw/sqlite-utils/blob/main/LICENSE
LICENSEhttps://github.com/simonw/sqlite-utils/blob/main/LICENSE
MANIFEST.inhttps://github.com/simonw/sqlite-utils/blob/main/MANIFEST.in
MANIFEST.inhttps://github.com/simonw/sqlite-utils/blob/main/MANIFEST.in
README.mdhttps://github.com/simonw/sqlite-utils/blob/main/README.md
README.mdhttps://github.com/simonw/sqlite-utils/blob/main/README.md
codecov.ymlhttps://github.com/simonw/sqlite-utils/blob/main/codecov.yml
codecov.ymlhttps://github.com/simonw/sqlite-utils/blob/main/codecov.yml
mypy.inihttps://github.com/simonw/sqlite-utils/blob/main/mypy.ini
mypy.inihttps://github.com/simonw/sqlite-utils/blob/main/mypy.ini
pyproject.tomlhttps://github.com/simonw/sqlite-utils/blob/main/pyproject.toml
pyproject.tomlhttps://github.com/simonw/sqlite-utils/blob/main/pyproject.toml
READMEhttps://github.com/simonw/sqlite-utils
Contributinghttps://github.com/simonw/sqlite-utils
Apache-2.0 licensehttps://github.com/simonw/sqlite-utils
https://github.com/simonw/sqlite-utils#sqlite-utils
https://pypi.org/project/sqlite-utils/
https://sqlite-utils.datasette.io/en/stable/changelog.html
https://pypi.org/project/sqlite-utils/
https://github.com/simonw/sqlite-utils/actions?query=workflow%3ATest
http://sqlite-utils.datasette.io/en/stable/?badge=stable
https://codecov.io/gh/simonw/sqlite-utils
https://github.com/simonw/sqlite-utils/blob/main/LICENSE
https://discord.gg/Ass7bCAMDw
https://github.com/simonw/sqlite-utils#some-feature-highlights
Pipe JSONhttps://sqlite-utils.datasette.io/en/stable/cli.html#inserting-json-data
CSV or TSVhttps://sqlite-utils.datasette.io/en/stable/cli.html#inserting-csv-or-tsv-data
Run in-memory SQL querieshttps://sqlite-utils.datasette.io/en/stable/cli.html#querying-data-directly-using-an-in-memory-database
Configure SQLite full-text searchhttps://sqlite-utils.datasette.io/en/stable/cli.html#configuring-full-text-search
transformations against your tableshttps://sqlite-utils.datasette.io/en/stable/cli.html#transforming-tables
Extract columnshttps://sqlite-utils.datasette.io/en/stable/cli.html#extracting-columns-into-a-separate-table
Install pluginshttps://sqlite-utils.datasette.io/en/stable/plugins.html
New features in sqlite-utilshttps://simonwillison.net/series/sqlite-utils-features/
entries tagged sqliteutilshttps://simonwillison.net/tags/sqliteutils/
https://github.com/simonw/sqlite-utils#installation
Homebrewhttps://brew.sh/
https://github.com/simonw/sqlite-utils#using-as-a-cli-tool
full CLI documentationhttps://sqlite-utils.datasette.io/en/stable/cli.html
https://github.com/simonw/sqlite-utils#using-as-a-library
full library documentationhttps://sqlite-utils.datasette.io/en/stable/python-api.html
https://github.com/simonw/sqlite-utils#related-projects
Datasettehttps://datasette.io/
csvs-to-sqlitehttps://github.com/simonw/csvs-to-sqlite
db-to-sqlitehttps://github.com/simonw/db-to-sqlite
dogsheephttps://dogsheep.github.io/
sqlite-utils.datasette.iohttps://sqlite-utils.datasette.io
python https://github.com/topics/python
cli https://github.com/topics/cli
sqlite https://github.com/topics/sqlite
sqlite-database https://github.com/topics/sqlite-database
click https://github.com/topics/click
datasette https://github.com/topics/datasette
datasette-io https://github.com/topics/datasette-io
datasette-tool https://github.com/topics/datasette-tool
Readme https://github.com/simonw/sqlite-utils#readme-ov-file
Apache-2.0 license https://github.com/simonw/sqlite-utils#Apache-2.0-1-ov-file
Contributing https://github.com/simonw/sqlite-utils#contributing-ov-file
Please reload this pagehttps://github.com/simonw/sqlite-utils
Activityhttps://github.com/simonw/sqlite-utils/activity
2k starshttps://github.com/simonw/sqlite-utils/stargazers
20 watchinghttps://github.com/simonw/sqlite-utils/watchers
124 forkshttps://github.com/simonw/sqlite-utils/forks
Report repository https://github.com/contact/report-content?content_url=https%3A%2F%2Fgithub.com%2Fsimonw%2Fsqlite-utils&report=simonw+%28user%29
Releases 119https://github.com/simonw/sqlite-utils/releases
3.39 Latest Nov 24, 2025 https://github.com/simonw/sqlite-utils/releases/tag/3.39
+ 118 releaseshttps://github.com/simonw/sqlite-utils/releases
Please reload this pagehttps://github.com/simonw/sqlite-utils
Learn more about GitHub Sponsorshttps://github.com/sponsors
Used by 2.7khttps://github.com/simonw/sqlite-utils/network/dependents
+ 2,646 https://github.com/simonw/sqlite-utils/network/dependents
Contributors 46https://github.com/simonw/sqlite-utils/graphs/contributors
https://github.com/simonw
https://github.com/eyeseast
https://github.com/claude
https://github.com/simonwiles
https://github.com/tsibley
https://github.com/fry69
https://github.com/EdwardBetts
https://github.com/jayvdb
https://github.com/shakeel
https://github.com/adamwolf
https://github.com/amjith
https://github.com/jefftriplett
https://github.com/spookylukey
https://github.com/mfa
+ 32 contributorshttps://github.com/simonw/sqlite-utils/graphs/contributors
Python 99.7% https://github.com/simonw/sqlite-utils/search?l=python
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.