Skip to main content
← Tool Garage

Data station

Airtable

A spreadsheet that behaves like a database, with real field types and links between tables.

1. Learn it

  • Halfway between a sheet and a database: columns have types, so a date is a date and a number is a number.
  • Tables can link to each other — a customer with many orders — which a plain sheet fakes badly.
  • You get forms, views and filters without building any interface.
  • Excellent for the back office of a small product. Not where you'd put a million rows.

Cost: Free tier with record limits.

2. Practice it

Simulated — nothing real happens

Find the relationship

Take 'customers' and 'orders'. Write which table each field belongs in, and how one row connects to the other.

3. Connect it

Real — your own account
  1. 1Create a free base at airtable.com and build your two practice tables.
  2. 2Add a linked field between them and watch what happens to the other table.
  3. 3Grab an API key only when something else needs to read it — and keep it server-side.
Open Airtable

MessyDev never signs you up, spends your money, or touches your accounts. You do that part.

4. Use it

Internal tools, content calendars, waitlists, and the admin side of an early product.

Honest alternatives

There is no single correct stack. Any of these would be a reasonable choice instead.

  • Notion databases
  • Google Sheets
  • A real database

More in Data