Airtable

Promptfree, for everyone, and the only version there is

Open the prompt in Claude CodeOpen the prompt in CodexOpen the prompt in Cursor

Copy

Build me a self-hosted structured-data app to replace one Airtable base, where nothing is ever silently overwritten.

STACK
- Astro with a Node adapter, SQLite via better-sqlite3
- Server-rendered HTML with progressive enhancement, no frontend framework

SCHEMA
- Tables defined in a JSON config with typed fields: text, long text, number, currency, date, single select with colours, multi select, checkbox, attachment path
- A link-to-record field storing ids of rows in another table, never labels
- Changing the config generates a migration; it never drops a column silently

GRID
- Inline editing, column sorting, and per-column filters that survive a reload through the query string
- Saved views declared in config, each with its own filter, sort and visible fields

THE CHANGE LOG, WHICH IS THE POINT
- Every field change appends a row: table, record, field, old value, new value, actor, UTC timestamp
- The current row is a view over that log, so the history is the data rather than a copy of it
- A history link on every record, showing what changed and when

FORMS
- A form view per table for outside contributors, writing straight into it with the same validation

API
- REST list, get, create and update with a token from the environment and cursor pagination

DATA
- CSV import and export, and a nightly SQLite backup script with a documented restore

Include a README on the config-to-migration step, the change log schema and the backup restore.