The world's first AIbuilt for Retail Pro Prism.
Most AI tools meet Prism for the first time when you ask a question. but PrismIQ AI grew up inside it. Built around Prism, your company structure, and your business vocabulary, it pulls every answer from your live database.
Ask anything, like you ask your team.
No query language. No reports to memorize. Just ask in plain English and get answers in seconds.
Before today, no one had built this.
You have probably tried connecting a generic AI to your Prism data. It responded with confidence. Then you checked the numbers and they were wrong. That is not a bug. That is what happens when AI has no idea what a held document is, what DESCRIPTION2 means in your business, or why a return line should reverse the sale. PrismIQ AI was built to know all of that before it answers a single question.
Built for Prism
PrismIQ AI capabilities
Understands Retail Pro Prism schema natively
Knows your stores, subsidiaries, and hierarchy
Speaks your business vocabulary out of the box
Reads live directly from your Oracle database
Understands your custom field meanings
Enforces store-level and subsidiary data scope
Approved SQL only, hallucinations not possible
Runs entirely on your own server
Full audit trail on every single answer
Configurable by business admins without code
Generic AI
ChatGPT
Generic BI
Power BI
Built for Prism
PrismIQ AI
Built by people who live inside Prism every day. For businesses whose entire operation depends on it.
Ask in plain English. Get accurate data.
Not a guess. A live, governed, SQL-backed fact pulled directly from your Oracle database in five steps.
You ask
Ask a question in plain English. No SQL, filters, or dropdowns required.
You ask
Ask a question in plain English. No SQL, filters, or dropdowns required.
AI understands
Intent, time periods, stores, and item codes are resolved automatically.
AI understands
Intent, time periods, stores, and item codes are resolved automatically.
RAG retrieves
The right Prism domain pack, metric definition, and SQL template are selected.
RAG retrieves
The right Prism domain pack, metric definition, and SQL template are selected.
Oracle executes
A read-only SQL template runs securely against your live Oracle data.
Oracle executes
A read-only SQL template runs securely against your live Oracle data.
Answer delivered
Results are narrated, visualized, and logged with a complete audit trail.
Answer delivered
Results are narrated, visualized, and logged with a complete audit trail.
Complete retail intelligence.
From executive sales summaries to store-level stockout alerts, PrismIQ AI covers the full breadth of Retail Pro Prism analytics. Ask in plain English. Get the answer your CFO, store managers, and merchandising team all expect.
Sales Intelligence
Inventory Management
Customer Analytics
Forecasting
Store 360
Returns & Exceptions
Tender & Payments
Promotion Intelligence
Data Quality
Purchasing & Receiving
Every answer is backed by an approved SQL template, executed against your live Oracle database, and logged to an immutable audit trail.
Before it answers, it thinks like Prism.
Every question passes through a governed reasoning stack before the final response appears.
Eight specialist engines. One accurate answer.
The LLM explains the answer, but PrismIQ AI resolves what is safe, scoped, relevant, and factual before the response is written.
Clarification
Catches vague questions before the AI guesses.
Entity Resolver
Finds stores, vendors, items, cashiers.
Answer Verifier
Checks scope, permissions, PII, and result safety.
Intent Classifier
Matches the question to the right retail intent.
Memory Rewrite
Turns follow-ups into complete business questions.
Time Resolver
Understands Ramadan, Q1, last month, Date Range.
Query Planner
approved SQL templates and bind parameters.
RAG Context
Retrieves Prism knowledge, metrics, aliases
Clarification
Catches vague questions before the AI guesses.
Entity Resolver
Finds stores, vendors, items, cashiers.
Answer Verifier
Checks scope, permissions, PII, and result safety.
Intent Classifier
Matches the question to the right retail intent.
Eight specialist engines. One accurate answer.
The LLM explains the answer, but PrismIQ AI resolves what is safe, scoped, relevant, and factual before the response is written.
Memory Rewrite
Turns follow-ups into complete business questions.
Time Resolver
Understands Ramadan, Q1, last month, Date Range.
Query Planner
approved SQL templates and bind parameters.
RAG Context
Retrieves Prism knowledge, metrics, aliases
Intelligence built only for Prism
The reason PrismIQ AI answers correctly where every other AI fails is not the language model. It is what the language model never has to guess at, because the answer is already known before the question is even fully processed.
Local Vector Database
All knowledge is stored in Chroma, running on your server. No cloud retrieval. No API calls. Your RAG index lives where your data lives and never leaves.
Local Vector Database
All knowledge is stored in Chroma, running on your server. No cloud retrieval. No API calls. Your RAG index lives where your data lives and never leaves.
Offline Embeddings
Semantic search powered by local Qwen3 embeddings. Questions are matched by meaning, not just keywords. Runs completely offline with no internet required.
Offline Embeddings
Semantic search powered by local Qwen3 embeddings. Questions are matched by meaning, not just keywords. Runs completely offline with no internet required.
Domain Knowledge Packs
Curated Prism knowledge covering Sales, Inventory, Customer, Loyalty, Employee, Tender, Promotions, Purchasing, Adjustments, and Data Quality.
Domain Knowledge Packs
Curated Prism knowledge covering Sales, Inventory, Customer, Loyalty, Employee, Tender, Promotions, Purchasing, Adjustments, and Data Quality.
Semantic Registry
Field mappings, store aliases, metric definitions, and SQL templates indexed by meaning. Ask about SAP Article Code and it knows exactly which column.
Semantic Registry
Field mappings, store aliases, metric definitions, and SQL templates indexed by meaning. Ask about SAP Article Code and it knows exactly which column.
Exact-Match Layer
Before any vector search, known aliases and metric names are matched exactly. Faster, cheaper, and more reliable than guessing.
Exact-Match Layer
Before any vector search, known aliases and metric names are matched exactly. Faster, cheaper, and more reliable than guessing.
Approved SQL Templates
Every answer comes from a pre-authored, guard-validated, Oracle-tested template. The AI selects the right one. It never writes SQL.
Approved SQL Templates
Every answer comes from a pre-authored, guard-validated, Oracle-tested template. The AI selects the right one. It never writes SQL.
The knowledge stays on your machine.
Retail moves fast. Your forecasts should too
Six forecast models powered natively inside Oracle. No external ML servers. Just auditable projections from your real historical data.
Daily Sales Forecast
Linear regression on your Oracle history with confidence intervals.
Per-Store Projections
R² scores tell you exactly how much to trust each store projection.
Stockout Risk
Days until stockout per item. Critical, Warning, and Watch levels.
Net Sales Forecast
UAE · Next 30 days
Regression model · 90-day lookback · R² threshold 0.40 · Oracle-native computation
Sell-Through Velocity
Project end-of-season sell-through by DCS category.
Seasonal Event Uplift
Eid, Ramadan, Black Friday. Estimate event-specific sales uplift.
Customer Churn Risk
Score every customer as High, Medium, or Watch risk.
Just ask. PrismIQ AI listens intelligently
Ask business questions out loud and PrismIQ AI turns speech into instant retail intelligence. It listens naturally, transcribes in real time, and delivers accurate answers from your business data.
Live voice query
Ready
Speak a question to PrismIQ AI…
The right view for every question.
Ask about hourly sales and get a heatmap. Ask about store performance and see every location on a map. The right chart chooses itself based on what you asked.
Bar, Line & Area
Time-series trends and period comparisons.
Forecast Chart
Historical data with projected confidence bands.
Heatmap
Hour-by-day sales density at a single glance.
Treemap
Category hierarchy sized by contribution.
Scatter Chart
Correlate any two metrics to find outliers.
Geo Map
Store performance pinned by GPS location.
Enterprise-grade. On your terms.
Security is not a feature layer added on top — it is the foundation every other capability is built on. PrismIQ AI was built governance-first.
100% On-Premise
Installed on your head-office server. Your Prism data never leaves your network. No cloud dependency.
Read-Only Oracle Access
Read-only credentials enforced at the database level. The AI cannot modify, delete, or insert a single row.
Row-Level Security
Store managers see their store. Country managers see their country. Scope is enforced on every query.
Zero Free-Form SQL
The LLM never writes SQL. Every query comes from a pre-approved, guard-validated template.
PII & Cost Permissions
Customer names, emails, cost figures, and margin data are shown only to authorized groups.
Full Audit Trail
Every question, query, and configuration change is logged with timestamp, user, IP, and metadata.
Configurable audit retention · Compliance-ready from day one · No data sent to third parties
Every answer comes with receipts.
PrismIQ AI does not ask you to trust a black box. Every response includes the exact execution trace behind the result.
AI Answer
Top stores by net sales
Dubai Festival City is leading this month with AED 428,500 in net sales, followed by Dubai Mall and Yas Mall. Results are scoped to your permitted stores.
Provenance Panel
Full answer trace
Click Provenance to see exactly how this answer was produced, which SQL template ran, what parameters were used, and which checks passed.
Every answer knows what you should ask next.
PrismIQ AI does not stop at the first result. It inspects the returned rows, detects context and anomalies, then recommends the most useful follow-up questions.
AI Answer
Sales dropped 12.4%
Dubai Mall underperformed last week, mostly from lower weekday traffic and higher discount pressure in two DCS categories.
Recommended drilldowns
Drilldowns are generated from the actual result shape, anomaly patterns, template context, and available business dimensions.
It understands retail time.
Ask about Ramadan, Eid, Q1, Black Friday, Diwali, season-to-date, or same-period-last-year. PrismIQ AI converts business language into exact Oracle date ranges before the query runs.
Natural language time resolver
Business event → Exact Oracle date filter
Ramadan
“Compare Ramadan with last year”
Oracle date range
2026-02-17 → 2026-03-18
Eid
“Show Eid uplift by store”
Oracle date range
2026-03-19 → 2026-03-22
Q1
“Q1 sales by subsidiary”
Oracle date range
2026-01-01 → 2026-03-31
Same period last year
“Compare with same period last year”
Oracle date range
2025-05-01 → 2025-05-10
Season to date
“Show summer season to date”
Oracle date range
2026-04-01 → 2026-05-10
Black Friday
“Black Friday promotion lift”
Oracle date range
2026-11-27 → 2026-11-30
One question. Eight verified steps.
PrismIQ AI moves from user context to live db in milliseconds, then returns a verified answer with a complete audit trail.
Prompt
Show top stores by net sales this month
Step 01
Authenticate
User permissions loaded.
Step 02
Apply RLS
Store scope enforced.
Step 03
Retrieve context
Aliases, metrics, and mappings matched.
Step 04
Plan query
Approved SQL template selected.
Step 05
Execute Oracle
Read-only live data returned.
Step 06
Verify answer
Permissions and sensitive fields checked.
Step 07
Write response
Verified result explained.
Step 08
Audit trail
Execution metadata logged.
Configured for your retail language.
PrismIQ AI understands the way your business talks because admins can configure every field,
Business admins can tune the AI without touching code.
Configuration is not hidden inside engineering files. Your admin team can teach PrismIQ AI how your company names stores, defines metrics, protects sensitive fields, and classifies forecast risk.
Field Mappings
Turn Prism columns into business language your team already uses.
Store Aliases
Resolve DFC Store, Dubai Mall, or any local nickname to the right Prism store.
Currency Rules
Format every money value with the correct store or subsidiary currency.
Metric Dictionary
Define net sales, discount, tax, inventory value, and margin once.
SQL Templates
Keep answers accurate with approved, tested, admin-viewable templates.
Forecast Thresholds
Set your own risk windows, churn days, R² gates, and forecast horizon.
Stop waiting for reports. Start asking to AI.
PrismIQ AI is built for Retail Pro Prism. It understands your stores, your metrics, your custom fields, and your live Oracle data from day one.
Ready to see it working on your Prism data?
Request access and see how PrismIQ AI turns plain English questions into governed, accurate retail answers.