AbiData
Open source · self-hosted · MIT

Your data, your server, your workspace.

Build datasheets, queries, forms, reports and Lua automations in the browser, then share them with your team. One Go binary. SQLite or PostgreSQL. No account with anyone else.

Get started Read the docs View on GitHub

Microsoft Access ideas, rebuilt for the web and for teams.

The Orders datasheet in the Northwind Traders sample workspace: a dense grid of records with sortable columns and a navigation pane of tables, queries, forms and reports.

Everything a small team needs to run on its own data

Each object kind has its own colour and its own editor, and they all work together.

  • Datasheets and table design

    Typed fields, lookups, calculated columns, validation, record history with field-by-field conflict resolution, and CSV, Excel or JSON import.

  • Visual and SQL queries

    Drag-and-drop joins, grouping and filters for builders, plus a sandboxed read-only SQL editor with parameters and hard row and time limits.

  • Forms

    A canvas form builder with subforms and event hooks. Phone-friendly, with GPS capture and photo attachments for field work.

  • Banded reports and PDF

    Grouped tabular and columnar reports with maps, images and totals, printed or exported as PDF from the server.

  • Lua scripts

    Sandboxed Lua 5.1 with memory and CPU limits, a dialect-neutral query builder, an analysis toolkit and an egress allowlist.

  • Scheduled jobs

    Run any script on a cron schedule and inspect every run, its output and its errors.

  • Public apps, no accounts

    Bundle forms and reports into a standalone app behind an unguessable link, for surveys, orders or public reporting.

  • User blogs

    Markdown authoring with live preview, published as static HTML with Atom feeds for each user.

  • SQLite or PostgreSQL

    One SQLite file per workspace out of the box, or a schema per workspace in your PostgreSQL cluster. Signed backups either way.

See it working

Screenshots from the Northwind Traders and Biosecurity Watch sample workspaces that come with every install, shown in the dark theme. The light theme is below.

The Orders datasheet with sortable columns, a filter and the navigation pane.
Keyboard-driven datasheetsSort, filter, search and edit in place, with a right-click menu and per-record history.
The visual query designer showing joined tables, selected output fields and criteria.
Visual query designerJoins, criteria, grouping and totals without writing SQL. Feeds forms and reports.
The SQL editor with syntax highlighting and parameter bindings.
Sandboxed SQLA read-only editor with parameters, execution budgets and tabular export.
The Record a sighting form with a map of quarantine zones and two attached photos.
Forms with maps and photosRecord sightings in the field with a GPS position, zones on a map and photo attachments.
A printable banded report open in the report viewer.
Banded reportsGrouped pages with headers, footers and totals, ready to print or export as PDF.
The Lua script editor with a script and its output.
Lua scriptsLogic for forms, reports and jobs, in a sandbox with strict limits.
The run history of a scheduled job with status and duration per run.
Scheduled jobsCron-driven scripts with a full run history.
The blog editor with Markdown on one side and a live preview on the other.
User blogsWrite in Markdown with a live preview and publish static pages.
The administrator dashboard with live telemetry, storage use and an audit trail.
AdministrationTelemetry, storage, audit trail, backups and the egress allowlist.

Light mode

Every screen also comes in a light theme with the same layout, palette and depth. AbiData follows your system setting, and you can switch from the user menu.

  • The workspace picker in the light theme, with the pine ridge banner and workspace cards.
    Workspace pickerEvery workspace you belong to, with your role in each.
  • The Orders datasheet in the light theme.
    DatasheetsThe same dense, keyboard-driven grid in birch and sage.
  • The visual query designer in the light theme.
    Visual queriesJoins, criteria and totals on a dotted canvas.
  • The administrator dashboard in the light theme.
    AdministrationLive telemetry, storage and the audit trail.

How it works

One process, one place for your data, nothing else to run.

  1. Run one binary

    The Go server embeds the React web app, the API and the scheduler. Ship it as a distroless container behind Caddy, or run the static binary yourself.

  2. Create a workspace

    Each project is an isolated workspace: its own SQLite file, or its own schema in PostgreSQL. Start from a sample or an empty one.

  3. Build in the browser

    Design tables, queries, forms, reports and scripts. Everyone you invite sees changes live, from a laptop or a phone.

  4. Share and automate

    Assign roles, publish public apps and blogs, schedule jobs, and use the REST API with scoped keys.

  • Go server
  • React web app, installable as a PWA
  • SQLite or PostgreSQL
  • OpenAPI 3.1 REST API
  • Lua 5.1 sandbox
  • Live updates over server-sent events

Quick start

Try it locally in a few minutes, or put it on a server with automatic HTTPS.

With Docker

Start a local instance on port 8080:

git clone https://github.com/AbishYoung/AbiData.git
cd AbiData
scripts/docker-dev.sh

Read the one-time setup token from the logs, open http://localhost:8080 and create the administrator:

docker compose -p abidata-dev -f compose.yaml -f compose.dev.yaml \
  logs abidata | grep setup_token

For a server with HTTPS through Caddy:

export ABIDATA_PUBLIC_URL=https://abidata.example.com
export ABIDATA_SITE=abidata.example.com
export ABIDATA_BOOTSTRAP_ADMIN_EMAIL=you@example.com
scripts/docker-prod.sh

As a single binary

Needs Go 1.24 or later and Node.js 24 (LTS) to build. The result is one static executable with the web app embedded:

git clone https://github.com/AbishYoung/AbiData.git
cd AbiData
make build
./bin/abidata serve

Set the same ABIDATA_* variables as for Docker, and put a TLS-terminating proxy in front. To store data in PostgreSQL instead of SQLite files, set ABIDATA_DB=postgres and the connection variables before the first start.

Prebuilt sources and notes for each version are on the releases page.

Read the full installation guide