Empowered Agents

Empowered Data Solutions

Real-time AI-Powered Agents for FileMaker Automation

Real-time LLM automation for FileMaker—run AI agents, scripts, and data tools with one click.

Empowered Agents is a comprehensive FileMaker demo solution that transforms your database into an AI-driven workspace. With one “Start Agent” button on any layout, you launch a real-time LLM session (via the OpenAI Realtime API) powered by an internal “EmpoweredCore” orchestrator script. Behind the scenes, EmpoweredCore:
• Loads agent definitions (name, system prompt, allowed tools, model override) from the Agents table
• Fetches model metadata and your stored API key via the GetAPIKey script
• Streams chat frames in a loop, parsing tool_calls and invoking FileMaker scripts as tools
• Validates every tool call against its JSON schema in the Tools table using VerifyJSON
• Aggregates tool outputs back into the conversation until the LLM returns a final answer

The demo includes:
• Agents table for persona/configuration
• Tools table (16+ scripts) with JSON-defined parameters (find, SQL, navigation, charting, custom JavaScript libraries)
• Models table to manage and switch between LLM endpoints and token limits
• Sample data (Companies, Contacts, Orders, Products, etc.) spanning ten years of transactional history
• Layouts & scripts wired for drag-and-drop extensibility

Developers can:
• Inspect schema (get layouts, fields, table occurrences)
• Query data (PerformFindByCriteria, ExecuteSQL, summary stats)
• Ingest or export (ImportJSONRecords, ExportFoundSetAsJSON, container fetch/export)
• Visualize (ApexCharts + Mermaid.js + Leaflet in Web Viewers)
• Extend by adding new tools (custom FileMaker scripts or JS libs) and linking them via ToolIDs
• Deploy as a training kit, sandbox, or production-grade framework

Whether you’re automating complex decision trees, dynamic reporting, or human-in-the-loop approvals, Empowered Agents shows how to safely and scalably embed LLM intelligence into FileMaker—no external middleware required.