dbterm

A CLI tool for interacting with SQLite and Postgres databases. Run queries, view tables and schemas, and save output as JSON files.

Features

• Connect to SQLite or Postgres
• Run SQL queries interactively
• View tables and table schemas
• Output results as table or JSON
• Save last output to a file with save <path>;

Installation

npm install -g dbterm

Usage

dbterm --type <sqlite|postgres> [options]

Options

• --type <type>: Database type (sqlite or postgres)
• --db-path <path>: Path to SQLite database
• --connection <string>: Postgres connection string
• --output <format>: Output format (table or json)

Example (SQLite)

dbterm --type sqlite --db-path ./mydb.sqlite

Example (Postgres)

dbterm --type postgres --connection "postgres://user:pass@localhost:5432/mydb"

Commands in REPL

• tables; — List all tables
• table <name> schema; or describe <name>; — Show schema for a table
• Any valid SQL statement ending with ;
• save <path>; — Save last output as JSON to the given path
• help; — Show help
• exit; — Exit the tool