RDST - Readyset Data and SQL Toolkit
A command-line tool for database diagnostics, query analysis, performance tuning, and caching optimization with Readyset.
What is RDST?
RDST helps you:
- Analyze SQL queries for caching opportunities
- Identify slow queries in real-time
- Get optimization suggestions
- Evaluate query compatibility with Readyset cache
- Manage database connection profiles
Installation
Using uvx (recommended - no installation required)
Run RDST directly without installing:
uvx rdst --help
uvx rdst analyze "SELECT * FROM users WHERE id = 1"
Using pipx (persistent installation)
Install globally:
# Install
pipx install rdst
# Run
rdst --help
# Upgrade to latest version
pipx upgrade rdst
Using pip
pip install rdst
After installing, run
rdst initto configure your first database connection.
Quick Start
-
Initialize RDST:
rdst init # Or with uvx (no installation needed): uvx rdst init
-
Configure database connection:
rdst configure add-target mydb \ --host localhost \ --port 5432 \ --database myapp \ --user postgres
-
Analyze queries:
# Analyze a specific query rdst analyze "SELECT * FROM users WHERE active = true" # With uvx: uvx rdst analyze "SELECT * FROM users WHERE active = true" # Analyze with Readyset cache evaluation rdst analyze --readyset-cache "SELECT * FROM products ORDER BY created_at"
-
Monitor slow queries:
rdst top # Or: uvx rdst top
-
Audit your fleet:
# Snapshot all ReadySet clusters and audit their health rdst fleet audit --target prod # Import clusters from your infrastructure rdst fleet import --target prod
Fleet audit checks cache utilization, query support, and configuration across your ReadySet deployments. See the fleet audit docs for more.
Commands
All commands can be run with rdst (if installed) or uvx rdst (no installation):
rdst analyze- Analyze SQL queries and evaluate caching opportunitiesrdst top- Live view of slow queriesrdst ask- Natural language to SQL queriesrdst scan- Scan codebases for ORM queries and analyze performancerdst fleet audit- Audit ReadySet cluster health and cache utilizationrdst fleet import- Import ReadySet clusters from your infrastructurerdst schema- Manage the semantic layer for better query generationrdst query- Manage query registryrdst configure- Manage database targets and connection profilesrdst init- First-time setup wizardrdst version- Show version information
Example with uvx:
uvx rdst analyze "SELECT * FROM orders WHERE status = 'pending'"
Requirements
- Python 3.11 or higher
- PostgreSQL or MySQL database access
About Readyset
Readyset is a SQL caching engine that sits between your application and database, automatically caching query results to improve performance. Learn more at readyset.io.
Documentation
License
MIT License - see LICENSE file for details
Metadata
Release files for rdst 0.1.1630
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| rdst-0.1.1630.tar.gz | 2.6 MB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| rdst-0.1.1630-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 4.8 MB
Release files / rdst-0.1.1630.tar.gz
| Download URL | rdst-0.1.1630.tar.gz |
|---|---|
| Size | 2.6 MB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
8e7baa5f315802c90ac3c71dc8b8d36b2fa6d515a6c7fe04055258228ad96d27
|
|
BLAKE2b-256 checksum How to use checksums |
9e51bb8785fab0c860280d36952b24b770447287d902da23e7d41d8101d47170
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.9.25
|
Release files / rdst-0.1.1630-py3-none-any.whl
| Download URL | rdst-0.1.1630-py3-none-any.whl |
|---|---|
| Size | 2.3 MB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
4d890fc3791d3a2716afe74a28c2649799074216516fb44185b2bbea315b121e
|
|
BLAKE2b-256 checksum How to use checksums |
b2838f6664886808e8b4eb0e10eb8729b7aa5d9e9535e9222caf014638e950e2
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.2.0 CPython/3.9.25
|