Categories
Self-Hosted Data Management Spreadsheet Backend as a Service Database Management No-Code Database Low-Code PlatformStars
Forks
Watchers
Developer links
Undb
Undb turns a browser tab into a full-featured database with spreadsheet-style editing, auto-generated REST APIs, and five configurable views for every table. The platform organizes data through Spaces, Bases, and Tables, offering grid view for traditional editing, Kanban boards for workflow tracking, calendar for date-based planning, gallery for image-rich records, and pivot tables for analytical summaries, each with independent filtering, sorting, color coding, and field selection. An ANTLR4-powered formula engine provides Airtable-style calculated fields with proper syntax validation, variadic argument handling, and type-checked function signatures that go beyond simple string interpolation. Every table automatically generates a fully documented OpenAPI REST endpoint with Swagger UI, letting developers integrate Undb data into external applications through standard HTTP methods without additional configuration. The Drizzle ORM abstraction layer supports four database backends (SQLite, PostgreSQL, MySQL, and Turso edge-distributed SQLite) with separate migration configurations for each adapter. Authentication uses Lucia with OAuth2 via Arctic for GitHub login and Oslo for TOTP two-factor authentication. The SvelteKit 5 frontend renders through Houdini's compile-time GraphQL client and TanStack Svelte Query, while the Elysia.js backend compiles into a single executable via Bun's --compile flag, embedding all assets into one portable binary. File attachments store in any S3-compatible backend including MinIO. Running on a dedicated VPS on RepoCloud with guaranteed CPU, RAM, and SSD, full root SSH access, and a browser serial console. AGPL-3.0 licensed.
Benefits
- Single-Binary Portable Deployment
- Bun's compile flag packages the entire TypeScript backend, SvelteKit frontend, and embedded assets into one executable file requiring zero runtime dependencies for instant server deployment.
- Multi-Database Backend Flexibility
- Drizzle ORM abstraction supports SQLite, PostgreSQL, MySQL, and Turso edge-distributed SQLite with independent migration configurations, enabling progressive scaling from single-file to distributed stacks.
- Auto-Generated OpenAPI Endpoints
- Every table automatically produces documented RESTful API endpoints with integrated Swagger UI, enabling external application integration through standard HTTP methods without manual coding.
- Privacy-First Offline Operation
- Local-first architecture stores all data in SQLite by default with optional S3-compatible file storage, ensuring full functionality without continuous internet connectivity for data sovereignty.
Features
- Five Configurable Views
- Grid, Kanban, calendar, gallery, and pivot views with independent filtering, sorting, color coding, and field selection per view instance.
- ANTLR4 Formula Engine
- Type-checked formula fields using ANTLR4-generated parser with custom function registry supporting variadic arguments and syntax validation at definition time.
- Built-in Form Builder
- Create shareable data entry forms linked to tables with customizable fields, validation rules, and public submission URLs for external data collection.
- OAuth2 Authentication
- Lucia-based auth system with Arctic OAuth2 for GitHub login, Oslo TOTP two-factor authentication, and role-based access control for multi-user environments.
- GraphQL and REST APIs
- Dual API access via auto-generated OpenAPI REST endpoints with Swagger documentation and Houdini compile-time GraphQL client for type-safe frontend queries.