Rotifex

Rotifex is a self-hosted backend-as-a-service platform. It lets developers define data models through a JSON schema file or a visual admin panel, and instantly get a full REST API — no code generation required. It ships with JWT authentication, file storage, AI/LLM integration, agent execution, and a built-in admin dashboard.

Core Purpose

Rotifex eliminates boilerplate for backend development. Instead of writing CRUD endpoints, migrations, and auth logic manually, developers define a schema and Rotifex handles everything: table creation, route registration, validation, pagination, filtering, and sorting — live, without restarts.

Key Capabilities

• Schema-driven REST API — define a model, get five CRUD endpoints instantly
• Live schema updates — add or remove models at runtime without restarting the server
• JWT Authentication — register, login, refresh tokens, role-based access control
• File storage — upload, download, manage public and private files with signed URLs
• AI/LLM integration — connect OpenAI, Anthropic, Gemini, and Ollama; generate and chat
• AI Agents — ReAct-loop agents with tools: calculator, web search, HTTP GET, DB query, datetime
• Token usage tracking — persistent per-provider token consumption logged to disk
• Admin dashboard — full SPA for managing schemas, users, files, AI providers, agents, logs, and settings
• Rate limiting, CORS, structured logging — production-ready out of the box

Target Users

• Solo developers who need a backend quickly
• Startups prototyping a product without a dedicated backend engineer
• Internal tools teams who need structured data storage with an admin interface
• Developers integrating LLMs into their applications

Architecture Overview

+-----------------------------------------------------+
|                    Rotifex Server                   |
|  +----------+  +------------+  +-----------------+  |
|  |  Fastify  |  |  Schema    |  |  SQLite (via    |  |
|  |  HTTP     |  |  Engine    |  |  better-sqlite3)|  |
|  |  Server   |  |  (live)    |  |                 |  |
|  +----------+  +------------+  +-----------------+  |
|  +----------+  +------------+  +-----------------+  |
|  |  JWT     |  |  Storage   |  |  AI / Agents    |  |
|  |  Auth    |  |  Manager   |  |  System         |  |
|  +----------+  +------------+  +-----------------+  |
|  +------------------------------------------------+  |
|  |         Admin SPA (React + Vite)               |  |
|  +------------------------------------------------+  |
+-----------------------------------------------------+

• Framework: Fastify v5 (Node.js)
• Database: SQLite via better-sqlite3
• Admin frontend: React 19 + Vite, served as a static SPA from /
• Config format: JSON (schema.json, ai.config.json, agents.config.json)
• Persistence: .env for secrets, JSON files for AI/agent config, SQLite for all app data

Installation

npm i rotifex

Then start the server:

npm start

Or run directly without installing:

npx rotifex start

Commands

Command	Description
start	Start the Rotifex development server