MESExplorer
Explore PowerCo MES events in Databricks from one read-only desktop tool.
MESExplorer permits queries only and cannot write or modify Databricks data.
Connection
Workspace
Warehouse
Version
Database Explorer
Browse catalogs, schemas, tables, structure and data previews.
SQL Explorer
Run read-only SQL with searchable results, JSON expansion and export.
Cell History
Complete event history and timeline for a CellID.
Scan on site
Read a QR code or barcode and open the matching CellID or WPC history immediately.
Scanned items
Continue on a browser or laptop from the CellIDs and WPCs scanned with your account.
MES Topology Explorer
Browse known areas, stations, descriptors and payload types.
Timeline
Visual comparison of process steps.
AI Investigation
Highlight deviations, missing steps and possible MES transaction issues.
Diagnosztika
Check token, user, warehouse and Databricks API connectivity.
Scan CellID or WPC
Use the device camera on site. The code is sent only to MESExplorer; Databricks remains accessible exclusively from the server.
Start the camera for live detection, take a high-resolution photo, or select an existing image.
Manual entry
The phone never receives or stores a Databricks access token.
Scanned
Codes scanned with your signed-in account, available for continuation in the browser-based application on a laptop or phone.
Loading scanned items…
Database Explorer
Browse Databricks catalogs, schemas and tables directly in the application.
Objects
No table selected
Select a table.
SQL Explorer
Raw Event Search
Cell History
Track the complete lifecycle and journey of a Cell ID.
Scan or enter a full or partial Cell ID, or leave it empty to list all matching cell events.
WPC History
Track WPC lifecycle, process events and cell occupancy over time.
Enter a full or partial WPC ID, or leave it empty to list all WPC events matching the filters below.
Timeline
Visualize a CellID or WPC journey as an ordered process sequence, including station changes, alarms and unusually long gaps.
Enter an identifier and build the timeline.
Investigation Board
Saved incidents, findings and engineering investigations grouped by workflow status.
Loading saved investigations…
Start or continue an engineering investigation
Open a WPC, CellID, station, alarm or message in one read-only workspace. Scanned Data remains available as a first-class handover and recent-history view.
Create a persisted investigation or open one from the board.
Investigation Summary
Deterministic read-only evidence analysis. No root-cause claim is made.
Subject context
Evidence policy
AI Investigation
Read-only incident investigation built from the existing Alarm, Message, CellID and WPC History functions. This foundation is deterministic and does not execute or generate SQL.
/api/alarm-history, /api/message-history, /api/cell-history and /api/wpc-history. Direct SQL, database writes and arbitrary tool calls are not available to the investigator.Incident source
Select an alarm in Alarm History and choose Investigate.
Alarm History
Investigate alarm events with structured context suitable for troubleshooting and future AI-assisted root-cause analysis.
Choose filters or search all alarms.
Message History
Explore every MES message and raw payload. Alarm context navigation opens this view for the same area and a ±15 minute time window.
Choose filters and run the query.
MES Topology Explorer
Known MES areas, stations and source descriptors extracted from the alarm dataset. These values are also preloaded into all history filters.
Known payload types
Evidence-based catalog extracted from observed raw payload structures. Labels describe the observed message purpose; vendor specification remains authoritative.
| Payload | Meaning |
|---|
Settings
Read-only view of the current connection settings.
Loading…
Developer Console
Full technical details of the latest application query.
Status
Duration
Statement ID
Warehouse
Generated SQL
No query yet.
Parameters
No query yet.
Databricks response
No query yet.
Query History
About MESExplorer
Read-only investigation tool for PowerCo MES data in Databricks.
- Product
- MESExplorer
- Company
- Vabis Kft.
- Author
- Balint Varga
- balintvarga@vabis.hu
- Security model
- Strictly read-only SQL and data exploration
- Version
- —
- Environment
- —
- Build
- —
Connection diagnostics
Use this page for authentication and Databricks connection troubleshooting.
Token
Not run yet.
API
Not run yet.