Query capabilities

Insight O' Mate is an operational intelligence tool designed for quick, ad-hoc queries against your NoSQL database. It excels at aggregating and filtering data, but it is not a replacement for a full Data Warehouse.

What it CAN do

The NLP engine maps your natural language questions into a structured AST (intent object) that supports:

• Aggregations & Metrics: Sums, averages, minimums, maximums, and counts (e.g., "What is the average order value?").
• Timeframes: Filtering by specific dates, ranges, or relative time (e.g., "How many signups last week?" or "Users created before 2024").
• Grouping: Grouping by categorical fields or time units (e.g., "Show me revenue grouped by month and country").
• Complex Filters: Using logical operators (AND/OR), inequalities, and boolean flags (e.g., "Active users who haven't purchased anything but logged in recently").
• Joins (NoSQL References): Following reference IDs across collections if your database supports it or via local aggregation logic.
• Sorting & Limits: Finding top/bottom records (e.g., "Top 10 customers by lifetime value").
• Visualizations: Suggesting the appropriate chart type (Bar, Line, Pie, or Table) based on the query structure.

What it CAN'T do

• Machine Learning / Predictions: It cannot forecast or predict future trends (e.g., "What will next month's revenue be?").
• Cross-Database Joins: It cannot join data between a MongoDB database and a Redis instance in a single query.
• Mutations: Insight O' Mate is strictly read-only. It will never generate a pipeline that writes, updates, or deletes data (no $merge, $out, etc.).
• Unstructured Text Search: While it can filter on exact strings, it does not currently act as a full-text search engine across large BLOBs or document bodies unless you are using a dedicated text index (like RediSearch).