Brandedflow airtable-schema-designer

Design Airtable base schemas, field types, views, automations, and linked records. Use when creating or modifying Airtable structures for client or internal bases.

install

source · Clone the upstream repo

git clone https://github.com/JenCW/brandedflow

Claude Code · Install into ~/.claude/skills/

T=$(mktemp -d) && git clone --depth=1 https://github.com/JenCW/brandedflow "$T" && mkdir -p ~/.claude/skills && cp -r "$T/.claude/skills-library/airtable-schema-designer" ~/.claude/skills/jencw-brandedflow-airtable-schema-designer && rm -rf "$T"

manifest: .claude/skills-library/airtable-schema-designer/SKILL.md

source content

Airtable Schema Designer

When to Use

Designing a new Airtable base for a client
Adding tables or fields to the master base
Planning automations within Airtable
Documenting existing schema

BrandedFlow Context

Master base ID:
```
appYXzdeB0MUlwqFN
```
Source of truth for all business data
Per-client bases created during onboarding via
```
create-client-folder
```
MCP

Design Process

Define entities — What are the main objects? (Leads, Clients, Projects, Contacts)
Map relationships — Which tables link to which? Define linked record fields.
Define fields — For each table: field name, type, required?, notes.
Define views — Grid, Gallery, Kanban, Calendar — one per workflow.
Define automations — Trigger (record created/updated) → action (send email, webhook, update field).

Field Type Reference

Type	Use for
Single line text	Names, titles, short strings
Long text	Notes, descriptions, rich text
Single select	Status, stage, category (fixed options)
Multiple select	Tags, services (multi-value)
Linked record	Relationships between tables
Lookup	Pull field from linked record
Formula	Calculated values
Date	Dates with optional time
Phone/Email/URL	Validated contact fields
Attachment	Files, images
Checkbox	Boolean flags
Autonumber	Unique IDs

Output Format

Produce schema as a table:

Table: [Name]
| Field | Type | Notes |
|-------|------|-------|
| Name | Single line text | Required |
| Status | Single select | Options: New, Active, Closed |
| Client | Linked record → Clients | |

Plus: automations list, views list, relationships diagram (text).

End of Task

State: "END-OF-TASK: Directive [updated/N/A]. Self-annealing [N/A]."