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 issues indexed so far

migrate --stop-before commits earlier sets before rejecting an already-applied target Open

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

simonw/sqlite-utils#870 · Opened Sep 18, 2026
Date conversion recipes do not apply errors= handling to parser overflows Open

Difficulty 2/5 1-3 hours Newbie friendliness 82/100

simonw/sqlite-utils#857 · Opened Sep 13, 2026
Clarify transform() behavior for indexes, views and triggers Open

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

simonw/sqlite-utils#849 · Opened Aug 28, 2026
rows_where() and delete_where() fail to throw errors against non-existent tables (fix in v5) Open

breaking-change-for-v5 bug

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

simonw/sqlite-utils#841 · 1 comment · Opened Aug 13, 2026
delete_where() fails to commit in 3.x Open

bug

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

simonw/sqlite-utils#815 · 2 comments · Opened Jul 26, 2026
Add bundled binary for CLI using PyInstaller Open

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

simonw/sqlite-utils#796 · Opened Jul 12, 2026
Auto-generate ULID as Primary Keys on Bulk Insert Open

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

simonw/sqlite-utils#728 · 2 comments · Opened Apr 6, 2026
Support AUTOINCREMENT keyword Open

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

simonw/sqlite-utils#664 · Opened Jul 11, 2025
How to insert the vector embeddings values into a table? Open

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

simonw/sqlite-utils#651 · Opened Mar 3, 2025
Ability to pass a URI to the CLI tools Open

cli-tool design enhancement

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

simonw/sqlite-utils#650 · 2 comments · 1 reaction · Opened Mar 1, 2025
Vector search functionality in sqlite-utils Open

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

simonw/sqlite-utils#635 · 1 comment · 1 reaction · Opened Aug 3, 2024
Command to generate a visual schema diagram? Open

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

simonw/sqlite-utils#622 · Opened Mar 29, 2024
Windows: Correct way to initialize spatialite? Open

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

simonw/sqlite-utils#613 · Opened Jan 25, 2024
Automatic JSON de-serialization Open

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

simonw/sqlite-utils#612 · Opened Jan 22, 2024
`.transform()` effect on triggers and indices Open

transform

Difficulty 2/5 1-3 hours Newbie friendliness 52/100

simonw/sqlite-utils#611 · 1 comment · Opened Jan 20, 2024
Attached database tables representable by `Table` Open

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

simonw/sqlite-utils#608 · Opened Dec 22, 2023
Move plugin directory into documentation Open

documentation plugins

Difficulty 2/5 1-3 hours Newbie friendliness 52/100

simonw/sqlite-utils#601 · Opened Nov 4, 2023
Feature request: sqlite-utils insert-files should be able to convert fields Open

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

simonw/sqlite-utils#597 · Opened Sep 30, 2023
Mechanism for de-registering registered SQL functions Open

enhancement python-library

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

simonw/sqlite-utils#589 · 3 comments · Opened Sep 3, 2023
`table.get(column=value)` option for retrieving things not by their primary key Open

Difficulty 2/5 1-3 hours Newbie friendliness 78/100

simonw/sqlite-utils#588 · 4 comments · 1 reaction · Opened Aug 28, 2023
Handling CSV/file input that contains NUL bytes Open

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

simonw/sqlite-utils#582 · Opened Aug 7, 2023
Add way to export to a csv file using the Python library Open

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

simonw/sqlite-utils#580 · 1 comment · Opened Jul 26, 2023
Special handling for SQLite column of type `JSON` Open

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

simonw/sqlite-utils#579 · 1 comment · 1 reaction · Opened Jul 25, 2023
Plugin hook for adding new output formats Open

enhancement plugins

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

simonw/sqlite-utils#578 · 5 comments · Opened Jul 24, 2023
Explore the intersection between sqlite-utils and dataclasses Open

research

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

simonw/sqlite-utils#562 · 2 comments · Opened Jul 2, 2023
Ability to define unique columns when creating a table Open

enhancement python-library

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

simonw/sqlite-utils#558 · Opened Jun 13, 2023
Support storing incrementally piped values Open

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

simonw/sqlite-utils#556 · 1 comment · Opened Jun 4, 2023
Filter table by a large bunch of ids Open

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

simonw/sqlite-utils#555 · 1 comment · Opened May 31, 2023
rows: --transpose or psql extended view-like functionality Open

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

simonw/sqlite-utils#535 · 3 comments · Opened Apr 5, 2023
Feature request: trim all leading and trailing white space for all columns for all tables in a database Open

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

simonw/sqlite-utils#523 · 1 comment · Opened Jan 28, 2023
Custom JSON encoder Open

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

simonw/sqlite-utils#521 · 1 comment · 1 reaction · Opened Jan 20, 2023
Feature request: output number of ignored/replaced rows for insert command Open

enhancement

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

simonw/sqlite-utils#516 · 4 comments · Opened Dec 6, 2022
Add or document streamlined workflow for importing Datasette csv / json exports Open

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

simonw/sqlite-utils#513 · Opened Nov 17, 2022
Tiny typographical error in install/uninstall docs Open

bug documentation help wanted

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

simonw/sqlite-utils#493 · 5 comments · Opened Sep 26, 2022
Idea: ability to pass extra variables to `--convert` scripts Open

cli-tool research

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

simonw/sqlite-utils#492 · 1 comment · Opened Sep 26, 2022
Ability to merge databases and tables Open

cli-tool help wanted

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

simonw/sqlite-utils#491 · 9 comments · 3 reactions · Opened Sep 23, 2022
Ability to load JSON records held in a file with a single top level key that is a list of objects Open

cli-tool enhancement

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

simonw/sqlite-utils#489 · 9 comments · 2 reactions · Opened Sep 15, 2022
Expose convert recipes to `sqlite-utils --functions` Open

cli-tool enhancement

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

simonw/sqlite-utils#484 · 11 comments · Opened Sep 6, 2022
Idea: `sqlite-utils create-table tablename --sql "select ..."` Open

cli-tool enhancement

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

simonw/sqlite-utils#481 · Opened Sep 2, 2022
OperationalError: cannot VACUUM from within a transaction Open

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

simonw/sqlite-utils#479 · Opened Aug 30, 2022
`sqlite-utils tables data.db table1 table2` Open

cli-tool enhancement

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

simonw/sqlite-utils#478 · 1 comment · Opened Aug 28, 2022
Add an option for specifying column names when inserting CSV data Open

cli-tool enhancement

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

simonw/sqlite-utils#474 · 3 comments · Opened Aug 27, 2022
Consider including animated SVG console demos Open

documentation research

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

simonw/sqlite-utils#461 · 1 comment · Opened Aug 2, 2022
Single quoted transform recipes on Windows do not work as expected Open

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

simonw/sqlite-utils#459 · Opened Aug 1, 2022
feature request: pivot command Open

enhancement

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

simonw/sqlite-utils#456 · 5 comments · Opened Jul 20, 2022
CSV `extras_key=` and `ignore_extras=` equivalents for CLI tool Open

cli-tool enhancement

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

simonw/sqlite-utils#444 · 5 comments · Opened Jun 14, 2022
Misleading progress bar against utf-16-le CSV input Open

bug help wanted

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

simonw/sqlite-utils#439 · 12 comments · Opened May 27, 2022
Support `rows_where()`, `delete_where()` etc for attached alias databases Open

enhancement

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

simonw/sqlite-utils#432 · 5 comments · Opened May 16, 2022
Allow making m2m relation of a table to itself Open

enhancement

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

simonw/sqlite-utils#431 · 3 comments · Opened May 6, 2022
Document how to use `PRAGMA temp_store` to avoid errors when running VACUUM against huge databases Open

documentation help wanted

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

simonw/sqlite-utils#430 · 2 comments · Opened May 3, 2022

simonw/sqlite-utils

Get new issues in your inbox