sqlite-utils

CLI tool and Python utility functions for manipulating SQLite

Description

Feature highlights:

  - Pipe JSON (or CSV or TSV) directly into a new SQLite database file,
    automatically creating a table with the appropriate schema
  - Run in-memory SQL queries, including joins, directly against data in CSV,
    TSV or JSON files and view the results.
  - Configure SQLite full-text search against your database tables and run
    search queries against them, ordered by relevance
  - Run transformations against your tables to make schema changes that SQLite
    `ALTER TABLE` does not directly support, such as changing the type of a
    column
  - Extract columns into separate tables to better normalize your existing data

Upload more screenshots

Please help extend the collection of screenshots. Just make a screenshot and upload it here. You don't need to register or anything.

Upload a screenshot

Hint: upload an image here from your clipboard with Ctrl-V


Homepage

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


Install this software package

If the package is available for the distribution you are currently using on your computer then install the software by clicking on…

Install sqlite-utils