An SQL interface for your everyday data
Project description
Querify
Querify is a CLI tool that provides SQL interface for data sources.
It is useful for data manipulation using a standard interface for various data sources, and provides an SQL features that allows to query the data in a more convenient way, like WHERE
, GROUP BY
, ORDER BY
and LIMIT
.
Installation
Use the package manager pip to install foobar.
pip install sql-querify
Usage
qy <query>
Examples
List all tables
qy "SHOW tables"
table_name |
---|
dirs |
files |
processes |
Describe a table
qy "DESC processes"
field_name | data_type |
---|---|
pid | int |
name | str |
cmdline | str |
status | str |
username | str |
cpu_pct | float |
memory_pct | float |
create_time | datetime |
Count processes by username
qy "SELECT username, COUNT(1) AS count FROM processes GROUP BY username ORDER BY count DESC"
username | count |
---|---|
user1 | 443 |
root | 215 |
Top 5 directories by size
qy "SELECT name, size_in_bytes/1024/1024 AS size_mb FROM dirs ORDER BY size_mb DESC LIMIT 5"
name | size_mb |
---|---|
pydantic_core | 4 |
chardet | 1 |
distlib | 1 |
_vendor/rich/pycache | 1 |
pip/_vendor/chardet | 1 |
Contributing
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
Project details
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
sql_querify-0.1.2.tar.gz
(17.8 kB
view hashes)
Built Distribution
Close
Hashes for sql_querify-0.1.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0df7e04e5c92a4c3184814c5874ae3fa1a490bef5a7b2b5e47c4a84904d7fdc2 |
|
MD5 | aba4eba85d10620f08b99bb2c63e1e75 |
|
BLAKE2b-256 | b9958beabe92a522f6bc9ebd83dc66bc4a0fe81faa30d10499f0e3cfc1e6309b |