Minimalist SQLite-based CLI tool for working with tabular data.
Project description
sqtab
Minimal command-line toolkit for working with tabular data (CSV / JSON) using SQLite.
sqtab allows you to:
- import CSV or JSON into a SQLite table
- run SQL queries
- inspect table schemas
- export tables to CSV
- analyze tables (AI-assisted analysis coming soon)
Installation
Install using pip:
pip install sqtab
Requires Python 3.10+.
Basic Usage
Import CSV or JSON
sqtab import data.csv users
View table schema
sqtab tables --schema
Run SQL queries
sqtab sql "SELECT * FROM users;"
Export a table to CSV
sqtab export users users_export.csv
Reset the database
sqtab reset
For a full list of commands:
sqtab --help
Project Status
sqtab is in early development (0.x releases).
Feedback and contributions are welcome.
Source code:
https://github.com/gojankovic/sqtab
License
MIT License © 2025 Goran Janković
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file sqtab-0.0.2.tar.gz.
File metadata
- Download URL: sqtab-0.0.2.tar.gz
- Upload date:
- Size: 11.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.2.0 CPython/3.13.0
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
77dc16318d2e7d4f01b973ae84867319453c1461c8567a2713c491ffa98d0e66
|
|
| MD5 |
03d8df64294d651dbfe51c7d4b916b72
|
|
| BLAKE2b-256 |
30431bc79abc62eba6a22c8054eb9c32f3a8e40e0229931e85bda523664da960
|
File details
Details for the file sqtab-0.0.2-py3-none-any.whl.
File metadata
- Download URL: sqtab-0.0.2-py3-none-any.whl
- Upload date:
- Size: 11.1 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/6.2.0 CPython/3.13.0
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
f4879fb07ab424c17d9df9879b3d9fecece8242f982dbe3fec32928c394d0bc3
|
|
| MD5 |
1a17bb4abc9fdc6f71416d7e5191193f
|
|
| BLAKE2b-256 |
bfb988753a51bfe424b7c23b250e6fa88cbda7235665ff2c66694782d5959c1b
|
