Building crescodb

The Saint • Peerlist

<h3>A comprehensive backend toolkit designed for rapid development and deployment.</h3><ul><li>Local-first and multi-database support: Works seamlessly with SQLite, PostgreSQL, or MySQL without requiring code rewrites during deployment.</li><li>Auto-generated REST API: Provides full CRUD operations, bulk insert, filtering, and pagination for every model, offering instant endpoints with zero manual routing.</li><li>Schema definition from natural language: Describe your data in plain English to generate a validated schema that can be reviewed, edited, and applied with a single click.</li><li>In-dashboard coding agent: An AI-powered agent that can read and write project files, run commands, and provides diffs and undo functionality with user approval.</li><li>Authentication and Role-Based Access Control (RBAC): Features JWT login, user roles (guest to admin), and per-table access policies enforced on every request. Supports GitHub &amp; Google OAuth.</li><li>Full-code scaffolds: Generates real, editable code for features like authentication (register.js, login.js) that are directly wired to your database. Includes Express &amp; Next.js variants.</li><li>File storage: Supports buckets for uploads (public or private), a dashboard file browser, and S3/R2 backend integration for production.</li><li>Realtime functionality: Enables subscriptions to live row changes over SSE, respecting per-row security.</li><li>Integrated Dashboard: A local admin studio for browsing and editing data, designing schemas, running SQL, uploading files, managing users, and exploring the API.</li><li>Flexible Deployment: Ship your application to any $5 VPS you own, with automatic HTTPS certificates, DNS setup, and nightly backups that are proven to restore.</li></ul>