Mission: Zava Agent Hub & SQLite Data Explorer (Microsoft Promptathon Solution)

Mission/open goal Description

Building an interactive agent hub, database schema viewer, SQL/Semantic Audit dashboard, and markdown exporter for the Zava DIY & Hardware Retail system. The application handles inventory, store locations, supplier networks, custom MCP skills, and semantic audit tracking for retail operation queries.

Harness and model

GitHub Copilot with GPT-5.5, Antigravity with Gemini and Claude Opus

Turn-by-turn journey

Prompt:
Build a comprehensive web application for managing Zava's retail database schema, custom MCP tools, semantic audit, and agent simulations.
Agent response or action:
Analyzed workspace requirements and constructed modular JavaScript files (app.js, db-schema.js, semantic-audit.js, agent-simulator.js, markdown-exporter.js) along with responsive vanilla CSS (styles.css).
Result:
A fully working, high-performance tabbed interface for Zava's Retail Agent Hub.

Prompt:
Add interactive schema exploration, custom MCP skills indicators, and agent execution workflow simulations.
Agent response or action:
Implemented ZavaDB schema parsing with interactive table inspect views, field relationships, and simulated agent query runs.
Result:
Users can visually inspect database tables, trace relationships, and test SQL and semantic queries directly within the interface.

Prompt:
Integrate a markdown export tool and semantic audit logger to summarize agent actions and findings.
Agent response or action:
Built markdown-exporter.js to convert schema summaries and audit logs into formatted markdown reports ready for export.
Result:
One-click generation of audit reports and solution summaries formatted for GitHub markdown.

Completion

• Yes, the agent completed the mission or goal.
• No, the agent did not complete the mission or goal.

Bonus work

Light/Dark Mode Theme Switcher: Persistent theme toggling stored via localStorage for seamless user experience.
Custom MCP Skill Badges: Automatic identification and visual highlighting of extended custom MCP skills within the database schema.
Interactive Markdown Exporter: Client-side markdown exporter utility allowing instant copying and downloading of generated submission logs and audit traces.

Source Code Repository: https://github.com/retikachakraborty/promptathon

The payload names app.js, db-schema.js, semantic-audit.js, agent-simulator.js, markdown-exporter.js, and styles.css, with source in the linked repository. Read those entry points to understand the completed agent hub; no unfinished task or acceptance criteria is provided, so there is no defined newcomer-sized “done” state.