UNDB logo

UNDB

Self-hosted no-code database and BaaS powered by SQLite

undb delivers a private-first, no-code database with a visual UI, formula fields, and OpenAPI support, deployable as a single binary or Docker container for rapid backend creation.

UNDB banner

Overview

Highlights

No-code visual UI for table creation and management
SQLite-backed storage with Excel‑like formula fields
Built-in playground mode and OpenAPI RESTful API
Deployable as a Bun binary or Docker container for progressive scaling

Pros

  • Private, local‑first data storage
  • Lightweight SQLite engine
  • Flexible deployment options
  • Formula support similar to Airtable

Considerations

  • Scalability limited to SQLite constraints
  • UI may lack advanced admin tooling
  • Binary packaging requires Bun
  • Community and ecosystem still growing

Managed products teams compare with

When teams consider UNDB, these hosted platforms usually appear on the same shortlist.

Airtable logo

Airtable

Cloud collaboration platform combining the flexibility of a spreadsheet with database power

AppSheet logo

AppSheet

No-code app builder to create data-driven web & mobile apps from sheets and databases

Backendless logo

Backendless

Backend-as-a-Service with database, realtime, auth, files, and cloud code

Looking for a hosted option? These are the services engineering teams benchmark against before choosing open source.

Fit guide

Great for

  • Small to medium teams needing a quick backend
  • Developers wanting a self‑hosted no‑code database
  • Startups prototyping APIs without server code
  • Organizations prioritizing data privacy

Not ideal when

  • High‑throughput enterprise workloads
  • Complex relational schemas beyond SQLite
  • Teams requiring extensive built‑in analytics
  • Users seeking a fully managed cloud service

How teams use it

Rapid MVP backend for a mobile app

Create tables, define formula fields, and expose OpenAPI endpoints without writing server code.

Internal knowledge base with custom views

Use the UI to build kanban, gallery, and calendar views, keeping data on-premises.

Self-hosted form submission platform

Deploy undb as a Docker container, collect form data via REST API, and store it locally.

Offline‑first data collection tool

Package undb into a single binary, run on edge devices, and sync when connectivity returns.

Tech snapshot

TypeScript63%
Svelte35%
Handlebars1%
CSS1%
JavaScript1%
ANTLR1%

Tags

airtablesvelteself-hostedairtable-alternativenocodesqlite3no-code-databasebackend-as-a-servicebaasbundomain-driven-designoffline-firstdddtypescriptdockersveltekitbackend

Frequently asked questions

How is data stored and secured?

Data resides in a local SQLite file; access is controlled by the server process, and the platform is designed for private-first deployments.

Do I need Docker to run undb?

No. You can run it as a single binary built with Bun, or use Docker for containerized environments.

Can I extend the API beyond the generated OpenAPI spec?

The built-in OpenAPI provides CRUD endpoints; custom logic can be added by integrating external services or using the playground mode.

Is there a limit to the number of tables or rows?

Limits follow SQLite's capabilities, which handle millions of rows per table; performance depends on hardware.

What licensing applies to undb?

The project is released under the AGPL-3.0 license.

Project at a glance

Stable
Stars
2,839
Watchers
2,839
Forks
146
LicenseAGPL-3.0
Repo age3 years old
Last commit6 months ago
Self-hostingSupported
Primary languageTypeScript

Last synced yesterday