VibeCraft: AI-Powered One-shot Dashboard Generator Agent

An Agentic AI tool that transforms SQLite data into executable React dashboards with a single prompt using Gemini CLI and MCP Server. Removes ambiguity through prompt layering to generate consistent quality outputs. Won Special Award in a public-private partnership competition with 1000+ participating teams.

Architecture

Competition Competition

2025

Public-Private Partnership Competition

Tech Stack

Gemini CLI MCP React TypeScript Agentic AI

Highlights

Won Special Award in competition with 1000+ teams (hosted by Ministry of Science and ICT)
Auto-generates executable React dashboards with one-shot prompt
Dynamic DB structure analysis via MCP Server (mcp-server-sqlite)
Removes ambiguity through prompt layering (GEMINI.md + TemplateEngine + PromptBuilder)
Published as npm package (vibecraft-agent), open source

Key Tasks

One-shot Prompt Architecture Design

Designed prompt layering structure (removes ambiguity layer by layer)
GEMINI.md system prompt (fixes tech stack/patterns)
TemplateEngine (detailed requirements per visualization type)
PromptBuilder (dynamic assembly of schema+template+user request)

MCP Server Integration

mcp-server-sqlite setup and integration
Utilized list_tables, describe_table, read_query tools
Configured real-time DB exploration environment for LLM

SchemaAnalyzer Implementation

Auto-extraction of SQLite table/column structure
Data type analysis and query example generation
Schema info formatting for prompt insertion

Visualization Template Development

time-series, geo-spatial, kpi-dashboard, comparison templates
Specified component structure, required features, package versions
Vite + React 18 + TypeScript + Recharts + Tailwind stack

npm Package Publishing

CLI interface implementation
vibecraft-agent npm package publishing
Open source release

삶을 기록하는 두 축

Architecture