prompts/cypher_prompt.yaml

input_variables: [schema, question]
output_parser: null
template: |
  Task:Generate Cypher statement to query a graph database.
  Instructions:
  Use only the provided relationship types and properties in the schema.
  Do not use any other relationship types or properties that are not provided.
  Schema:
  {schema}
  Note: Do not include any explanations or apologies in your responses.
  Do not respond to any questions that might ask anything else than for you to construct a Cypher statement.
  Do not include any text except the generated Cypher statement.

  Examples:
  Find all jobs in the 'Software Engineering' industry that offer remote work options and require 'Python' skills?
  MATCH (j:Job)
  WHERE j.name CONTAINS 'Software Engineer'
  AND j.work_mode = 'Remote'
  AND (j)-[:REQUIRES]->(:Skill {{name: "Python"}})
  RETURN j AS job

  Which companies located in 'San Francisco' are hiring for 'Data Scientist' roles with a 'Master's Degree' requirement?
  MATCH (c:Company)-[:LOCATES_IN]->(l:Location {{name: "San Francisco"}})
  WHERE (c)-[:RECRUITES]->(j:Job {{name: "Data Scientist"}})
  AND (j)-[:REQUIRES]->(e:Education {{name: "Master's Degree"}})
  RETURN DISTINCT c.name AS company

  What are the most common skills required for 'Product Manager' jobs across different industries?
  MATCH (j:Job {{name: "Product Manager"}})-[:REQUIRES]->(s:Skill)
  RETURN s.name, count(*) AS skill_count
  ORDER BY skill_count DESC
  LIMIT 10

  Find all jobs that require at least 5 years of experience and a 'Bachelor's Degree' in 'Computer Science':
  MATCH (j:Job)-[:REQUIRES]->(e:Education {{name: "Bachelor's Degree", fields: "Computer Science"}})
  WHERE (j)-[:REQUIRES]->(we:Work_Exper {{duration: "5 years"}})
  RETURN j AS job

  Identify companies that are subsidiaries of 'Google' and are recruiting for 'Software Engineer' roles with 'Senior' level.
  MATCH (g:Company {{name: "Google"}})<-[:SUBDIARY]-(c:Company)
  WHERE (c)-[:RECRUITES]->(j:Job {{name: "Software Engineer"}})
  AND (j)-[:AT_LEVEL]->(wl:Work_LV {{name: "Senior"}})
  RETURN DISTINCT c.name AS company

  Find companies recruiting "Machine Learning" jobs and their corresponding job titles.
  MATCH (company: Company)-[:RECRUITES]->(job: Job)
  WHERE job.name CONTAINS "Machine Learning"
  RETURN company.name as company_name, job.name as job_title

  Show job description of Machine Learning job at KMS 
  MATCH (company:Company)-[:RECRUITS]->(job:Job)-[r]->(node)
  WHERE job.name CONTAINS "Machine Learning" AND company.name CONTAINS "KMS"
  RETURN job, node  
  
  
  The question is:
  {question}

template_format: f-string