SQLexplorer lets you use FileMaker metaphors you already know, like Relationships, Search, Sort, and more, to write sophisticated SQL queries.
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.
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.
Jason Young, the author of SQLexplorer has done a great job documenting each step of creating queries, providing detailed videos as you go. We’ve been using this tool internally for a while now to get our own queries written faster (and error free). We think you’ll really find this useful.
For the Pros: Abstracted Queries
The latest explorer (March 1, 2013) lets you copy abstracted queries to your clipboard: these are less verbose and survive field renaming, so if you’re past learning SQL, this option is for you.
Going Further (The Newest SQLExplorer)
Jason has added a lot of refinements to the new SQLexplorer–stuff the pros will really like–while adding a whole new way of refining queries for those of us not adept and stringing “And” clauses together.
This version uses jQuery and HTML5 for displaying query results and you’ll love what this lets you do.
Saved Queries
Save, edit, and expand your queries, creating a library of those you frequently use.
Select Fields
No more typos: click the fields you'd like to query then edit your queries later once they're already working.
Test & Copy Query
See the results of your query then copy and paste it into your own file.
Getting Started & Docs
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.