RDST
A command-line toolkit for PostgreSQL and MySQL that diagnoses slow queries, recommends indexes and rewrites, answers natural-language questions about your data, audits database health across single targets or whole fleets, and deploys Readyset caches with head-to-head benchmarking.
Readyset Diagnostics and SQL Toolkit (RDST) is a command-line tool for PostgreSQL and MySQL that:
- Diagnoses slow queries
- Recommends fixes (indexes, rewrites)
- Lets you ask questions about your data in natural language
- Audits database health, at the single-database or whole-fleet level
- Deploys Readyset and caches specific queries with it
You don't need to be running Readyset to use RDST. When Readyset is available, RDST can deploy, manage, and benchmark shallow caches for you.
What RDST is good for
| If you want to... | Reach for |
|---|---|
| See which queries are consuming the most database time right now | rdst top |
| Get an end-to-end analysis of one query with index and rewrite recommendations | rdst analyze |
| Ask a question in plain English and get safe, read-only SQL back | rdst ask |
| Find and analyze the SQL your application is actually generating | rdst scan |
| Get a single, comprehensive health report for a database | rdst audit |
| Do the same across ten, fifty, or hundreds of databases at once | rdst fleet audit |
| Auto-discover your RDS and Aurora fleet | rdst fleet discover |
| Deploy a Readyset cache in front of a database | rdst cache deploy |
| Compare upstream vs. cached query performance head-to-head | rdst query cache-compare |
| Let Claude Code or a Slack bot drive RDST for you | Integrations |
| Get an answer about how to use RDST itself without leaving your terminal | rdst help |
Where to go next
Getting Started
Install RDST and walk through every core workflow against a real database.
Core Concepts
Targets, the query registry, the semantic layer, and how Readyset fits in.
Query Analysis
top, analyze, ask, and scan — when to use each and what to expect.
Fleet and Audit
Audit a single database or an entire fleet. Capture live workloads. Diff across time.
Readyset Cache
Deploy Readyset, add shallow caches, and benchmark upstream against cache.
Integrations
Drive RDST from Claude Code, Slack, or the browser-based web UI.
How RDST relates to the rest of Readyset
| Tool | Role | Where it runs |
|---|---|---|
| Readyset | Real-time SQL cache for Postgres and MySQL | Alongside your database |
| Readyset QueryPilot | Automated cache discovery and deployment on top of Readyset | Readyset Cloud or self-hosted |
| RDST | Diagnose queries, audit databases, and optionally drive Readyset caches | Your laptop, CI, or a diagnostics host |
RDST is the entry point most teams should reach for first. It surfaces which queries matter, why they are slow, whether Readyset can help, and — if it can — deploys the cache for you.