Airtable Clone

Build databases the way you think.

Airtable Clone is a spreadsheet-meets-database web app that lets you design flexible tables, search records, and create custom views. It focuses on a clean UX, collaborative editing, and a fully type-safe backend.

Features

  • Spreadsheet-like grid with inline create, update, and delete
  • Table schemas with field types (text and number)
  • Saved views with filters, sorting, and grouping
  • Authenticated workspaces and per-table access control

Tech Stack

  • Framework: Next.js
  • API: tRPC (end-to-end typesafety)
  • Database: Prisma ORM
  • Auth: NextAuth
  • Language: TypeScript
nextjstrpcprismanextauthtypescript
Airtable grid viewAirtable table schema

Motivation

I love Airtable’s model of combining the familiarity of spreadsheets with database power. This project explores how far we can push that model using a fully type-safe stack and modern React tooling.

Learnings

  • Designing normalized schemas that also feel friendly in a grid UI
  • Implementing optimistic updates and conflict handling
  • End-to-end type safety with tRPC and Prisma models

Check it out

You can explore the live project here.