Problem
An Airtable base can become difficult to maintain as duplicate fields, inconsistent statuses, and weak relationships accumulate. Reviewing those issues requires seeing the structure and sample data together.
Problem
Airtable Base Doctor
An Airtable review app that checks schema and sample records, then generates interface previews, redesign proposals, and migration plans.
Project at a glance
- My responsibility
- Built the application across product design, OAuth integration, analysis, data storage, generated previews, and report exports.
- AI / Workflow Tooling
- A list of schema problems is only part of a useful review. Operators also need to see possible changes, understand their impact, and decide what to do first.
- Diagnostics
- Four categories
- Reports
- Redesign plans + exports
- Integration
- OAuth + snapshots
Next.jsTypeScriptAirtableOAuthPrismaPostgreSQL
Product screens
Report Export
The recommendation set can be packaged into a print-friendly artifact for stakeholder review and rollout planning.
Health Score Overview
The opening surface frames overall base health, top recommendations, and generated opportunity areas in one pass.
Redesign Workspace
Analysis findings roll directly into proposal variants, migration planning, impact review, and guarded write-back guidance.
Health Score Overview
The opening surface frames overall base health, top recommendations, and generated opportunity areas in one pass.
Report Export
The recommendation set can be packaged into a print-friendly artifact for stakeholder review and rollout planning.
Redesign Workspace
Analysis findings roll directly into proposal variants, migration planning, impact review, and guarded write-back guidance.
The work
Problem, implementation, and result.
01
Build
I built a read-only Airtable integration that runs diagnostic checks and presents the findings alongside dashboard, form, and portal previews. A redesign workspace turns recommendations into proposals, migration plans, and exportable reports.
System design
Outcome
The app combines diagnostic checks, interface previews, and redesign reports in one review workflow. It proposes changes without writing them back to Airtable.
Delivered behavior
Framing
Scope and constraints.
A list of schema problems is only part of a useful review. Operators also need to see possible changes, understand their impact, and decide what to do first. I built the diagnostic checks, then added interface previews and redesign planning. AI summaries sit separately from the findings so readers can distinguish measured problems from generated recommendations.
Technologies
Next.js
TypeScript
Airtable
OAuth
Prisma
PostgreSQL
OpenAI
Key features in scope
OAuth-based Airtable connection with cached schema and sample-record analysis
Health scoring across schema quality, workflow quality, data quality, and UX opportunities
Generated dashboard, intake form, and client portal previews from detected schema structure
Redesign workspace with proposal variants, issue-resolution mapping, migration planning, and impact previews
Exportable redesign brief and PDF-style report with evidence and sample-record previews
Suggestions that distinguish possible future write-back features from changes a person must make manually
Responsibility and context
Role: Built the application across product design, OAuth integration, analysis, data storage, generated previews, and report exports.
Category: AI / Workflow Tooling
Engineering
Architecture and decisions.
I built a read-only Airtable integration that runs diagnostic checks and presents the findings alongside dashboard, form, and portal previews. A redesign workspace turns recommendations into proposals, migration plans, and exportable reports.
Technologies
Next.js 16
React 19
TypeScript
Tailwind CSS v4
shadcn/ui
Recharts
Next.js Route Handlers
Better Auth
Architecture choices
Next.js 16 App Router application split into marketing, demo, and authenticated workspace route groups
OAuth-backed Airtable integration with encrypted token storage, schema snapshots, sample-record fetches, and webhook-triggered reanalysis
Deterministic analysis engine that profiles each base and runs schema, workflow, data-quality, and UX-opportunity checks
Preview generation for dashboards, forms, and portals based on detected schema patterns
Redesign workspace for proposals, issue-resolution mapping, migration plans, impact previews, and report exports
PostgreSQL + Prisma persistence for users, bases, snapshots, analyses, generated assets, request logs, and webhook events
Key decisions
Keep deterministic findings separate from AI summaries so readers can inspect the evidence behind a recommendation
Provide a demo workspace so visitors can explore the workflow before connecting an Airtable account
Keep the integration read-only and distinguish suggested changes from actions the app can perform
Store schema snapshots and analysis runs for comparison across reviews
Results
Results and limitations.
The app combines diagnostic checks, interface previews, and redesign reports in one review workflow. It proposes changes without writing them back to Airtable.
Delivered behavior
Built a workflow from diagnostic findings through redesign proposals and migration planning
Generated dashboard, form, and portal previews from detected schema patterns
Added shareable briefs and report exports with evidence and sample-record previews
Constraints
Airtable access had to stay safe and permission-aware while the product remained read-only
Analysis needed to show the evidence and limits of each heuristic check
Complex schema changes had to be explained clearly enough for non-developers to review
Redesign guidance needed to work without the optional AI and export features
Lessons
What the build taught me.
01
Connect diagnostic findings to proposed changes that a person can review
02
Show heuristic evidence separately from generated explanations
03
A read-only integration still needs clear permission boundaries and token handling
04
A demo workspace helps explain an integration before asking for access
Retrospective
I would add an opt-in integration for low-risk additions to a base, with approval before each write. I would also expand the redesign workspace for connected bases beyond the demo examples.
More case studies
Digital Platform / AI
Dr. Anne Hussain Platform
A book, blog, and podcast platform with an assistant that retrieves published passages and presents source citations.
Read case study
AI / RAG
PlatoAI
A philosophy dialogue app with five conversation modes, retrieval from primary texts, and a source panel for checking passages.
Read case study
AI / Social Product
TweetNet
A social simulation where configurable AI personas write posts and respond to one another in a shared feed.
Read case study
SaaS / Productivity
CamelCollect.io
A web app and browser extensions for saving LinkedIn posts into organized collections, with onboarding and subscription billing.
Read case study