# FileMaker 2026 builds a full schema from plain SQL: tables, fields, relationships, indexes. No plugins. Hand an AI agent one .fmscript example and it builds Northwind in seconds

**URL:** <https://the.fmsoup.org/t/filemaker-2026-builds-a-full-schema-from-plain-sql-tables-fields-relationships-indexes-no-plugins-hand-an-ai-agent-one-fmscript-example-and-it-builds-northwind-in-seconds/5797>\
**Category:** Resources\
**Tags:** filemaker, fmscript, ai2fm\
**Created:** [September 28, 2026, 8:12pm UTC](https://the.fmsoup.org/t/filemaker-2026-builds-a-full-schema-from-plain-sql-tables-fields-relationships-indexes-no-plugins-hand-an-ai-agent-one-fmscript-example-and-it-builds-northwind-in-seconds/5797 "2026-09-28T20:12:01Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Axelar](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/axelar/32/3090_2.png) [@Axelar](https://the.fmsoup.org/u/Axelar)\
**Post date:** [September 28, 2026, 8:12pm UTC](https://the.fmsoup.org/t/filemaker-2026-builds-a-full-schema-from-plain-sql-tables-fields-relationships-indexes-no-plugins-hand-an-ai-agent-one-fmscript-example-and-it-builds-northwind-in-seconds/5797/1 "2026-09-28T20:12:01Z")

</div>

![image](https://canada1.discourse-cdn.com/flex030/uploads/fmsoup/original/2X/f/fd7d6224666756ce199fb8240d82f659a2783223.jpeg)

The Execute SQL script step has been able to do this for years, through a loopback ODBC DSN that points the file at itself. **FileMaker 2026 makes it better:**

FOREIGN KEY now creates the relationship in the graph (2025 can't)

User Name and Password are calculations, so credentials can come from variables

DROP TABLE works, but Claris doesn't document it anywhere

NUMERIC(2,2) truncates, it doesn't round

I wrote it up with 12 working examples, full CRUD, plus a security section. fmxdbc is a second door into your file, and DDL doesn't need Full Access.

Article: [The Forgotten Superpower of FileMaker 2026: SQL CRUD – Axelar](https://axelar.eu/the-forgotten-superpower-of-filemaker-2026-sql-crud/)

Files: [GitHub - DimitrisKok/filemaker-2026-sql-crud: Build a FileMaker Database from SQL text. Working FileMaker 2025/2026 SQL CRUD, schema, ODBC, and calculated SQL examples. · GitHub](https://github.com/DimitrisKok/filemaker-2026-sql-crud)

Every script in the repo is also a **.fmscript** file: plain text you can read, diff and keep in git without opening FileMaker.

That's the open format we're building at [https://fmscript.org](https://fmscript.org/), where the full Execute SQL reference lives too.