Skip to content

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

Description

@retikachakraborty

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

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions