undb

undb is an open-source, self-hosted no-code database platform and Backend as a Service (BaaS) that allows users to build and manage custom data structures without writing manual schema code. The software is designed to bridge the gap between a flexible spreadsheet and a structured database backend.

The software is deployed as a server via Docker or can be packaged into a binary file using Bun for distribution. It provides a web-based user interface for table management, making it suitable for developers who need a lightweight backend for applications or for non-technical users who require a structured way to organize data. It supports a local-first workflow, ensuring that data remains private and accessible on the user's own infrastructure.

Key features

• SQLite based storage for lightweight data management
• User interface for visual table management
• Formula field support
• OpenAPI RESTful API support for external integrations
• Docker deployment for containerized environments
• Ability to package the backend into a binary file using Bun
• Local-first approach for private data hosting
• Built-in playground mode for testing without setup

The system is built using SvelteKit and Bun, utilizing SQLite3 as the underlying database engine to ensure portability and speed. This architecture supports progressive deployment, enabling a transition from a single local file to more complex cloud stacks depending on the scale of the project. By providing an OpenAPI compliant RESTful API, the platform allows developers to connect the no-code database to other frontend frameworks or external services while maintaining type safety.

undb is a flexible tool for those seeking a balance between a no-code spreadsheet experience and a functional backend service. It is intended for users who want to avoid the complexity of traditional database administration while retaining the ability to host their own data.