Visual Query Grid (VisualGrid)

Status: Implemented (root-only access, 21 service tables).

Purpose

VisualGrid is a Temporal Directed Property Graph Explorer for the g3nretailstack ecosystem. It provides a read-only browser for traversing the DynamoDB tables of all 21 DynamoDB tables across 20 microservices as an interactive property graph. Designed for operators, platform engineers, and support staff.

Goals

• Unify the view across all 21 service DynamoDB tables as a single property graph.
• Provide context via metadata linking each node to service documentation, RECAP files, and MCP protocol definitions.
• Enable incident investigation, data integrity checks, onboarding verification, and architecture exploration.

Non-goals

• VisualGrid does not store or modify any service data.
• VisualGrid is not a general-purpose query tool (no filters, no aggregations).
• VisualGrid is not exposed to end users or merchants (root-only access).

Key capabilities

• Root auth: Scrypt secret code verification, 1h TTL tokens stored in DDB.
• Graph entry: Top-level view of all 21 service tables with PK prefix patterns and doc/MCP links.
• Node load: Load any DDB item by table + PK + SK with separated DDB keys and metadata.
• Node children: Paginated child traversal using SK prefix patterns from the graph registry.
• Node export: Single-node JSON export for clipboard or file download.
• Unredacted: Root-only access means all fields returned as-is. No untrusted users.

Cross-service interactions

• All 21 service tables: Read-only IAM grants to every service DynamoDB table.
• OPS: visualgrid_main permanently excluded from vacuum (secret code singleton, auth tokens).

Contract surface

• 8 API endpoints: root/auth, root/graph, node/load, node/children, node/export, node/history, schema, ping.
• Full contract details: VisualGrid Surfaces | VisualGrid Calls | VisualGrid OpenAPI