ExecuteSQL Compatible
Queries run against a real SQLite engine using FileMaker's ExecuteSQL dialect. What works here works in your database.
SQL Fiddle
Write & Test FileMaker ExecuteSQL Queries
A live SQL sandbox built for FileMaker. Run ExecuteSQL-compatible queries against your schema with real SQLite functions — no live server needed.
ExecuteSQL compatibleReal SQLite engineSchema autocompleteNo server needed
Features
Everything You Need to Write Confident SQL
Schema Autocomplete
Define your FileMaker schema once. Table and field names appear in autocomplete as you type, so you never mistype a field reference.
Instant Error Feedback
Syntax errors and missing field references are highlighted before you run. No more deploying a broken query to find out it fails.
SQL → FM Export
Generate CREATE TABLE statements in MySQL, PostgreSQL, or SQLite from your FileMaker schema with full constraints.
No Live Server Required
Mock your database structure in the Schema panel and run queries immediately. No FileMaker Server connection needed.
Works with Complex Queries
Aggregate functions, JOINs, subqueries, CASE expressions — test the full power of FileMaker's SQL support.
How It Works
From Schema to Results in Seconds
1
Define your schema
Paste your FileMaker table and field names into the Schema panel, or import them from a saved snapshot.
2
Write your query
Use the SQL editor with field name autocomplete. The editor knows your schema as you type.
3
Run and validate
Execute the query against the mock SQLite engine and see results or error messages instantly.
FAQ
Common Questions
Is this compatible with FileMaker's ExecuteSQL function?
Yes. The SQL Fiddle runs on SQLite, which is the same engine FileMaker uses internally for ExecuteSQL. Queries that pass here will work in FileMaker.
Do I need a FileMaker Server to use this?
No. You define your schema in the panel and run queries entirely in the browser against a mock database.
Can I use this with my real FileMaker schema?
Yes. If you have a Snapshot (Save a Copy as XML) uploaded to FM Dojo, your field and table names are already available in the Schema panel.