Free Airtable Base Audit Tool - broken references, orphan relationships, incomplete formulas and more
Hello!
I've extracted one feature from my product and made it available for free public use.
It accepts an Airtable base schema and checks for things like:
- Broken references in formulas, such as references to deleted fields
- Unsafe formula operations that may result in
NaN,Infinity, or invalid date values - Inconsistent casing
- Inconsistent number and date configurations
- Stale field names - for example, a field still called
Name (from Contact)even though the linked field is now calledOwner - And a number of other structural issues
The results are shown directly on a diagram of the base. If you click a formula or rollup field, it highlights the full chain of dependencies.
The audit itself does not use AI. All checks are deterministic and pre-built. The main Orloi product uses AI heavily, but I wanted this tool to be predictable and transparent (and free).
If you use the Paste schema option, everything is validated directly in your browser and nothing is sent to the server. If you connect Airtable directly, the base schema is processed but not persisted.
Hope this is useful. I'd be very interested in feedback, especially on additional checks that would be worth adding.
I'm also considering automation validation, although that would necessarily require an Airtable connection.
https://orloi.ai/airtable-base-audit/
Note: For very large bases, you'll currently need to use the Paste schema option because the connected version can hit server payload limits. A fix is planned.