Terminal-based SQLite manager
Project description
SQTerm is a fast, lightweight, terminal-based SQLite tool written in Python.
Built for when you don’t want a bloated GUI and just need to get work done — fast.
🚀 Features
- 🔹 Execute raw SQL commands directly
- 🔹 Clean table output with
tabulate - 🔹 Import large CSV files into tables (fast, petl-backed)
- 🔹 Export entire tables or query results to CSV
- 🔹 View tables and their structure
- 🔹 Show simple database statistics
- 🔹 Switch between
.dbfiles mid-session - 🔹 Error handling with clear messages
Tested on tables and .csv files with up to 10 million rows. No problem.
🛠 Requirements for running code
- Python 3.x
- Libraries:
petlsqlalchemytabulatepsutil
Install them with:
pip install petl sqlalchemy tabulate psutil
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 sqterm-1.3.1.tar.gz.
File metadata
- Download URL: sqterm-1.3.1.tar.gz
- Upload date:
- Size: 7.1 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.13.7
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
43985b14dbebf1309209e9d2b40c8c93e58a88f4676be751e7afea2b36f622dd
|
|
| MD5 |
52e4213b21c83defa9712365d50a462e
|
|
| BLAKE2b-256 |
5949d8aab746719b1b29a94c2d12011902007fee1a94b40935fe774a1b1c2bc4
|
Provenance
The following attestation bundles were made for sqterm-1.3.1.tar.gz:
Publisher:
python-publish.yml on Gamerbot1000/SQTerm
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
sqterm-1.3.1.tar.gz -
Subject digest:
43985b14dbebf1309209e9d2b40c8c93e58a88f4676be751e7afea2b36f622dd - Sigstore transparency entry: 788728145
- Sigstore integration time:
-
Permalink:
Gamerbot1000/SQTerm@78ca2af42f74c4e4deb99198fd86ff1f9f6974e5 -
Branch / Tag:
refs/tags/v1.3.1 - Owner: https://github.com/Gamerbot1000
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
python-publish.yml@78ca2af42f74c4e4deb99198fd86ff1f9f6974e5 -
Trigger Event:
release
-
Statement type:
File details
Details for the file sqterm-1.3.1-py3-none-any.whl.
File metadata
- Download URL: sqterm-1.3.1-py3-none-any.whl
- Upload date:
- Size: 11.7 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.13.7
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
6fb0fc733e0c5d88a8b484ed76e6f2807b334c46cc86939a12af73fd70338ff0
|
|
| MD5 |
5391f77d8f282c16effe9b288cb0d946
|
|
| BLAKE2b-256 |
3b1d82111f2e411f27845fb0d122fcec4d98462844fd4075651ebc836e57fffd
|
Provenance
The following attestation bundles were made for sqterm-1.3.1-py3-none-any.whl:
Publisher:
python-publish.yml on Gamerbot1000/SQTerm
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
sqterm-1.3.1-py3-none-any.whl -
Subject digest:
6fb0fc733e0c5d88a8b484ed76e6f2807b334c46cc86939a12af73fd70338ff0 - Sigstore transparency entry: 788728149
- Sigstore integration time:
-
Permalink:
Gamerbot1000/SQTerm@78ca2af42f74c4e4deb99198fd86ff1f9f6974e5 -
Branch / Tag:
refs/tags/v1.3.1 - Owner: https://github.com/Gamerbot1000
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
python-publish.yml@78ca2af42f74c4e4deb99198fd86ff1f9f6974e5 -
Trigger Event:
release
-
Statement type:
