Skip to content

About

A reasoning skill for AI-assisted FileMaker development, built from production experience. No techniques, no knowledge files. It corrects one bias: an AI's tendency to mistake the common FileMaker solution for the one that holds up in production.

Topics

Resources

Stars

2 stars

Watchers

0 watching

Forks

Latest commit

 

History

8 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 

Repository files navigation

Stars License

FileMaker Second Opinion

A reasoning skill for AI-assisted FileMaker development. Built from production experience. Released as v1 after months of refining the logic against real work, now at v1.1.

It contains no techniques and no knowledge. It corrects one bias: an AI's tendency to mistake the common FileMaker solution for the one that holds up in production.

The problem

FileMaker's accessibility is its great strength. It is also the source of a quiet problem for anyone using AI to build in it.

A huge, capable, largely self-taught community means the platform's common patterns are everywhere in the material a model learns from. The deepest patterns mostly are not. The techniques that matter at scale live in client work and production systems that never got written up in public.

So the training data is weighted toward the common solution. And for a specific class of problems, the common solution and the professional one are not the same thing. A model gives you the common one, confidently, because that is what the weight of the data says.

This would not matter if wrong answers announced themselves. Many do. A bad calculation returns the wrong value, a mistyped field name throws an error, you fix it and move on.

The dangerous ones are different. The common answer works in the demo and degrades silently later. Record volume. Concurrent users. WAN latency. A growing found set.

A filtered portal that is fine on two hundred rows and unusable on two hundred thousand. A uniqueness constraint that holds on manual entry and does nothing on a scripted import. An unstored calculation that is instant when you test it alone and a bottleneck once real users are on the hosted file.

The schema looks right. The demo passes. It fails in production, quietly, weeks later, under conditions the original question never mentioned.

That gap is what this skill closes.

What it does

First it classifies. If this answer were wrong, would the user find out immediately? If yes, answer directly and stop. No ceremony.

If the failure could be silent, it drafts the obvious answer and then challenges it. What would a production developer reach for that the obvious answer misses? A less common approach, a different layer, a newer mechanism, knowledge from outside the usual FileMaker pattern.

Candidates get checked against the requirements the question actually states. The skill is not allowed to invent record counts, latency or scale to justify a fancier answer. If the question states a version, platform or execution context, that context must be respected.

A candidate that survives becomes the answer, with one line on why the common approach is weaker under the stated conditions. If nothing survives, it says so. The common answer done correctly is often already the professional one.

The goal is not more elaborate answers. It is making the model earn the right to give the obvious one.

Two disciplines inside that pass do a lot of the work.

The skill separates how FileMaker behaves from why it behaved that way in your file. A documented mechanism is fact. Whether it caused your symptom is a hypothesis until the evidence says so, and where possible the answer hands you a check that settles it.

The second is about how AI reads Claris Help, and this one you can demonstrate for yourself. Ask a model a FileMaker behaviour question and watch what it does. It searches, finds something that looks like the answer, and stops reading. But in Claris Help the behavioural reality often is not in the body text. It is in the Notes and platform sections underneath. The body says what a feature does. The Notes say when it does not, on which platform, in which execution context, under which conditions. A model that stops at the body gets the happy path and misses the exception that breaks your file.

The skill does not let a page count as read until the Notes and platform sections have been. It searches for the feature's own terminology rather than keywords that conveniently confirm the model's theory, and it keeps "I could not find it" separate from "Claris does not document it", which are different findings a first pass conflates constantly. During development, this discipline alone produced a striking improvement in right answers to the problems posed. Not the whole skill. Just reading the page properly.

The skill itself is deliberately short. There is nothing in it to look up.

What it is not

Not a knowledge file. No function reference, no technique catalogue, no worked recipes. That is the job of the reference repos below, and this composes with them rather than replacing them.

A model can have perfect access to the function reference and still choose the wrong architecture. It can quote the correct Help page and still diagnose the wrong cause. It can produce syntactically perfect XML and still build a system that degrades in production.

Knowledge solves knowledge problems. This addresses a reasoning problem.

Why it will not last

The skill is intentionally self-invalidating. As models improve and this way of thinking spreads, the gap between the common answer and the professional one closes, and the correction stops earning its keep. The skill says so itself, in its own final section: when the second pass consistently confirms the draft, retire it. That is the intended outcome.

Use it while the window is open.

Status

Built from using AI on production FileMaker work, watching where its answers held and where they quietly did not, and diffing the same problems solved with and without the skill until the difference was clear enough to write down. Every comparison was judged one way: did the result hold up in a real system. The strongest signal has been on production files, exactly the cases it was built for. Where a comparison needed a known-good baseline, one existed: a large body of accepted FileMaker answers built up over years of client and community work.

On that material it has changed answers that looked right but carried a silent production risk, and caught documentation and applicability gaps a first pass missed. Encouraging. Not a benchmark.

Versions

The file only changes when it loses. A loss is a live question where the skill ran and the answer was still wrong in a way no existing rule covers. The rule that would have prevented it gets written, the file gets retested against the triggering case, and the version bumps. No losses, no changes.

v1.1 — extraction truncation.

The triggering case, in full, because a loss on the record is worth more than a claim.

Question: why are Page Margins greyed out in the View menu?

Without the skill, the model answered from its training data: switch to Preview mode. Confident, plausible, wrong. Worse than wrong, self concealing: a user who follows it sees margins render in Preview anyway and believes the answer confirmed.

With the skill, the model fetched the right Claris Help page on the first attempt. Then it truncated its own extraction, a habitual limit on the output, and the cut fell partway through the Notes section. The two sentences that answer the question were below the cut. The model reported the Notes as containing nothing relevant, declared the documentation silent, and fell back to a hedged answer built on priors.

The answer was on the page the whole time: Page Margins shows margins in Layout mode, and margins do not display if the layout contains any navigation parts. New layouts ship with navigation parts by default. This is the normal case, one documented sentence, and a truncated read deleted it while leaving everything above it looking complete.

The rule that fell out of it: extract a reached page whole, and no Notes line without the page's end in the read. The skill already refused to count a page as read without its Notes. It never policed whether the read reached them. Retested against the triggering case in a fresh session, the fix held.

That is the whole method of this repo in one loss. The failure was not the model's knowledge and not the skill's logic. It was a pipe. Rules about reasoning cannot catch what never entered the reasoning.

Using it

The skill is a single file, SKILL.md. Nothing to build, nothing to configure.

For Claude Code, copy it into your project as .claude/skills/second-opinion/SKILL.md and it loads automatically. For claude.ai, add it to a Project's knowledge or attach it to a conversation. It works alongside other skills, including the reference repos below, and applies itself only to FileMaker technical work.

It needs a model that can search and fetch web pages to run the Claris Help grounding. Without that, the classification and challenge passes still work; the documentation discipline does not.

Loading the skill does not guarantee it runs in full on every message. It is guidance the model applies at its own judgement, not a hook that fires every turn, and a grounded lookup costs real tool calls, so a model under time or token pressure can under-invoke it. If a specific question matters enough to be sure the tail pass and the Claris Help grounding actually ran, ask for it directly — "give me a second opinion on this" or "run this through Second Opinion first" both work. Costs nothing extra if the question was visible class anyway.

The rest of the collection

Menu

Reference skills

FileMaker Second Opinion
FileMaker AI Vocabulary

Research / Specialist

FileMaker XML bit-flags (SaXML)
FileMaker AI Grammar

Generation, paste-ready FileMaker XML

Script XML Skill (XMSS, XMSC, XMFN)
Layout XML Skill (XML2)
Field, Table & Value List Definitions (XMFD, XMTB, XMVL)

Analyse a FileMaker solution in your browser

Clockwork Inspector (SaXML)
XML Scrubber (SaXML + others)

Licence

CC BY 4.0. Use it, adapt it, build on it, keep the attribution.

Andrew Kear · Claris Partner · Claris MVP · clockworkct.co.uk

About

A reasoning skill for AI-assisted FileMaker development, built from production experience. No techniques, no knowledge files. It corrects one bias: an AI's tendency to mistake the common FileMaker solution for the one that holds up in production.

Topics

Resources

Stars

2 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors