← Back to tools

sqlite-utils

Python CLI utility and library for manipulating SQLite databases

Data & JSON linuxmacoswindows Python Apache-2.0

Description

sqlite-utils is a Python CLI utility and library for manipulating SQLite databases. It provides commands for creating tables, inserting data, querying, and transforming SQLite databases, with excellent support for importing from JSON, CSV, and other formats.

When to use this tool

Good fit when
  • When working with SQLite databases from the command line
  • When importing data into SQLite from various formats

AI Summary

Python CLI utility and library for creating, querying, and manipulating SQLite databases

Capabilities

  • + Create and manipulate SQLite databases
  • + Import data from JSON, CSV, and other formats
  • + Run SQL queries from the command line
  • + Transform and export data
  • + Use as both a CLI tool and Python library

Use When

  • When working with SQLite databases from the command line
  • When importing data into SQLite from various formats
View AGENTS.md for sqlite-utils