Grid
Virtualized spreadsheet with inline edit, grouping, and 30 field types.
Airtable-class · AI-native
Lattice is a database, project tracker, and client portal in one. Model anything as tables and linked records, see it in eight views, and let an AI agent and Claude Code keep it up to date, through the same guarded rules your team uses.
Live at lattice-amber.vercel.app · built on Next.js, Neon & Vercel
| Project | Phase | Owner | Priority | Client |
|---|---|---|---|---|
| OCR pipeline | Build | DKDavid | High | Acme Co |
| Lead scoring model | QA | DYDavid Y | Medium | Northwind |
| Client portal v2 | Launch | DKDavid | High | Acme Co |
| Karbon sync | Backlog | SMSam | Low | Internal |
| Weekly report bot | Build | DYDavid Y | Medium | Northwind |
What it is
Under the hood everything is data: bases hold tables, tables hold typed fields and linked records, and one query layer renders every view. Every change, whether a person, an automation, the agent, or Claude Code made it, goes through the same rules and lands in a full revision history. That is what lets AI safely run alongside your team instead of around it.
Eight ways to see the same data
Filter, sort, group, hide fields, and set row height on any of them. Share a read-only link and hidden fields are stripped on the server.
Virtualized spreadsheet with inline edit, grouping, and 30 field types.
Drag cards between stacks; the board writes straight back to the record.
Drag to reschedule; dates sync back instantly with a full audit trail.
Card view for anything visual, with attachment thumbnails.
Nested, hierarchical rows for outlines and sub-tasks.
Dependency arrows and a computed critical path, not just bars.
Build a form, publish a public link, collect straight into a table.
KPI, chart, and grid tiles you can add, move, and resize.
The AI agent
Reach the agent from in-app chat, Slack, text or iMessage, or email. It reads and edits through the same guarded rules a person does, so every action is attributed and logged. Destructive actions are dry-run first and wait for your confirmation.
For developers
Every write path, the UI, REST, the agent, MCP, automations, and forms, runs through one guarded mutations layer. That means a single security boundary and a complete audit trail no matter how the data changes.
# Airtable-compatible: list records from a table curl https://lattice-amber.vercel.app/api/v0/ai-projects/tasks \ -H "Authorization: Bearer $LATTICE_TOKEN" # Update through the same guarded layer everything uses curl -X PATCH ".../api/v0/ai-projects/tasks/rec_812" \ -H "Authorization: Bearer $LATTICE_TOKEN" \ -d '{ "fields": { "Phase": "QA", "Priority": "High" } }' // every change -> revisions + change_events outbox { "id": "rec_812", "revision": 44, "actor": "api" }
Everything else in the box
30 types including formula, rollup, count, and lookup, all computed on read. Select choices carry stable ids and colors; tables get their own autonumber.
Symmetric relationships between tables, so a task knows its project and the project knows its tasks.
Record, schedule, and webhook triggers with nestable conditions and repeats; find, create, update, email, and webhook actions, with run history.
Clients and staff land in a scoped portal that only shows their own projects. Fields marked hidden are redacted on the server, and comments are allowed.
Every record keeps a before/after history with one-click revert. Soft-delete trash means nothing is truly gone by accident.
Drag-and-drop file uploads on any record, an expanded record modal, and threaded comments.
An import wizard that infers field types, detects select options, and loads into a new or existing table.
Cmd+K to jump to any base, table, view, or record without leaving the keyboard.
Neon point-in-time recovery, a nightly encrypted export to a private Drive, and per-record revision history you can revert in-app.
Lattice is live. Sign in and start moving your work into it.
Open Lattice