Trip Planner MCP

// ===================================================== // CLEAN UP // ===================================================== MATCH (n) DETACH DELETE n; // ===================================================== // CREATE CONSTRAINT & INDEXES // ===================================================== CREATE CONSTRAINT employee_email IF NOT EXISTS FOR (e:Employee) REQUIRE e.email IS UNIQUE; CREATE CONSTRAINT team_name IF NOT EXISTS FOR (t:Team) REQUIRE t.name IS UNIQUE; CREATE CONSTRAINT project_name IF NOT EXISTS FOR (p:Project) REQUIRE p.name IS UNIQUE; CREATE CONSTRAINT skill_name IF NOT EXISTS FOR (s:Skill) REQUIRE s.name IS UNIQUE; CREATE CONSTRAINT location_key IF NOT EXISTS FOR (l:Location) REQUIRE (l.city, l.country) IS UNIQUE; CREATE CONSTRAINT department_name IF NOT EXISTS FOR (d:Department) REQUIRE d.name IS UNIQUE; // ===================================================== // LOCATIONS // ===================================================== CREATE (mumbai:Location {city: 'Mumbai', country: 'India', timezone: 'Asia/Kolkata', office_code: 'MUM'}) CREATE (bangalore:Location {city: 'Bangalore', country: 'India', timezone: 'Asia/Kolkata', office_code: 'BLR'}) CREATE (delhi:Location {city: 'Delhi', country: 'India', timezone: 'Asia/Kolkata', office_code: 'DEL'}) CREATE (pune:Location {city: 'Pune', country: 'India', timezone: 'Asia/Kolkata', office_code: 'PUN'}) CREATE (hyderabad:Location {city: 'Hyderabad', country: 'India', timezone: 'Asia/Kolkata', office_code: 'HYD'}) CREATE (chennai:Location {city: 'Chennai', country: 'India', timezone: 'Asia/Kolkata', office_code: 'CHE'}) CREATE (goa:Location {city: 'Goa', country: 'India', timezone: 'Asia/Kolkata', office_code: 'GOA'}) // ===================================================== // DEPARTMENTS // ===================================================== CREATE (engineering:Department { name: 'Engineering', description: 'Software development and technical teams', budget: 5000000, head_count: 45 }) CREATE (product:Department { name: 'Product', description: 'Product management and strategy', budget: 1500000, head_count: 12 }) CREATE (qa:Department { name: 'Quality Assurance', description: 'Testing and quality control', budget: 1200000, head_count: 15 }) CREATE (devops:Department { name: 'DevOps', description: 'Infrastructure and operations', budget: 2000000, head_count: 10 }) CREATE (design:Department { name: 'Design', description: 'UX/UI and product design', budget: 800000, head_count: 8 }) // ===================================================== // SKILLS // ===================================================== CREATE (python:Skill {name: 'Python', category: 'Backend', proficiency_levels: ['beginner', 'intermediate', 'expert']}) CREATE (java:Skill {name: 'Java', category: 'Backend', proficiency_levels: ['beginner', 'intermediate', 'expert']}) CREATE (javascript:Skill {name: 'JavaScript', category: 'Frontend', proficiency_levels: ['beginner', 'intermediate', 'expert']}) CREATE (react:Skill {name: 'React', category: 'Frontend', proficiency_levels: ['beginner', 'intermediate', 'expert']}) CREATE (angular:Skill {name: 'Angular', category: 'Frontend', proficiency_levels: ['beginner', 'intermediate', 'expert']}) CREATE (nodejs:Skill {name: 'Node.js', category: 'Backend', proficiency_levels: ['beginner', 'intermediate', 'expert']}) CREATE (sql:Skill {name: 'SQL', category: 'Database', proficiency_levels: ['beginner', 'intermediate', 'expert']}) CREATE (mongodb:Skill {name: 'MongoDB', category: 'Database', proficiency_levels: ['beginner', 'intermediate', 'expert']}) CREATE (aws:Skill {name: 'AWS', category: 'Cloud', proficiency_levels: ['beginner', 'intermediate', 'expert']}) CREATE (docker:Skill {name: 'Docker', category: 'DevOps', proficiency_levels: ['beginner', 'intermediate', 'expert']}) CREATE (kubernetes:Skill {name: 'Kubernetes', category: 'DevOps', proficiency_levels: ['beginner', 'intermediate', 'expert']}) CREATE (testing:Skill {name: 'Testing', category: 'QA', proficiency_levels: ['beginner', 'intermediate', 'expert']}) CREATE (automation:Skill {name: 'Test Automation', category: 'QA', proficiency_levels: ['beginner', 'intermediate', 'expert']}) CREATE (figma:Skill {name: 'Figma', category: 'Design', proficiency_levels: ['beginner', 'intermediate', 'expert']}) CREATE (agile:Skill {name: 'Agile', category: 'Management', proficiency_levels: ['beginner', 'intermediate', 'expert']}) CREATE (scrum:Skill {name: 'Scrum', category: 'Management', proficiency_levels: ['beginner', 'intermediate', 'expert']}) // ===================================================== // PROJECTS // ===================================================== CREATE (trip_planner:Project { name: 'Trip Planner POC', status: 'Active', description: 'AI-powered trip planning application using MCP', start_date: date('2024-01-15'), budget: 500000, priority: 'high' }) CREATE (ecommerce:Project { name: 'E-Commerce Platform', status: 'Active', description: 'Scalable microservices-based shopping platform', start_date: date('2023-08-01'), budget: 2000000, priority: 'high' }) CREATE (mobile_app:Project { name: 'Mobile App Revamp', status: 'Planning', description: 'Redesigning mobile experience with React Native', start_date: date('2024-03-01'), budget: 800000, priority: 'medium' }) CREATE (analytics:Project { name: 'Analytics Dashboard', status: 'In Progress', description: 'Real-time business intelligence dashboard', start_date: date('2023-11-01'), budget: 600000, priority: 'medium' }) CREATE (cloud_migration:Project { name: 'Cloud Migration', status: 'Completed', description: 'Migrated legacy systems to AWS', start_date: date('2023-01-01'), end_date: date('2023-10-31'), budget: 1500000, priority: 'high' }) // ===================================================== // TEAMS // ===================================================== CREATE (alpha:Team { name: 'Alpha Team', description: 'Backend API development team', formation_date: date('2022-01-15'), team_size: 6 }) CREATE (beta:Team { name: 'Beta Squad', description: 'Frontend and UI development', formation_date: date('2022-02-01'), team_size: 5 }) CREATE (gamma:Team { name: 'Gamma Group', description: 'Mobile application development', formation_date: date('2022-03-10'), team_size: 4 }) CREATE (delta:Team { name: 'Delta Force', description: 'DevOps and infrastructure', formation_date: date('2022-01-20'), team_size: 4 }) CREATE (epsilon:Team { name: 'Epsilon Engineers', description: 'QA and testing automation', formation_date: date('2022-04-05'), team_size: 5 }) CREATE (zeta:Team { name: 'Zeta Zone', description: 'Product management and strategy', formation_date: date('2022-02-15'), team_size: 3 }) // ===================================================== // EMPLOYEES // ===================================================== // CTO CREATE (cto:Employee { name: 'Rajesh Kumar', email: 'rajesh.kumar@example.com', employee_id: 'EMP001', role: 'CTO', level: 'Executive', joined_on: date('2020-01-01'), years_of_experience: 18, phone: '+91-9876543210' }) // Engineering Department Head CREATE (eng_head:Employee { name: 'Priya Sharma', email: 'priya.sharma@example.com', employee_id: 'EMP002', role: 'VP Engineering', level: 'Senior Management', joined_on: date('2020-06-01'), years_of_experience: 15, phone: '+91-9876543211' }) // Alpha Team (Backend Team) CREATE (alice:Employee { name: 'Alice Johnson', email: 'alice.johnson@example.com', employee_id: 'EMP101', role: 'Engineering Manager', level: 'Manager', joined_on: date('2021-03-15'), years_of_experience: 10, phone: '+91-9876543220' }) CREATE (john:Employee { name: 'John Doe', email: 'john.doe@example.com', employee_id: 'EMP102', role: 'Senior Backend Developer', level: 'Senior', joined_on: date('2021-09-01'), years_of_experience: 7, phone: '+91-9876543221' }) CREATE (jane:Employee { name: 'Jane Smith', email: 'jane.smith@example.com', employee_id: 'EMP103', role: 'Backend Developer', level: 'Mid', joined_on: date('2022-02-15'), years_of_experience: 5, phone: '+91-9876543222' }) CREATE (ravi:Employee { name: 'Ravi Verma', email: 'ravi.verma@example.com', employee_id: 'EMP104', role: 'Backend Developer', level: 'Mid', joined_on: date('2022-06-01'), years_of_experience: 4, phone: '+91-9876543223' }) // Beta Team (Frontend Team) CREATE (bob:Employee { name: 'Bob Smith', email: 'bob.smith@example.com', employee_id: 'EMP201', role: 'Frontend Team Lead', level: 'Manager', joined_on: date('2021-04-20'), years_of_experience: 9, phone: '+91-9876543230' }) CREATE (nancy:Employee { name: 'Nancy Drew', email: 'nancy.drew@example.com', employee_id: 'EMP202', role: 'Senior Frontend Developer', level: 'Senior', joined_on: date('2021-11-10'), years_of_experience: 6, phone: '+91-9876543231' }) CREATE (amit:Employee { name: 'Amit Patel', email: 'amit.patel@example.com', employee_id: 'EMP203', role: 'Frontend Developer', level: 'Mid', joined_on: date('2022-08-15'), years_of_experience: 4, phone: '+91-9876543232' }) // Gamma Team (Mobile Team) CREATE (charlie:Employee { name: 'Charlie Brown', email: 'charlie.brown@example.com', employee_id: 'EMP301', role: 'Mobile Team Lead', level: 'Manager', joined_on: date('2021-05-10'), years_of_experience: 8, phone: '+91-9876543240' }) CREATE (oscar:Employee { name: 'Oscar Wilde', email: 'oscar.wilde@example.com', employee_id: 'EMP302', role: 'Mobile Developer', level: 'Mid', joined_on: date('2022-03-20'), years_of_experience: 5, phone: '+91-9876543241' }) // Delta Team (DevOps) CREATE (david:Employee { name: 'David Wilson', email: 'david.wilson@example.com', employee_id: 'EMP401', role: 'DevOps Manager', level: 'Manager', joined_on: date('2021-02-01'), years_of_experience: 11, phone: '+91-9876543250' }) CREATE (tom:Employee { name: 'Tom Baker', email: 'tom.baker@example.com', employee_id: 'EMP402', role: 'Senior DevOps Engineer', level: 'Senior', joined_on: date('2021-07-15'), years_of_experience: 8, phone: '+91-9876543251' }) CREATE (vikram:Employee { name: 'Vikram Singh', email: 'vikram.singh@example.com', employee_id: 'EMP403', role: 'DevOps Engineer', level: 'Mid', joined_on: date('2022-09-01'), years_of_experience: 3, phone: '+91-9876543252' }) // Epsilon Team (QA) CREATE (sarah:Employee { name: 'Sarah Williams', email: 'sarah.williams@example.com', employee_id: 'EMP501', role: 'QA Manager', level: 'Manager', joined_on: date('2021-06-01'), years_of_experience: 9, phone: '+91-9876543260' }) CREATE (mike:Employee { name: 'Mike Jones', email: 'mike.jones@example.com', employee_id: 'EMP502', role: 'Senior QA Engineer', level: 'Senior', joined_on: date('2021-10-15'), years_of_experience: 7, phone: '+91-9876543261' }) CREATE (sneha:Employee { name: 'Sneha Reddy', email: 'sneha.reddy@example.com', employee_id: 'EMP503', role: 'QA Engineer', level: 'Mid', joined_on: date('2022-05-10'), years_of_experience: 4, phone: '+91-9876543262' }) // Zeta Team (Product) CREATE (eve:Employee { name: 'Eve Davis', email: 'eve.davis@example.com', employee_id: 'EMP601', role: 'Product Manager', level: 'Manager', joined_on: date('2021-08-01'), years_of_experience: 10, phone: '+91-9876543270' }) CREATE (chris:Employee { name: 'Chris Evans', email: 'chris.evans@example.com', employee_id: 'EMP602', role: 'Associate Product Manager', level: 'Mid', joined_on: date('2022-01-15'), years_of_experience: 3, phone: '+91-9876543271' }) CREATE (patty:Employee { name: 'Patty O\'Neil', email: 'patty.oneil@example.com', employee_id: 'EMP603', role: 'Product Analyst', level: 'Junior', joined_on: date('2022-11-01'), years_of_experience: 2, phone: '+91-9876543272' }) // ===================================================== // ORGANIZATIONAL HIERARCHY // ===================================================== // Department relationships MERGE (engineering)-[:PART_OF]->(engineering) MERGE (product)-[:PART_OF]->(product) MERGE (qa)-[:PART_OF]->(qa) MERGE (devops)-[:PART_OF]->(devops) // CTO manages department heads MERGE (cto)-[:MANAGES]->(eng_head) // Department heads manage teams MERGE (eng_head)-[:MANAGES]->(alice) MERGE (eng_head)-[:MANAGES]->(bob) MERGE (eng_head)-[:MANAGES]->(charlie) MERGE (eng_head)-[:MANAGES]->(david) MERGE (eng_head)-[:MANAGES]->(sarah) MERGE (eng_head)-[:MANAGES]->(eve) // Team leads manage team members MERGE (alice)-[:MANAGES]->(john) MERGE (alice)-[:MANAGES]->(jane) MERGE (alice)-[:MANAGES]->(ravi) MERGE (bob)-[:MANAGES]->(nancy) MERGE (bob)-[:MANAGES]->(amit) MERGE (charlie)-[:MANAGES]->(oscar) MERGE (david)-[:MANAGES]->(tom) MERGE (david)-[:MANAGES]->(vikram) MERGE (sarah)-[:MANAGES]->(mike) MERGE (sarah)-[:MANAGES]->(sneha) MERGE (eve)-[:MANAGES]->(chris) MERGE (eve)-[:MANAGES]->(patty) // ===================================================== // TEAM MEMBERSHIPS // ===================================================== MERGE (alice)-[:WORKS_IN]->(alpha) MERGE (john)-[:WORKS_IN]->(alpha) MERGE (jane)-[:WORKS_IN]->(alpha) MERGE (ravi)-[:WORKS_IN]->(alpha) MERGE (bob)-[:WORKS_IN]->(beta) MERGE (nancy)-[:WORKS_IN]->(beta) MERGE (amit)-[:WORKS_IN]->(beta) MERGE (charlie)-[:WORKS_IN]->(gamma) MERGE (oscar)-[:WORKS_IN]->(gamma) MERGE (david)-[:WORKS_IN]->(delta) MERGE (tom)-[:WORKS_IN]->(delta) MERGE (vikram)-[:WORKS_IN]->(delta) MERGE (sarah)-[:WORKS_IN]->(epsilon) MERGE (mike)-[:WORKS_IN]->(epsilon) MERGE (sneha)-[:WORKS_IN]->(epsilon) MERGE (eve)-[:WORKS_IN]->(zeta) MERGE (chris)-[:WORKS_IN]->(zeta) MERGE (patty)-[:WORKS_IN]->(zeta) // Team leads MERGE (alice)-[:LEADS]->(alpha) MERGE (bob)-[:LEADS]->(beta) MERGE (charlie)-[:LEADS]->(gamma) MERGE (david)-[:LEADS]->(delta) MERGE (sarah)-[:LEADS]->(epsilon) MERGE (eve)-[:LEADS]->(zeta) // ===================================================== // DEPARTMENT ASSOCIATIONS // ===================================================== MERGE (alpha)-[:BELONGS_TO]->(engineering) MERGE (beta)-[:BELONGS_TO]->(engineering) MERGE (gamma)-[:BELONGS_TO]->(engineering) MERGE (delta)-[:BELONGS_TO]->(devops) MERGE (epsilon)-[:BELONGS_TO]->(qa) MERGE (zeta)-[:BELONGS_TO]->(product) // ===================================================== // LOCATION ASSIGNMENTS // ===================================================== MERGE (cto)-[:LOCATED_IN]->(mumbai) MERGE (eng_head)-[:LOCATED_IN]->(mumbai) MERGE (alice)-[:LOCATED_IN]->(bangalore) MERGE (john)-[:LOCATED_IN]->(bangalore) MERGE (jane)-[:LOCATED_IN]->(bangalore) MERGE (ravi)-[:LOCATED_IN]->(pune) MERGE (bob)-[:LOCATED_IN]->(delhi) MERGE (nancy)-[:LOCATED_IN]->(delhi) MERGE (amit)-[:LOCATED_IN]->(bangalore) MERGE (charlie)-[:LOCATED_IN]->(hyderabad) MERGE (oscar)-[:LOCATED_IN]->(hyderabad) MERGE (david)-[:LOCATED_IN]->(mumbai) MERGE (tom)-[:LOCATED_IN]->(mumbai) MERGE (vikram)-[:LOCATED_IN]->(bangalore) MERGE (sarah)-[:LOCATED_IN]->(chennai) MERGE (mike)-[:LOCATED_IN]->(chennai) MERGE (sneha)-[:LOCATED_IN]->(bangalore) MERGE (eve)-[:LOCATED_IN]->(bangalore) MERGE (chris)-[:LOCATED_IN]->(bangalore) MERGE (patty)-[:LOCATED_IN]->(pune) // ===================================================== // SKILLS & PROFICIENCY // ===================================================== // Alpha Team Skills (Backend) MERGE (alice)-[:HAS_SKILL {proficiency: 'expert', years: 8}]->(python) MERGE (alice)-[:HAS_SKILL {proficiency: 'expert', years: 7}]->(java) MERGE (alice)-[:HAS_SKILL {proficiency: 'expert', years: 6}]->(sql) MERGE (alice)-[:HAS_SKILL {proficiency: 'expert', years: 5}]->(agile) MERGE (john)-[:HAS_SKILL {proficiency: 'expert', years: 6}]->(python) MERGE (john)-[:HAS_SKILL {proficiency: 'intermediate', years: 5}]->(nodejs) MERGE (john)-[:HAS_SKILL {proficiency: 'expert', years: 5}]->(sql) MERGE (john)-[:HAS_SKILL {proficiency: 'intermediate', years: 3}]->(mongodb) MERGE (jane)-[:HAS_SKILL {proficiency: 'intermediate', years: 4}]->(java) MERGE (jane)-[:HAS_SKILL {proficiency: 'expert', years: 4}]->(sql) MERGE (jane)-[:HAS_SKILL {proficiency: 'intermediate', years: 3}]->(aws) MERGE (ravi)-[:HAS_SKILL {proficiency: 'intermediate', years: 3}]->(python) MERGE (ravi)-[:HAS_SKILL {proficiency: 'intermediate', years: 3}]->(nodejs) MERGE (ravi)-[:HAS_SKILL {proficiency: 'beginner', years: 2}]->(mongodb) // Beta Team Skills (Frontend) MERGE (bob)-[:HAS_SKILL {proficiency: 'expert', years: 7}]->(javascript) MERGE (bob)-[:HAS_SKILL {proficiency: 'expert', years: 6}]->(react) MERGE (bob)-[:HAS_SKILL {proficiency: 'intermediate', years: 5}]->(angular) MERGE (bob)-[:HAS_SKILL {proficiency: 'expert', years: 6}]->(agile) MERGE (nancy)-[:HAS_SKILL {proficiency: 'expert', years: 5}]->(react) MERGE (nancy)-[:HAS_SKILL {proficiency: 'intermediate', years: 4}]->(javascript) MERGE (nancy)-[:HAS_SKILL {proficiency: 'intermediate', years: 3}]->(figma) MERGE (amit)-[:HAS_SKILL {proficiency: 'intermediate', years: 3}]->(react) MERGE (amit)-[:HAS_SKILL {proficiency: 'intermediate', years: 3}]->(javascript) // Gamma Team Skills (Mobile) MERGE (charlie)-[:HAS_SKILL {proficiency: 'expert', years: 6}]->(react) MERGE (charlie)-[:HAS_SKILL {proficiency: 'expert', years: 7}]->(javascript) MERGE (charlie)-[:HAS_SKILL {proficiency: 'intermediate', years: 4}]->(nodejs) MERGE (oscar)-[:HAS_SKILL {proficiency: 'intermediate', years: 4}]->(react) MERGE (oscar)-[:HAS_SKILL {proficiency: 'intermediate', years: 4}]->(javascript) // Delta Team Skills (DevOps) MERGE (david)-[:HAS_SKILL {proficiency: 'expert', years: 9}]->(aws) MERGE (david)-[:HAS_SKILL {proficiency: 'expert', years: 8}]->(docker) MERGE (david)-[:HAS_SKILL {proficiency: 'expert', years: 7}]->(kubernetes) MERGE (david)-[:HAS_SKILL {proficiency: 'intermediate', years: 6}]->(python) MERGE (tom)-[:HAS_SKILL {proficiency: 'expert', years: 6}]->(aws) MERGE (tom)-[:HAS_SKILL {proficiency: 'expert', years: 6}]->(docker) MERGE (tom)-[:HAS_SKILL {proficiency: 'intermediate', years: 5}]->(kubernetes) MERGE (vikram)-[:HAS_SKILL {proficiency: 'intermediate', years: 2}]->(aws) MERGE (vikram)-[:HAS_SKILL {proficiency: 'intermediate', years: 2}]->(docker) // Epsilon Team Skills (QA) MERGE (sarah)-[:HAS_SKILL {proficiency: 'expert', years: 8}]->(testing) MERGE (sarah)-[:HAS_SKILL {proficiency: 'expert', years: 7}]->(automation) MERGE (sarah)-[:HAS_SKILL {proficiency: 'intermediate', years: 5}]->(python) MERGE (sarah)-[:HAS_SKILL {proficiency: 'expert', years: 6}]->(agile) MERGE (mike)-[:HAS_SKILL {proficiency: 'expert', years: 6}]->(testing) MERGE (mike)-[:HAS_SKILL {proficiency: 'intermediate', years: 5}]->(automation) MERGE (mike)-[:HAS_SKILL {proficiency: 'beginner', years: 3}]->(python) MERGE (sneha)-[:HAS_SKILL {proficiency: 'intermediate', years: 3}]->(testing) MERGE (sneha)-[:HAS_SKILL {proficiency: 'beginner', years: 2}]->(automation) // Zeta Team Skills (Product) MERGE (eve)-[:HAS_SKILL {proficiency: 'expert', years: 9}]->(agile) MERGE (eve)-[:HAS_SKILL {proficiency: 'expert', years: 8}]->(scrum) MERGE (eve)-[:HAS_SKILL {proficiency: 'intermediate', years: 5}]->(figma) MERGE (chris)-[:HAS_SKILL {proficiency: 'intermediate', years: 3}]->(agile) MERGE (chris)-[:HAS_SKILL {proficiency: 'intermediate', years: 3}]->(scrum) MERGE (patty)-[:HAS_SKILL {proficiency: 'beginner', years: 2}]->(agile) MERGE (patty)-[:HAS_SKILL {proficiency: 'intermediate', years: 2}]->(sql) // ===================================================== // PROJECT ASSIGNMENTS // ===================================================== // Trip Planner Project MERGE (trip_planner)-[:OWNED_BY]->(alpha) MERGE (alice)-[:CONTRIBUTES_TO {role: 'Project Lead', allocation: 100}]->(trip_planner) MERGE (john)-[:CONTRIBUTES_TO {role: 'Lead Developer', allocation: 80}]->(trip_planner) MERGE (nancy)-[:CONTRIBUTES_TO {role: 'Frontend Developer', allocation: 60}]->(trip_planner) MERGE (mike)-[:CONTRIBUTES_TO {role: 'QA Lead', allocation: 50}]->(trip_planner) MERGE (chris)-[:CONTRIBUTES_TO {role: 'Product Owner', allocation: 40}]->(trip_planner) // E-Commerce Platform MERGE (ecommerce)-[:OWNED_BY]->(alpha) MERGE (jane)-[:CONTRIBUTES_TO {role: 'Backend Developer', allocation: 100}]->(ecommerce) MERGE (ravi)-[:CONTRIBUTES_TO {role: 'Backend Developer', allocation: 80}]->(ecommerce) MERGE (amit)-[:CONTRIBUTES_TO {role: 'Frontend Developer', allocation: 100}]->(ecommerce) MERGE (sneha)-[:CONTRIBUTES_TO {role: 'QA Engineer', allocation: 80}]->(ecommerce) MERGE (tom)-[:CONTRIBUTES_TO {role: 'DevOps Engineer', allocation: 30}]->(ecommerce) // Mobile App Revamp MERGE (mobile_app)-[:OWNED_BY]->(gamma) MERGE (charlie)-[:CONTRIBUTES_TO {role: 'Mobile Lead', allocation: 100}]->(mobile_app) MERGE (oscar)-[:CONTRIBUTES_TO {role: 'Mobile Developer', allocation: 100}]->(mobile_app) MERGE (eve)-[:CONTRIBUTES_TO {role: 'Product Manager', allocation: 50}]->(mobile_app) // Analytics Dashboard MERGE (analytics)-[:OWNED_BY]->(beta) MERGE (bob)-[:CONTRIBUTES_TO {role: 'Frontend Lead', allocation: 60}]->(analytics) MERGE (patty)-[:CONTRIBUTES_TO {role: 'Product Analyst', allocation: 100}]->(analytics) // Cloud Migration (Completed) MERGE (cloud_migration)-[:OWNED_BY]->(delta) MERGE (david)-[:CONTRIBUTES_TO {role: 'Migration Lead', allocation: 0}]->(cloud_migration) MERGE (tom)-[:CONTRIBUTES_TO {role: 'DevOps Engineer', allocation: 0}]->(cloud_migration) // ===================================================== // COLLABORATION RELATIONSHIPS // ===================================================== // Cross-team collaboration MERGE (alice)-[:COLLABORATES_WITH {context: 'Architecture decisions'}]->(bob) MERGE (alice)-[:COLLABORATES_WITH {context: 'API design'}]->(charlie) MERGE (john)-[:COLLABORATES_WITH {context: 'Integration testing'}]->(mike) MERGE (nancy)-[:COLLABORATES_WITH {context: 'UI/UX design'}]->(eve) MERGE (david)-[:COLLABORATES_WITH {context: 'Infrastructure'}]->(alice) // Mentorship relationships MERGE (alice)-[:MENTORS {since: date('2022-03-01')}]->(ravi) MERGE (john)-[:MENTORS {since: date('2022-08-01')}]->(jane) MERGE (bob)-[:MENTORS {since: date('2023-01-15')}]->(amit) MERGE (sarah)-[:MENTORS {since: date('2022-10-01')}]->(sneha) MERGE (eve)-[:MENTORS {since: date('2023-02-01')}]->(patty) // ===================================================== // QUERY EXAMPLES (Commented) // ===================================================== // Find all employees in a specific location // MATCH (e:Employee)-[:LOCATED_IN]->(l:Location {city: 'Bangalore'}) // RETURN e.name, e.role // Find team members reporting to a manager // MATCH (m:Employee {name: 'Alice Johnson'})-[:MANAGES]->(e:Employee) // RETURN e.name, e.role // Find employees with specific skills // MATCH (e:Employee)-[r:HAS_SKILL]->(s:Skill {name: 'Python'}) // WHERE r.proficiency = 'expert' // RETURN e.name, e.role, r.years // Find all projects a person is working on // MATCH (e:Employee {email: 'john.doe@example.com'})-[r:CONTRIBUTES_TO]->(p:Project) // RETURN p.name, r.role, r.allocation // Find team hierarchy // MATCH path = (lead:Employee)-[:LEADS]->(t:Team)<-[:WORKS_IN]-(member:Employee) // RETURN lead.name as TeamLead, t.name as Team, collect(member.name) as Members // Find employees who can mentor on a skill // MATCH (e:Employee)-[r:HAS_SKILL]->(s:Skill {name: 'React'}) // WHERE r.proficiency IN ['expert', 'intermediate'] AND r.years >= 3 // RETURN e.name, e.email, r.proficiency, r.years // ORDER BY r.years DESC // Find collaboration network // MATCH (e1:Employee)-[:COLLABORATES_WITH]-(e2:Employee) // RETURN e1.name, e2.name, count(*) as collaborations // Find employees suitable for a trip based on location // MATCH (e:Employee)-[:LOCATED_IN]->(l:Location {city: 'Bangalore'}) // MATCH (e)-[:WORKS_IN]->(t:Team) // RETURN t.name as Team, collect(e.name) as Members