A Schema-First View of Your FileMaker Pro Solution

DbSchema connects to a hosted FileMaker Pro file over JDBC and turns the tables and relationships the driver exposes into an ER diagram — the conventional view audits, handoffs, and migration projects ask for.

Turn table occurrences and fields into a standard ER diagram
Run SQL against the hosted file from a desktop client
Generate handoff documentation clients browse without FileMaker
Plan migrations to PostgreSQL or MySQL from a clear structural map

available for

ISO-27001 certified

Free Community Edition No signup required 15-day Architect trial included

Free Download

DbSchema showing a FileMaker Pro solution as an ER diagram

Trusted by teams at

A Relationship Graph Only
Its Author Can Read

A FileMaker solution that grew for years turns its relationship graph into a thicket of table occurrences — obvious to the developer who built it, opaque to auditors, clients, and whoever inherits it next.

DbSchema reads the schema through FileMaker's JDBC interface and draws the picture everyone else understands: tables, fields, and relationships in ER form.

Understand, Query & Hand Off
the FileMaker Data Model

Standard database tooling for a very non-standard database.

Reverse engineer FileMaker table occurrences and fields into a diagram

The Data Model Behind the Layouts

DbSchema discovers table occurrences, field types, and relationship definitions from FileMaker Server's JDBC interface and renders them on a visual canvas.

Run SQL queries against FileMaker Pro data in DbSchema

Query FileMaker Like a SQL Database

Run SQL over the JDBC connection to check data, verify assumptions, and extract records — from the same client you use for every other database.

Split a FileMaker solution into focused diagrams in DbSchema

One Focused Diagram per Module

Break a large solution into diagrams per functional area, then export them to PDF or SVG for review meetings and migration specifications.

Handoff Documentation
Generated, Not Rewritten

Export interactive HTML5 documentation of tables, fields, and relationships, and give the next developer — or the client taking ownership — a browsable reference that requires no FileMaker access at all. Ideal for solution handoffs, audits, and the planning phase of a move to a relational database.

Explore the Documentation Tool

HTML5 schema documentation generated from a FileMaker Pro solution

Enabling JDBC Access to a Hosted File

The file must be open and hosted on FileMaker Server, with ODBC/JDBC sharing enabled for it in the server's Admin Console — a local FileMaker Pro file with no server running is not reachable over JDBC. Then register the FileMaker JDBC driver (fmjdbc.jar, from FileMaker developer resources) in DbSchema under Connections > Manage Drivers.

The connection uses port 2399 and a URL of the form jdbc:filemaker://host:2399/dbname, where dbname is the hosted database file's name. Setup details are on the FileMaker JDBC driver page.