Hackathon Data

load_hackathon_data.cypher

// ============================================
// Hackathon Ecosystem Knowledge Graph
// Use case: Mentor-team matching & Judge-project matching
// ============================================

// Clear existing data
MATCH (n) DETACH DELETE n;

// ---- DEVELOPERS (Hackathon Participants) ----
CREATE (manish:Developer {name: "Manish", city: "Kolkata", experience: "3 years", role: "Full Stack"})
CREATE (ankit:Developer {name: "Ankit", city: "Bangalore", experience: "2 years", role: "ML Engineer"})
CREATE (priya:Developer {name: "Priya", city: "Delhi", experience: "4 years", role: "Frontend"})
CREATE (rohit:Developer {name: "Rohit", city: "Mumbai", experience: "1 year", role: "Mobile Dev"})
CREATE (sneha:Developer {name: "Sneha", city: "Kolkata", experience: "2 years", role: "Backend"})
CREATE (arjun:Developer {name: "Arjun", city: "Chennai", experience: "3 years", role: "Data Engineer"})
CREATE (meera:Developer {name: "Meera", city: "Pune", experience: "5 years", role: "Full Stack"})
CREATE (vikram:Developer {name: "Vikram", city: "Hyderabad", experience: "2 years", role: "ML Engineer"})

// ---- MENTORS ----
CREATE (deepak:Mentor {name: "Deepak", company: "Google", domain: "AI/ML", available: true})
CREATE (kavita:Mentor {name: "Kavita", company: "Razorpay", domain: "FinTech", available: true})
CREATE (sanjay:Mentor {name: "Sanjay", company: "Neo4j", domain: "Graph Databases", available: true})
CREATE (nisha:Mentor {name: "Nisha", company: "Flipkart", domain: "E-commerce", available: false})
CREATE (raghav:Mentor {name: "Raghav", company: "IIIT-H", domain: "NLP", available: true})

// ---- JUDGES ----
CREATE (drpatel:Judge {name: "Dr. Patel", affiliation: "IIT Kharagpur", expertise: "Computer Vision"})
CREATE (amita:Judge {name: "Amita", affiliation: "Microsoft", expertise: "Cloud & DevOps"})
CREATE (farhan:Judge {name: "Farhan", affiliation: "Sequoia Capital", expertise: "Startup Viability"})
CREATE (lisa:Judge {name: "Lisa", affiliation: "AWS", expertise: "Serverless & AI"})
CREATE (nikhil:Judge {name: "Nikhil", affiliation: "Postman", expertise: "API Design & DX"})

// ---- TECHNOLOGIES ----
CREATE (python:Technology {name: "Python", category: "Language"})
CREATE (react:Technology {name: "React", category: "Framework"})
CREATE (neo4j_tech:Technology {name: "Neo4j", category: "Database"})
CREATE (tensorflow:Technology {name: "TensorFlow", category: "ML Framework"})
CREATE (nodejs:Technology {name: "Node.js", category: "Runtime"})
CREATE (flutter:Technology {name: "Flutter", category: "Framework"})
CREATE (langchain:Technology {name: "LangChain", category: "AI Framework"})
CREATE (fastapi:Technology {name: "FastAPI", category: "Framework"})
CREATE (opencv:Technology {name: "OpenCV", category: "Vision Library"})
CREATE (solidity:Technology {name: "Solidity", category: "Smart Contracts"})

// ---- TRACKS (Hackathon Categories) ----
CREATE (aitrack:Track {name: "AI for Social Good"})
CREATE (fintrack:Track {name: "FinTech & Web3"})
CREATE (healthtrack:Track {name: "HealthTech"})
CREATE (edtrack:Track {name: "EdTech"})
CREATE (devtooltrack:Track {name: "Developer Tools"})

// ---- HACKATHONS ----
CREATE (h4b:Hackathon {name: "Hack4Bengal 3.0", location: "Kolkata", year: 2025, participants: 1200})
CREATE (ethind:Hackathon {name: "ETHIndia 2025", location: "Bangalore", year: 2025, participants: 2000})

// ---- PROJECTS ----
CREATE (medgraph:Project {name: "MedGraph", description: "Patient symptom tracker using knowledge graphs", status: "Winner"})
CREATE (farmsense:Project {name: "FarmSense", description: "Crop disease detection with computer vision", status: "Runner-up"})
CREATE (defitrack:Project {name: "DeFi Tracker", description: "Cross-chain DeFi portfolio visualizer", status: "Finalist"})
CREATE (studybuddy:Project {name: "StudyBuddy", description: "AI study planner with spaced repetition", status: "Winner"})
CREATE (coderev:Project {name: "CodeReview AI", description: "Automated PR review using LLMs", status: "Finalist"})
CREATE (graphchat:Project {name: "GraphChat", description: "Chat with your data using knowledge graphs", status: "Winner"})

// ---- Developer KNOWS_SKILL relationships ----
CREATE (manish)-[:KNOWS_SKILL {level: "advanced"}]->(python)
CREATE (manish)-[:KNOWS_SKILL {level: "intermediate"}]->(langchain)
CREATE (manish)-[:KNOWS_SKILL {level: "intermediate"}]->(neo4j_tech)
CREATE (ankit)-[:KNOWS_SKILL {level: "advanced"}]->(python)
CREATE (ankit)-[:KNOWS_SKILL {level: "advanced"}]->(tensorflow)
CREATE (ankit)-[:KNOWS_SKILL {level: "intermediate"}]->(opencv)
CREATE (priya)-[:KNOWS_SKILL {level: "advanced"}]->(react)
CREATE (priya)-[:KNOWS_SKILL {level: "intermediate"}]->(nodejs)
CREATE (priya)-[:KNOWS_SKILL {level: "beginner"}]->(solidity)
CREATE (rohit)-[:KNOWS_SKILL {level: "intermediate"}]->(flutter)
CREATE (rohit)-[:KNOWS_SKILL {level: "intermediate"}]->(python)
CREATE (sneha)-[:KNOWS_SKILL {level: "advanced"}]->(python)
CREATE (sneha)-[:KNOWS_SKILL {level: "advanced"}]->(fastapi)
CREATE (arjun)-[:KNOWS_SKILL {level: "advanced"}]->(neo4j_tech)
CREATE (arjun)-[:KNOWS_SKILL {level: "intermediate"}]->(langchain)
CREATE (arjun)-[:KNOWS_SKILL {level: "intermediate"}]->(python)
CREATE (meera)-[:KNOWS_SKILL {level: "advanced"}]->(react)
CREATE (meera)-[:KNOWS_SKILL {level: "advanced"}]->(nodejs)
CREATE (vikram)-[:KNOWS_SKILL {level: "intermediate"}]->(tensorflow)
CREATE (vikram)-[:KNOWS_SKILL {level: "intermediate"}]->(python)
CREATE (vikram)-[:KNOWS_SKILL {level: "beginner"}]->(opencv)

// ---- Mentor KNOWS_SKILL relationships ----
CREATE (deepak)-[:KNOWS_SKILL {level: "expert"}]->(python)
CREATE (deepak)-[:KNOWS_SKILL {level: "expert"}]->(tensorflow)
CREATE (deepak)-[:KNOWS_SKILL {level: "advanced"}]->(langchain)
CREATE (kavita)-[:KNOWS_SKILL {level: "advanced"}]->(nodejs)
CREATE (kavita)-[:KNOWS_SKILL {level: "advanced"}]->(react)
CREATE (kavita)-[:KNOWS_SKILL {level: "intermediate"}]->(solidity)
CREATE (sanjay)-[:KNOWS_SKILL {level: "expert"}]->(neo4j_tech)
CREATE (sanjay)-[:KNOWS_SKILL {level: "advanced"}]->(python)
CREATE (sanjay)-[:KNOWS_SKILL {level: "advanced"}]->(langchain)
CREATE (nisha)-[:KNOWS_SKILL {level: "advanced"}]->(react)
CREATE (nisha)-[:KNOWS_SKILL {level: "advanced"}]->(nodejs)
CREATE (nisha)-[:KNOWS_SKILL {level: "intermediate"}]->(python)
CREATE (raghav)-[:KNOWS_SKILL {level: "expert"}]->(python)
CREATE (raghav)-[:KNOWS_SKILL {level: "advanced"}]->(langchain)
CREATE (raghav)-[:KNOWS_SKILL {level: "intermediate"}]->(fastapi)

// ---- Judge KNOWS_SKILL relationships ----
CREATE (drpatel)-[:KNOWS_SKILL {level: "expert"}]->(python)
CREATE (drpatel)-[:KNOWS_SKILL {level: "expert"}]->(tensorflow)
CREATE (drpatel)-[:KNOWS_SKILL {level: "expert"}]->(opencv)
CREATE (amita)-[:KNOWS_SKILL {level: "advanced"}]->(nodejs)
CREATE (amita)-[:KNOWS_SKILL {level: "advanced"}]->(python)
CREATE (farhan)-[:KNOWS_SKILL {level: "intermediate"}]->(react)
CREATE (farhan)-[:KNOWS_SKILL {level: "intermediate"}]->(nodejs)
CREATE (lisa)-[:KNOWS_SKILL {level: "expert"}]->(python)
CREATE (lisa)-[:KNOWS_SKILL {level: "advanced"}]->(langchain)
CREATE (lisa)-[:KNOWS_SKILL {level: "advanced"}]->(tensorflow)
CREATE (nikhil)-[:KNOWS_SKILL {level: "advanced"}]->(fastapi)
CREATE (nikhil)-[:KNOWS_SKILL {level: "advanced"}]->(nodejs)
CREATE (nikhil)-[:KNOWS_SKILL {level: "intermediate"}]->(python)

// ---- Project USES_TECH relationships ----
CREATE (medgraph)-[:USES_TECH]->(python)
CREATE (medgraph)-[:USES_TECH]->(neo4j_tech)
CREATE (medgraph)-[:USES_TECH]->(langchain)
CREATE (farmsense)-[:USES_TECH]->(python)
CREATE (farmsense)-[:USES_TECH]->(tensorflow)
CREATE (farmsense)-[:USES_TECH]->(opencv)
CREATE (defitrack)-[:USES_TECH]->(react)
CREATE (defitrack)-[:USES_TECH]->(nodejs)
CREATE (defitrack)-[:USES_TECH]->(solidity)
CREATE (studybuddy)-[:USES_TECH]->(react)
CREATE (studybuddy)-[:USES_TECH]->(fastapi)
CREATE (studybuddy)-[:USES_TECH]->(python)
CREATE (coderev)-[:USES_TECH]->(python)
CREATE (coderev)-[:USES_TECH]->(langchain)
CREATE (graphchat)-[:USES_TECH]->(neo4j_tech)
CREATE (graphchat)-[:USES_TECH]->(langchain)
CREATE (graphchat)-[:USES_TECH]->(python)
CREATE (graphchat)-[:USES_TECH]->(fastapi)

// ---- Project IN_TRACK relationships ----
CREATE (medgraph)-[:IN_TRACK]->(healthtrack)
CREATE (farmsense)-[:IN_TRACK]->(aitrack)
CREATE (defitrack)-[:IN_TRACK]->(fintrack)
CREATE (studybuddy)-[:IN_TRACK]->(edtrack)
CREATE (coderev)-[:IN_TRACK]->(devtooltrack)
CREATE (graphchat)-[:IN_TRACK]->(devtooltrack)

// ---- Developer BUILT relationships ----
CREATE (manish)-[:BUILT {role: "Lead"}]->(medgraph)
CREATE (sneha)-[:BUILT {role: "Backend"}]->(medgraph)
CREATE (arjun)-[:BUILT {role: "Data"}]->(medgraph)
CREATE (ankit)-[:BUILT {role: "Lead"}]->(farmsense)
CREATE (vikram)-[:BUILT {role: "ML Engineer"}]->(farmsense)
CREATE (priya)-[:BUILT {role: "Lead"}]->(defitrack)
CREATE (rohit)-[:BUILT {role: "Frontend"}]->(defitrack)
CREATE (meera)-[:BUILT {role: "Lead"}]->(studybuddy)
CREATE (priya)-[:BUILT {role: "Frontend"}]->(studybuddy)
CREATE (manish)-[:BUILT {role: "Lead"}]->(graphchat)
CREATE (arjun)-[:BUILT {role: "Backend"}]->(graphchat)
CREATE (sneha)-[:BUILT {role: "API"}]->(graphchat)
CREATE (ankit)-[:BUILT {role: "ML"}]->(coderev)
CREATE (meera)-[:BUILT {role: "Frontend"}]->(coderev)

// ---- Project SUBMITTED_AT relationships ----
CREATE (medgraph)-[:SUBMITTED_AT {prize: "1st Place"}]->(h4b)
CREATE (farmsense)-[:SUBMITTED_AT {prize: "2nd Place"}]->(h4b)
CREATE (studybuddy)-[:SUBMITTED_AT {prize: "1st Place"}]->(h4b)
CREATE (graphchat)-[:SUBMITTED_AT {prize: "Best AI"}]->(ethind)
CREATE (defitrack)-[:SUBMITTED_AT {prize: "Top 10"}]->(ethind)
CREATE (coderev)-[:SUBMITTED_AT {prize: "Finalist"}]->(ethind)

// ---- Track PART_OF relationships ----
CREATE (healthtrack)-[:PART_OF]->(h4b)
CREATE (aitrack)-[:PART_OF]->(h4b)
CREATE (edtrack)-[:PART_OF]->(h4b)
CREATE (fintrack)-[:PART_OF]->(ethind)
CREATE (devtooltrack)-[:PART_OF]->(ethind)

// ---- Judge JUDGES_TRACK relationships ----
// This is what we WANT the graph agent to help optimize
CREATE (drpatel)-[:JUDGES_TRACK]->(healthtrack)
CREATE (drpatel)-[:JUDGES_TRACK]->(aitrack)
CREATE (lisa)-[:JUDGES_TRACK]->(aitrack)
CREATE (lisa)-[:JUDGES_TRACK]->(devtooltrack)
CREATE (amita)-[:JUDGES_TRACK]->(devtooltrack)
CREATE (farhan)-[:JUDGES_TRACK]->(fintrack)
CREATE (farhan)-[:JUDGES_TRACK]->(edtrack)
CREATE (nikhil)-[:JUDGES_TRACK]->(devtooltrack)

// ---- Mentor MENTORS_TRACK relationships ----
CREATE (deepak)-[:MENTORS_TRACK]->(aitrack)
CREATE (deepak)-[:MENTORS_TRACK]->(healthtrack)
CREATE (kavita)-[:MENTORS_TRACK]->(fintrack)
CREATE (sanjay)-[:MENTORS_TRACK]->(devtooltrack)
CREATE (raghav)-[:MENTORS_TRACK]->(aitrack)
CREATE (raghav)-[:MENTORS_TRACK]->(edtrack)
CREATE (nisha)-[:MENTORS_TRACK]->(edtrack)

RETURN "Hackathon ecosystem loaded! Nodes: 8 devs, 5 mentors, 5 judges, 10 techs, 5 tracks, 6 projects, 2 hackathons" AS status;