BetaBetaBetaFileMaker Schema Intelligence Quotient
Understand Your FileMaker System in Minutes
Upload your FileMaker DDR and instantly uncover architecture insights, dependencies, technical debt, and change impact from your FileMaker system.
Platform Capabilities
What FMSchemaIQ Does
FMSchemaIQ helps developers, consultants, and business teams analyze DDR files, understand system logic, and plan changes with confidence.
Find Broken FileMaker References Before They Break Your System
FMSchemaIQ scans your DDR and highlights missing fields, missing tables, missing scripts, and other broken references that can silently damage scripts, calculations, layouts, relationships, and workflows.
Detect Critical Missing References
Identify missing fields, tables, scripts, layouts, table occurrences, value lists, and other DDR-level broken references in one pass.
Prioritize by Impact
Broken references are surfaced as high-impact issues because they can affect scripts, calculations, layouts, relationships, reports, and integrations.
Track Cleanup Progress
Drill into each occurrence, mark items as resolved, add remediation notes, and watch live resolved/remaining counts per report.
Broken References
186 total · 24 resolved · 162 remaining
162
remaining
- CriticalMissing Fields88 total · 78 remaining
- CriticalMissing Tables51 total · 44 remaining
- CriticalMissing Scripts47 total · 40 remaining
Why FileMaker DDR Analysis Is Difficult
FileMaker DDR (Database Design Report) contains everything about your system, scripts, tables, relationships, layouts, but it isn't built for people to actually read.
- It's extremely large and hard to navigate
- Relationships and dependencies are not easy to trace
- Script logic is buried in raw text
- Understanding system structure takes hours (or days)
For most teams, DDR becomes a reference file, not a usable tool.
Turn Your DDR into Actionable Insight
FMSchemaIQ converts your DDR into a structured, interactive view of your system. Instead of reading raw data, you can:
Visualize how scripts connect and execute
Understand system structure instantly
Identify complexity and hidden dependencies
Explore your database in a meaningful way
What used to take hours can now be done in minutes.
What You Can Do with DDR Analysis
Understand System Structure
Get a clear view of how your database is organized, tables, relationships, and dependencies.
Analyze Script Logic
Break down complex scripts and see how they interact across your system.
Identify Complexity and Risks
Spot deeply nested scripts, heavy dependencies, and areas that may cause issues.
Support Development Decisions
Make informed decisions before modifying or expanding your system.
Compare System Changes Across Versions
Understand what changed between versions of your FileMaker system. including scripts, tables, fields, relationships, and layouts, in one structured overview. Drill down into any modified script for a full step-level diff.
- System-level summary across every catalog
- Auto-matched scripts across DDR versions
- Click-through drill-down to script diffs
Compare changes or instantly generate release documentation
How It Works
No setup. No configuration. Upload your DDR and get instant insights.
- 1
Upload your DDR file securely
Your data is processed securely
- 2
Instantly analyze your entire system structure
Scripts, tables, relationships, and layouts
- 3
Explore scripts, relationships, and logic in one place
Drill down into details instantly
- 4
Identify risks, insights, and next steps instantly
Make informed decisions faster
Safe to Upload. Your FileMaker DDR Stays Private and Protected.
Your DDR contains system structure, not business records, and is handled securely at every step.
No Business Data Involved
A DDR includes system structure only, no records, no customer information.
Secure Upload and Storage
Your DDR is transmitted and stored using industry-standard encryption.
Private Access Only
Only your account can access your reports. No shared or public access.
Fully Automated Processing
Your DDR is analyzed automatically, not manually accessed.
You Stay in Control
You can delete your reports at any time.
Minimal Retention by Design
Your DDR is stored only for analysis and access, never used beyond your account.
You can upload your DDR with confidence, your system structure stays protected.
Need help generating your DDR? We're happy to assist, your file remains secure throughout the process.
Need help understanding your DDR or results? We're happy to guide you.
Who This Is For
FileMaker Developers
Quickly understand existing systems, debug issues, and work more efficiently.
Business Owners
Gain visibility into your system and understand what's happening behind the scenes.
Technical Managers
Evaluate system health, complexity, and potential risks before making changes.
Explore by Topic
Dive deeper into the area that matters most to you.
What Is a FileMaker DDR?
A FileMaker DDR (Database Design Report) is a comprehensive export of your database structure. It includes:
- Scripts and script steps
- Tables and fields
- Relationships
- Layouts
- Value lists and more
While it contains everything, it is not designed for easy interpretation, which is why analysis tools are essential.
Why DDR Analysis Matters
Without proper analysis
- Systems become difficult to maintain
- Changes introduce unexpected issues
- Dependencies are missed
- Performance problems go unnoticed
With proper analysis
- You understand your system clearly
- You reduce risk
- You save development time
- You make better decisions
Frequently Asked Questions
Quick answers to common questions about FMSchemaIQ and FileMaker DDRs.
What is a FileMaker DDR?+
A Database Design Report is an XML/HTML export of your FileMaker system structure, scripts, tables, fields, relationships, and layouts. It contains no business records.
Is my DDR safe to upload?+
Yes. Your DDR is transmitted and stored using industry-standard encryption, scoped to your account only, and never used beyond your analysis.
How long does analysis take?+
Most DDRs are processed in under a minute. Larger systems may take a few minutes depending on size and complexity.
Do I need to install anything?+
No. FMSchemaIQ runs entirely in your browser, no plugins, downloads, or setup required.
Can I delete my reports?+
Yes. You stay in control and can remove any report from your account at any time.
Can I get help with my FileMaker system or project?+
Yes. If you need help with an existing system, new development, or implementing improvements identified in your DDR analysis, you can reach out for direct assistance.
Still have questions? We're happy to help.
Ready to See Your FileMaker System Clearly?
Upload your DDR whenever you're ready, or explore a sample first to see what you'll get.