Skip to main content
Database Schema

Design System Schema

The single source of truth for how everything looks.

A work in progress
We've published these resources in the hope they're useful — you're welcome to copy or use anything you find on this site. We're still working through each record to optimise it for completeness and accuracy, so some entries are fuller than others for now.

What it stores

The single source of truth for how everything looks. Colours, type, spacing, components, and motion all live here, so every site and document pulls from the same definitions instead of hard-coding values.

Owned by the Design agent. Lives in the Internal Tools database · design schema.

The tables

Friendly names first, with the real table name underneath. Key fields only.

Design Tokensdesign.tokens

Every colour, font, spacing, shadow, and motion value in the brand — the values everything else references.

Columns in the design.tokens table
ColumnType
nameHuman name, e.g. Brand BlueText
tierprimitive, semantic, or componentChoice
token_typecolour, typography, spacing, shadow…Choice
valueThe actual valueText
css_varThe CSS variable nameText
value_darkOptional dark-theme overrideText

Componentsdesign.components

The catalogue of reusable interface components.

Columns in the design.components table
ColumnType
nameText
categoryprimitive, content, layout, navigation…Choice
descriptionText
component_groupGrouping for the galleryText

Relationships

  • one-to-manydesign.component_variants. A component has many variants

Component Variantsdesign.component_variants

Each component's specific variations, with ready-to-use HTML and CSS that consumers drop straight in.

Columns in the design.component_variants table
ColumnType
nameText
themelight, dark, or brandChoice
component_htmlReady-to-use markupText
component_cssReady-to-use stylesText
usage_notesHow to compose itText

Relationships

  • one-to-onedesign.components. Belongs to one component

Motion Presetsdesign.motion_presets

Named animation recipes — the keyframes and timing for consistent motion.

Columns in the design.motion_presets table
ColumnType
nameText
categorye.g. enter, emphasisText
keyframesThe animation stepsStructured
transitionDuration and easingStructured

You don't need all of this to start

Most of what these agents rely on has a simpler equivalent. Anywhere we use a database, you can usually start with a spreadsheet or a document — whatever you're comfortable with. Anywhere we built a custom MCP server, you can reach for a prebuilt AI connector instead of building your own.

We go further because it's where our experience pays off. Years of hands-on database work make a custom data layer feasible for us, and purpose-built MCP servers let us hand each agent a short, sharp instruction file and exactly the tools it needs — custom descriptions, only the endpoints we want, and the occasional extra gate — instead of a long manifesto or playbook. Nothing more, nothing less.

Ready to build technology that works for your mission?

Tell us where your organisation is and what's slowing your team down. We respond personally.

FAQ — Knowledge Base

Browse frequently asked questions about Knowledge Base

Request an Invitation to the MMP

Mission Multiplier cohorts form on a rolling basis. Request an invitation and we'll reach out when a cohort that fits you is coming together. No payment until you're invited and confirm your spot.