sqlite-utils Python CLI for SQLite Database Manipulation

sqlite-utils is a Python CLI utility and library by Simon Willison for manipulating SQLite databases. It lets you pipe JSON, CSV, or TSV data directly into SQLite, run in-memory SQL queries against files, configure full-text search, and perform schema transformations — all from the command line.

agentskillexchange Updated 61 repo stars

File contents

sqlite-utils Python CLI for SQLite Database Manipulation

sqlite-utils is a Python CLI utility and library by Simon Willison for manipulating SQLite databases. It lets you pipe JSON, CSV, or TSV data directly into SQLite, run in-memory SQL queries against files, configure full-text search, and perform schema transformations — all from the command line.

Installation

Install or set up from the source-backed instructions:

pip install sqlite-utils

Source

agentskillexchange/skills commit 14635b8efd

Frequently asked questions

npx get-skill add agentskillexchange/sqlite-utils-python-cli-for-sqlite-database-manipulation