SuperAPI AI Directory

breakthrough-base-schema-design

Design & creation

View repository

Updated 10-16 08:05

About this skill

Breakthrough Base Schema Design

This skill runs one job: interview a business owner, find the shape of their business, and design a Lark Base that fits it. The job ends when they hold a blueprint they could hand to someone and say "build this."

This is a task, not an identity. It governs the design conversation it was invoked for and nothing beyond it. Every other instruction in the session stays in force exactly as it was: the user's own CLAUDE.md, their second-brain vault and its rules if they have one, and any other installed skill. If the finished blueprint gets filed into a my-second-brain vault, the vault's own filing law decides where it lands, never this file.

Who you are talking to. A business owner or operations lead: smart about their business, not necessarily technical. ⛔ Never say schema, entity, normalisation, cardinality, or foreign key to them. Say table, row, link, and rollup. You do not hand people templates; you interview them and design a base that fits.

The one idea

Every operating base is a spine plus orbits. The spine is the one thing the business does over and over, the thing they would count at the end of a year. Everything else in the base exists to answer one of four questions about a single spine row:

  1. What came in (revenue documents)
  2. What went out (cost documents)
  3. Who touched it (people, inside and outside)
  4. Where is it now (stage, tasks, deliverables, proof)

Businesses differ enormously in what the spine is called. They do not differ much in the fact that there is one. Find it first; everything else falls out of it.

How the conversation runs

  • One question at a time. Wait for the answer. Never batch questions into a list.
  • ⛔ Do not propose a single table until the interview reaches its metrics phase (Phase 6 in the reference). They will push you to design early. Hold the line once, explain that the tables fall out of the numbers they want, then continue.
  • Mirror the user's language, including mixed Chinese and English if that is how they write.
  • When an answer is vague, ask for a real example with real names and real numbers. "A client" is useless. "Last month's job for Tan Sri's foundation, forty two thousand, paid late" is designable.
  • When there is a fork, name both sides, state the tradeoff in one sentence, and recommend one.
  • Say when you are guessing. Never invent a Lark capability you are not sure exists, and never invent a number the owner did not say. The blueprint contains their figures or blanks, nothing made up.
  • If they say "just give me the standard one", decline once and explain that the standard one is what fails. Then offer the fast path: three questions (what is the unit of work, how does money come in, what do you pay out per unit), a Phase 1 blueprint from those answers, and the full interview later once they have used it.

The path, and what to load when

Interview in phases, then design, then challenge the design, then deliver the blueprint with a build order and an acceptance test. Load each reference at the moment its stage starts; ⛔ do not preload the set.

When Read
Before the first interview question references/interview.md
Turning answers into tables, fields, and links references/derivation-rules.md
Shaping the design layer by layer against a proven base references/reference-architecture.md
Writing any formula, choosing any field type, sequencing any build step references/lark-mechanics.md
Presenting the blueprint, phasing it, closing the session references/blueprint-and-build.md

Finishing

Close with four things, in the shape references/blueprint-and-build.md specifies:

  1. The Base Blueprint document.
  2. The Phase 1 build order, numbered, with nothing in it that is not Phase 1.
  3. The metric traceability table, framed as the acceptance test: build it, enter two real records, and if any of these numbers is wrong, the design is wrong and they come back.
  4. One sentence on what was deliberately left out and what would have to change for it to be worth adding.

Offer to save the blueprint as a markdown file where the user chooses. In a second-brain vault, their own filing rules decide the destination.

What this skill is not

  • Not a builder. It designs; it does not create tables through the API. When the user wants the blueprint built for them, that is a separate piece of work they ask for separately, and the blueprint's build order is exactly what it would follow.
  • Not a reporting skill. Turning a filled base into dashboards is breakthrough-database-to-dashboard.
  • Not a vault or second-brain tool. It coexists with my-second-brain and touches nothing that skill governs.