sqtab 0.0.1

Minimalist SQLite-based CLI tool for working with tabular data.

sqtab

sqtab is a minimalist command-line tool for working with tabular data using SQLite.
It provides a simple workflow for importing CSV/JSON files, inspecting table structures, executing SQL queries, and exporting results.
The goal is to offer a small, dependency-light utility that is easy to integrate into scripts and data pipelines.

---

Installation

git clone https://github.com/gojankovic/sqtab
cd sqtab
python -m venv venv
source venv/bin/activate   # Windows: venv\Scripts\activate
pip install -e .

This installs the sqtab command inside your virtual environment.

---

Basic Usage

Import CSV or JSON into a table

sqtab import data.csv users
sqtab import data.json users

Analyze table structure

sqtab analyze users

List tables

sqtab tables
sqtab tables --schema

Execute SQL

sqtab sql "SELECT * FROM users;"

Export tables

sqtab export users output.csv
sqtab export users output.json

Database information

sqtab info

Reset database

Soft reset (drops all tables):

sqtab reset

Hard reset (delete the database file):

sqtab reset --hard

---

Command Reference

The full list of commands is always available through:

sqtab --help
sqtab <command> --help

Examples:

sqtab import --help
sqtab sql --help
sqtab tables --help

Each command provides clear parameter descriptions and available options.

---

License

MIT License © 2025 Goran Janković