Skip to main content

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 init to configure your first database connection.

Quick Start

  1. Initialize RDST:

    rdst init
    # Or with uvx (no installation needed):
    uvx rdst init
    
  2. Configure database connection:

    rdst configure add-target mydb \
      --host localhost \
      --port 5432 \
      --database myapp \
      --user postgres
    
  3. 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"
    
  4. Monitor slow queries:

    rdst top
    # Or: uvx rdst top
    
  5. 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 opportunities
  • rdst top - Live view of slow queries
  • rdst ask - Natural language to SQL queries
  • rdst scan - Scan codebases for ORM queries and analyze performance
  • rdst fleet audit - Audit ReadySet cluster health and cache utilization
  • rdst fleet import - Import ReadySet clusters from your infrastructure
  • rdst schema - Manage the semantic layer for better query generation
  • rdst query - Manage query registry
  • rdst configure - Manage database targets and connection profiles
  • rdst init - First-time setup wizard
  • rdst 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.1492

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for rdst 0.1.1492
File Size Uploaded
rdst-0.1.1492.tar.gz 2.4 MB Details

Built distribution (wheel)

Table of built distributions (wheels) for rdst 0.1.1492
File Interpreter ABI Platform
rdst-0.1.1492-py3-none-any.whl Python 3 none any Details

Total release size: 4.6 MB

Release files / rdst-0.1.1492.tar.gz

Download URL rdst-0.1.1492.tar.gz
Size 2.4 MB
Tags Source
SHA-256 checksum
How to use checksums
9093edc69fd479b89da5b3fa68bad270a2d6f6e500cda07e604ec53ca45a5f4e
BLAKE2b-256 checksum
How to use checksums
74c1d1100481b4e2d1dab136ffb143ef12a3a8b19d244978a535d55a0a1f5dc2
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.1492-py3-none-any.whl

Download URL rdst-0.1.1492-py3-none-any.whl
Size 2.1 MB
Tags Python 3
SHA-256 checksum
How to use checksums
a0d35cf17a122bb6c6df30a059fffd6c72dd22a55fb170cffbc53bd02e54dafc
BLAKE2b-256 checksum
How to use checksums
79b9ef0222930dfb972f731b597c56b93fddd883dfc8770844cd9d64c8b26e2a
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.2.0 CPython/3.9.25

Release history Release notifications | RSS feed

This release

0.1.1492 This release

2 release files

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page