SQLexplorer lets you use FileMaker metaphors you already know, like Relationships, Search, Sort, and more, to write sophisticated SQL queries. You can then copy and paste the resulting queries right into your FileMaker 12 files with all the correct calculation syntax. Follow our simple SQL Wizard to create and test SQL queries against your own data.
Complete online documentation and step-by-step videos.
Learn FileMaker SQL using FileMaker metaphors you already know. Follow along in our wizard and you’ll be writing queries against your own data: queries you can paste into your own files.
Save, edit, and expand your queries, creating a library of those you frequently use.
No more typos: click the fields you'd like to query then edit your queries later once they're already working.
See the results of your query then copy and paste it into your own file.
I want to thank you for your free copy of SQL Explorer. I wanted to start using FileMaker's SQL function, but I was flailing. Your tool assisted me in making the statements I needed, quickly too! That in itself would have been enough, but it also quickly taught me quite a bit about SQL syntax. Within a very short time it has given me the confidence and know-how to write my own statements. Thank you!
- Dan Pouliot
SQL Explorer won the 2012 FileMaker Excellence Award Winner for "Solution of the Year."
I LOVE SQLExplorer!! Thankyou & thank again! @seedcode @TeraPicoData Abstracted copy rocks!! w00t!! :)
— Chiyoko Yoshida (more testimonials)
To start using the explorer you can jump right in by tweaking the queries it comes with. To get the most out of it, though, add table occurrences from your own files to the graph and you’ll be able to query your own data right in the explorer.
SQLexplorer is completely free to you to modify and extend; if you distribute it, please keep the attribution to SeedCode and our logo on the Queries layout.
Check out the docs to learn more.
We've written a series of blog posts on FileMaker SQL if you'd like to dig deeper.
