simonw/sqlite-utils

View on GitHub

Python CLI utility and library for manipulating SQLite databases

Stars: 2.2k
Forks: 172
Open beginner issues: 0
Indexed issues: 78
Avg merge: 9m
Merged PRs (30d): 1

Dominant language: Python
License: Apache-2.0
Last GitHub push: Sep 2, 2026
Latest indexed: Sep 19, 2026
Contributing guide: Contributing guide
Code of conduct: No code of conduct
Beginner labels: help wanted

Beginner friendly Everything

Open All

78 open issues indexed

Optional Pandas integration Open

help wanted research

Difficulty 5/5 Over a week Newbie friendliness 25/100

simonw/sqlite-utils#412 · 13 comments · Opened Mar 5, 2022
Support for generated columns Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 30/100

simonw/sqlite-utils#411 · 8 comments · 2 reactions · Opened Mar 4, 2022
`with db:` for transactions Open

enhancement python-library

Difficulty 1/5 Under an hour Newbie friendliness 35/100

simonw/sqlite-utils#409 · 3 comments · Opened Feb 24, 2022
Creating tables with custom datatypes Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 30/100

simonw/sqlite-utils#406 · 6 comments · 2 reactions · Opened Feb 9, 2022
Advanced class-based `conversions=` mechanism Open

documentation enhancement python-library spatialite

Difficulty 4/5 3-5 days Newbie friendliness 45/100

simonw/sqlite-utils#402 · 15 comments · Opened Feb 6, 2022
Make it easier to insert geometries, with documentation and maybe code Open

documentation help wanted python-library spatialite

Difficulty 5/5 Over a week Newbie friendliness 30/100

simonw/sqlite-utils#399 · 25 comments · Opened Feb 5, 2022
Use RETURNING if available to populate last_pk Open

enhancement research

Difficulty 3/5 1-2 days Newbie friendliness 35/100

simonw/sqlite-utils#359 · Opened Dec 29, 2021
Support for CHECK constraints Open

enhancement transform

Difficulty 4/5 3-5 days Newbie friendliness 48/100

simonw/sqlite-utils#358 · 9 comments · Opened Dec 16, 2021
`sqlite-utils insert --extract colname` Open

cli-tool enhancement

Difficulty 3/5 1-2 days Newbie friendliness 38/100

simonw/sqlite-utils#352 · 4 comments · Opened Dec 7, 2021
Optional caching mechanism for table.lookup() Open

enhancement python-library research

Difficulty 4/5 3-5 days Newbie friendliness 35/100

simonw/sqlite-utils#350 · 3 comments · Opened Dec 6, 2021
A way of creating indexes on newly created tables Open

enhancement python-library

Difficulty 4/5 3-5 days Newbie friendliness 38/100

simonw/sqlite-utils#349 · 3 comments · Opened Dec 5, 2021
Way to test SQLite 3.37 (and potentially other versions) in CI Open

ci

Difficulty 4/5 3-5 days Newbie friendliness 35/100

simonw/sqlite-utils#346 · 5 comments · Opened Nov 29, 2021
Research: handle gzipped CSV directly Open

cli-tool research

Difficulty 4/5 3-5 days Newbie friendliness 25/100

simonw/sqlite-utils#318 · 2 comments · Opened Aug 18, 2021
Add an interactive tutorial as a Jupyter notebook Open

documentation

Difficulty 3/5 1-2 days Newbie friendliness 35/100

simonw/sqlite-utils#308 · 2 comments · Opened Aug 4, 2021
Option for importing CSV data using the SQLite .import mechanism Open

cli-tool enhancement

Difficulty 4/5 3-5 days Newbie friendliness 35/100

simonw/sqlite-utils#297 · 23 comments · Opened Jul 14, 2021
row.update() or row.pk Open

research

Difficulty 3/5 1-2 days Newbie friendliness 38/100

simonw/sqlite-utils#267 · 4 comments · Opened Jun 8, 2021
Using enable_fts before search term Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

simonw/sqlite-utils#265 · 1 comment · Opened Jun 1, 2021
How can i use this utils to deal with fts on column meta of tables ? Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

simonw/sqlite-utils#243 · Opened Mar 1, 2021
Async support Open

enhancement python-library

Difficulty 5/5 Over a week Newbie friendliness 30/100

simonw/sqlite-utils#242 · 14 comments · 1 reaction · Opened Feb 27, 2021
sqlite-utils extract could handle nested objects Open

cli-tool enhancement python-library

Difficulty 4/5 3-5 days Newbie friendliness 35/100

simonw/sqlite-utils#239 · 17 comments · 6 reactions · Opened Feb 25, 2021
Idea: conversions= could take Python functions Open

python-library research

Difficulty 4/5 3-5 days Newbie friendliness 35/100

simonw/sqlite-utils#163 · 4 comments · Opened Sep 22, 2020
SQLITE_MAX_VARS maybe hard-coded too low Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 35/100

simonw/sqlite-utils#147 · 8 comments · Opened Aug 30, 2020
insert-files support for compressed values Open

cli-tool research

Difficulty 4/5 3-5 days Newbie friendliness 35/100

simonw/sqlite-utils#141 · Opened Aug 28, 2020
Idea: insert-files mechanism for adding extra columns with fixed values Open

cli-tool research

Difficulty 3/5 1-2 days Newbie friendliness 35/100

simonw/sqlite-utils#140 · 1 comment · Opened Aug 28, 2020
Support more string values for types in .add_column() Open

enhancement python-library

Difficulty 1/5 1-3 hours Newbie friendliness 45/100

simonw/sqlite-utils#93 · Opened Mar 15, 2020
Ability to customize columns used by extracts= feature Open

enhancement python-library

Difficulty 4/5 3-5 days Newbie friendliness 32/100

simonw/sqlite-utils#89 · 3 comments · Opened Mar 1, 2020
extracts= should support multiple-column extracts Open

enhancement wontfix

Difficulty 5/5 Over a week Newbie friendliness 30/100

simonw/sqlite-utils#49 · 10 comments · Opened Jul 24, 2019
Mechanism for turning nested JSON into foreign keys / many-to-many Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 35/100

simonw/sqlite-utils#26 · 14 comments · 4 reactions · Opened Jun 13, 2019

simonw/sqlite-utils

Get new issues in your inbox