🎯

drizzle-orm

🎯Skill

from naimalarain13/hackathon-ii_the-evolution-of-todo

VibeIndex|
What it does

Manages database schema and provides type-safe ORM (Object-Relational Mapping) functionality for the backend using Drizzle, enabling efficient database interactions and migrations.

drizzle-orm

Installation

Install skill:
npx skills add https://github.com/naimalarain13/hackathon-ii_the-evolution-of-todo --skill drizzle-orm
36
AddedJan 27, 2026

Skill Details

SKILL.md

Overview

# Hackathon II - The Evolution of Todo

Mastering Spec-Driven Development & Cloud-Native AI

This project demonstrates the evolution of a software application from a simple console app to a fully-featured, cloud-native AI chatbot deployed on Kubernetes. Built using Spec-Driven Development with Claude Code and Spec-Kit Plus.

Project Overview

This is a monorepo containing multiple phases of the Todo application evolution:

  • βœ… Phase I: Console App (Complete)
  • 🚧 Phase II: Full-Stack Web Application (In Progress)
  • ⏳ Phase III: AI Chatbot with MCP Server
  • ⏳ Phase IV: Local Kubernetes Deployment
  • ⏳ Phase V: Advanced Cloud Deployment

Quick Start

Phase 1 - Console App (Completed)

```bash

cd phase-1

uv venv

source .venv/bin/activate # Windows: .venv/Scripts/activate

uv sync

python3 src/main.py

```

Phase 2 - Full-Stack Web App (In Progress)

#### Frontend (Next.js)

```bash

cd frontend

npm install

npm run dev

# Opens on http://localhost:3000

```

#### Backend (FastAPI)

```bash

cd backend

uv venv

source .venv/bin/activate

uv sync

uvicorn main:app --reload

# Opens on http://localhost:8000

```

Project Structure

```

Hackathon II/

β”œβ”€β”€ phase-1/ # βœ… Phase I: Python Console App (Complete)

β”‚ β”œβ”€β”€ src/ # Source code

β”‚ β”œβ”€β”€ tests/ # Unit tests

β”‚ └── README.md # Phase 1 documentation

β”‚

β”œβ”€β”€ frontend/ # 🚧 Phase II: Next.js Frontend (In Progress)

β”‚ β”œβ”€β”€ app/ # Next.js App Router pages

β”‚ β”œβ”€β”€ components/ # React components

β”‚ β”œβ”€β”€ lib/ # API client and utilities

β”‚ └── CLAUDE.md # Frontend development guidelines

β”‚

β”œβ”€β”€ backend/ # 🚧 Phase II: FastAPI Backend (In Progress)

β”‚ β”œβ”€β”€ routes/ # API endpoints

β”‚ β”œβ”€β”€ models.py # Database models

β”‚ β”œβ”€β”€ middleware/ # Authentication middleware

β”‚ └── CLAUDE.md # Backend development guidelines

β”‚

β”œβ”€β”€ specs/ # Centralized Specifications

β”‚ β”œβ”€β”€ overview.md # Project overview

β”‚ β”œβ”€β”€ architecture.md # System architecture

β”‚ β”œβ”€β”€ features/ # Feature specifications

β”‚ β”œβ”€β”€ api/ # API specifications

β”‚ β”œβ”€β”€ database/ # Database schemas

β”‚ └── ui/ # UI specifications

β”‚

β”œβ”€β”€ history/ # Prompt History Records & ADRs

β”‚ β”œβ”€β”€ prompts/ # Development history

β”‚ └── adr/ # Architectural Decision Records

β”‚

β”œβ”€β”€ .specify/ # Spec-Kit Plus templates and scripts

β”‚ β”œβ”€β”€ memory/

β”‚ β”‚ └── constitution.md # Project principles

β”‚ └── templates/ # Spec templates

β”‚

β”œβ”€β”€ CLAUDE.md # Root development guidelines

└── README.md # This file

```

Technology Stack

Phase I: Console App βœ…

  • Language: Python 3.13+
  • Package Manager: UV
  • UI: Rich (colorful CLI) + Inquirer (interactive menus)
  • Storage: JSON file persistence

Phase II: Full-Stack Web App 🚧

  • Frontend: Next.js 16+ (App Router), TypeScript, Tailwind CSS
  • Backend: FastAPI, Python 3.13+
  • Database: Neon Serverless PostgreSQL
  • ORM: SQLModel
  • Authentication: Better Auth with JWT tokens
  • Deployment: Vercel (frontend) + Hugging Face (backend)

Phase III: AI Chatbot ⏳

  • UI: OpenAI ChatKit
  • AI Framework: OpenAI Agents SDK
  • MCP Server: Official MCP SDK
  • Database: Neon PostgreSQL (with conversations & messages)

Phase IV: Local Kubernetes ⏳

  • Containerization: Docker with Docker AI (Gordon)
  • Orchestration: Kubernetes (Minikube)
  • Package Manager: Helm Charts
  • AIOps: kubectl-ai, kagent

Phase V: Cloud Deployment ⏳

  • Cloud Provider: DigitalOcean Kubernetes (DOKS)
  • Messaging: Kafka on Redpanda Cloud
  • Runtime: Dapr
  • CI/CD: GitHub Actions

Features by Phase

Phase I (Complete) βœ…

  • Add,