For one person, the core of Airtable is a typed table on top of SQLite with a grid, a kanban board, a calendar, linked records, formulas and CSV in and out. In our test an agent built all of that from the prompt below in about 15 minutes, and it ran on the first try. What you give up is the team side: editing with other people in real time, interface pages, automations and the mobile apps. If you need those, self-hosting Teable, Baserow or NocoDB is a shorter path than building.
Before you buildIf one base stays under 1,000 records and you work alone, Airtable Free may already be enough.
Build me a personal table database to replace Airtable. Requirements:
- Node.js 22 + TypeScript: a Fastify API and a React front end built with Vite.
`npm start` builds the UI and serves everything on http://localhost:4600.
- Storage: better-sqlite3 in ./data/tables.db. Uploaded attachments go to
./data/files/ with the record id in the filename.
- Bases hold tables. Field types: text, long text, number, checkbox, single
select, date, URL, attachment, and link to a record in another table.
- Grid view with inline editing; add, rename, reorder and delete fields; sort
and filter; save named views per table with their sort and filter.
- Kanban view grouped by a single-select field (drag cards between columns) and
a month calendar view placed by a date field.
- Formula fields evaluated with `mathjs` (a locked-down instance: disable import,
createUnit and evaluate inside formulas), with {Field Name} references and IF,
CONCAT, ROUND and DATEDIFF helpers. Results recalculate on every edit.
- CSV import (header row becomes fields, guess number/date/checkbox types, show
a preview first) and CSV export of the current view.
- A JSON REST API: GET/POST/PATCH/DELETE /api/tables/:table/records.
- Single user. No accounts, no telemetry, local-first.
- Out of scope: real-time multi-user editing, automations, interface pages,
mobile apps.
- README with setup, where the data lives and how to back it up.Opens your agent with the prompt filled in, you press enter. Or copy it and paste it into an empty folder.
The first prompt builds the core. Run these one at a time in the same folder to grow it into your own Airtable.
Add an Airtable importer to the table app in this folder. Requirements: - Read AIRTABLE_TOKEN (a personal access token) and a base id from .env. - Use the Airtable Web API to read the base schema, create matching tables and field types, then copy every record, page by page, respecting the 5 requests per second limit. - Recreate linked-record fields after all tables exist; download attachments into ./data/files/ before their URLs expire. - Fields with no matching type become text, and the importer lists them. - Update the README with the token scopes needed.
Add automations to the table app in this folder. Requirements: - Triggers: record created, record updated with a field matching a value, and a daily time. - Actions: update a field, create a record in another table, POST JSON to a webhook URL, and send an email through SMTP settings in .env. - A page to list, enable and disable rules, with a log of the last 100 runs. - Out of scope: scripting actions and third-party app connectors. - Update the README.
Add public forms to the table app in this folder. Requirements: - For any table, build a form by picking fields, labels and required flags. - Serve it at /f/:formId; submissions create records, attachments included. - Optional: listen on 0.0.0.0 only when FORMS_PUBLIC=true in .env, and serve nothing but form routes on that port. - Rate-limit submissions per IP. - Update the README with how to expose the form port through a tunnel.
Teams pay because non-developers can model their own data and build working tools on top of it without asking anyone. Once processes, automations and interfaces sit on a base, moving them is more work than the seat price.
Estimate · Runs on your machine with no services to pay for. The build is token usage on your agent plan; a VPS for remote access would add a few dollars a month.
| Plan | Monthly | Annual, per month | What you get |
|---|---|---|---|
| Free | $0 | $0 | Up to 5 editors, 1,000 records and 1 GB of attachments per base, 100 automation runs and 1,000 API calls a month, 2 weeks of history, 500 AI credits. |
| Team | $24 | $20 | 50,000 records and 20 GB per base, 25,000 automation runs and 100,000 API calls a month, 1 year of history, 15,000 AI credits. |
| Business | $54 | $45 | 125,000 records and 100 GB per base, 100,000 automation runs, unlimited API calls, 2 years of history, 20,000 AI credits. |
| Enterprise Scale | custom | — | 500,000 records and 1,000 GB per base, 500,000 automation runs, 3+ years of history. |
Free covers up to 5 editors and 1,000 records per base, with 100 automation runs a month.
Yes. An AI coding agent such as Claude Code, Codex or Cursor can build a usable personal version in one session with the prompt on this page, running on your own machine.
About $24 a month on the Team plan per seat, $288 a year (checked 2026-10-13).
Real-time editing with teammates and comments; Interface pages and automations; The mobile apps; Synced tables and hundreds of integrations; Templates and the built-in AI fields. If any of those matter to you, keep paying.
Yes: Teable (open source), Baserow (open source), NocoDB (free).