Auto-Generated APIs
Instant REST and GraphQL APIs generated from your database tables with filtering, pagination, sorting, and realtime subscriptions.
Every table you create in your Rach.Dev database automatically gets a fully functional REST API and GraphQL endpoint. There is no code generation step, no schema files to maintain, and no deployment needed. When you add a column, the API updates instantly. When you create a relationship between tables, nested queries become available automatically. The APIs respect your row-level security policies, so you can safely expose them to client applications.
The REST API follows PostgREST conventions, giving you powerful filtering with operators like eq, neq, gt, lt, in, like, and full-text search. Pagination supports both offset and cursor-based strategies. You can request specific columns, embed related resources, and batch multiple operations in a single request. The GraphQL endpoint mirrors the same capabilities with a fully typed schema that updates in real time as your database evolves.
Realtime subscriptions are available on both REST (via Server-Sent Events) and GraphQL (via WebSocket). Subscribe to INSERT, UPDATE, and DELETE events on any table, optionally filtered by column values. This means you can build live dashboards, chat applications, or collaborative editing features without writing any backend code. Rate limiting, request size limits, and query complexity analysis protect your database from abuse.
Key Benefits
- Instant REST and GraphQL endpoints from tables — no code generation or deployment needed
- Rich filtering with eq, neq, gt, lt, in, like, and full-text search operators
- Cursor-based and offset pagination with configurable page sizes
- Realtime subscriptions via SSE and WebSocket for live data features
- Automatic schema updates when you modify tables or relationships
- Row-level security enforcement on every API request for safe client-side access