FMSchemaIQ

Documentation

FMSchemaIQ Docs

Learn how to upload a FileMaker DDR, explore your report, and get the most out of every feature.

Last Updated:

FMSchemaIQ analyzes your FileMaker Database Design Report (DDR) and turns it into a structured, navigable view of your system, scripts, tables, relationships, layouts, and dependencies.

Who it's for

  • FileMaker developers working with existing or inherited systems
  • Consultants auditing client solutions
  • Technical managers and business owners who need visibility

Problems it solves

  • Reading raw DDR XML by hand is slow and error-prone
  • Hidden script and table dependencies make change risky
  • System complexity is hard to quantify or communicate

1. Generate your DDR in FileMaker

In FileMaker Pro Advanced, open Tools → Database Design Report, select the files to include, and export as XML.

2. Upload to FMSchemaIQ

Sign in, then drag your DDR file (or zipped DDR folder) into the uploader. Add basic context, solution name, purpose, environment, so the analysis can be tailored.

3. Review your report

Once processing completes you'll land on the report. Free Starter shows a top-level snapshot; unlocking with credits reveals the full insight set.

Try this →Upload your first DDR

DDR Upload & Analysis

Upload a FileMaker DDR XML (or zipped export). FMSchemaIQ parses it in your browser and builds a structured health report.

How to use it

  1. Go to Upload and drop the DDR file (up to 500 MB).
  2. Fill in solution name, purpose, and environment.
  3. Wait for processing, large files may take 30–60 seconds.

When to use

Whenever you start analyzing a new system, or want to re-check after major changes.

Notes

Processing happens client-side; the file isn't sent to the server until you save the report.

Try this →Open the uploader

Script Flow

Visualize how a script calls sub-scripts and how logic branches. Choose between flow modes, pin nodes, and pan/zoom the graph.

How to use it

  1. Open a report and select a script in the Script Flow section.
  2. Use the controls to switch flow mode, zoom, or reset the view.
  3. Pin important nodes to keep them visible while exploring.

When to use

Use it when tracing complex execution paths or onboarding to an unfamiliar script.

Try this →See a sample report

Script Comparison

Compare two scripts side-by-side, unified, or as a summary. Diffs are FileMaker-aware and normalize step parameters and references.

How to use it

  1. From a report, open Script Compare and pick two scripts.
  2. Switch between Side-by-side, Unified, and Summary views.
  3. Use Copy or Download to export the diff for review.

When to use

Use when reconciling versions, reviewing a refactor, or auditing changes between environments.

Change Impact Analysis

Describe a planned change in plain language and get a structured assessment: feasibility, impacted scripts and tables, and risks.

How to use it

  1. In your report, open Change Impact Analysis.
  2. Pick a change type (e.g. Integration) and describe the change.
  3. Review the AI-assisted impact summary and use it to plan work.

When to use

Before starting development on a non-trivial change, or when scoping work for a client.

Notes

This feature uses credits per analysis.

Global Search & Filters

Search across scripts, tables, fields, layouts, and value lists from anywhere in the report.

How to use it

  1. Open Global Search from the report toolbar.
  2. Type a name or keyword; pick a result to jump to it.
  3. Use category filters to narrow the result set.

When to use

Whenever you need to locate something fast in a large solution.

Consultant Report Export

Download a polished PDF summary of the analysis suitable for sharing with clients or stakeholders.

How to use it

  1. Open the report and choose Download / Export.
  2. Pick which sections to include.
  3. Save the generated PDF.

When to use

When delivering findings to a non-technical audience or archiving an audit.