The modern interactive canvas for relational algebra.
Write formal relational algebra expressions, inspect step-by-step evaluation trees, translate to optimized SQL, and master relational calculus directly inside your browser.
| name | department | salary |
|---|---|---|
| Alice Smith | Engineering | $92,000 |
| Carlos Ortiz | Design | $84,000 |
| Diana Prince | Research | $98,500 |
Built for rigorous computer science education
Interactive Expression Sandbox
Write, validate, and evaluate relational algebra queries against live tables with immediate visual feedback and schema inspection.
Open sandbox →Curated Practice Exercises
Progressive problem sets from basic projections and selections to multi-way joins, set operations, and division queries.
Browse exercises →Formal Operator Reference
Comprehensive reference sheet documenting mathematical definitions, algebraic laws, operator precedence, and SQL translations.
View operator guide →Everything runs locally in your browser
RAT is designed as a standalone static application deployable to GitHub Pages. All parsing, validation, query tree generation, and relation execution happen client-side without any server roundtrips.
Next.js 16.3.6 (Pages Router), Radix UI primitives, Tailwind v4 tokens
Client-side lexer, recursive-descent parser, AST optimizer
In-memory relation tables, browser LocalStorage persistence
Static export (out/) hosted seamlessly on root or /rat path