Python TUI database client that supports prql
Project description
PyPrql
Python TUI for CSV files and database connections. See prql-python for just bindings.
For docs, Check out the PyPRQL Docs, and the PRQL Book.
This project is maintained by @charlie-sanders and @rbpatt2019
Installation
pip install pyprql
Try it out
CSV file
curl https://people.sc.fsu.edu/~jburkardt/data/csv/zillow.csv
pyprql zillow.csv
Database
pyprql "sqlite:///your_database.db"
PRQL> show tables
The pyprql tool
- pyprql can connect to any database that SQLAlchemy supports, execute
pyprqlwithout arguments for docs on how to install drivers. - pyprql can connect to CSV files, replace the connection string with the file path and it will load the CSV into a temporary SQLite database.
- pyprql can save the results with a
| to csv ${filename}transform at the end of the query - pyprql has auto-completion on table names and table aliases with tab, and history-completion with alt-f
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
pyprql-0.5.4.tar.gz
(20.6 kB
view hashes)
Built Distribution
pyprql-0.5.4-py3-none-any.whl
(22.7 kB
view hashes)
