Pipeline run

e79bec17-46ca-47d3-b9fb-adda6dd18aaa

Pipeline LLM cost (USD)

API 1: $0.0033 API 2: $0.0001 API 3: $0.0000 Total: $0.0034

Client output enrichment

v2 Skill cluster · Nature of work · AI index · Tech stack maturity · Evidence · KRA description

SPARSE JD role baseline loaded sources · ai_index: role_baseline · nature_of_work: jd · tech_stack_maturity: jd

Nature of work · Frontend service integration

Build, maintain, and optimize PHP/Laravel web apps, writing reusable OOP code, tuning MySQL queries, and debugging issues to keep applications fast, reliable, and secure while working with cross-functional teams.

"“Develop, maintain, and optimize web applications using PHP and the Laravel framework.”"

Tech stack maturity

Mainstream Legacy

Laravel, MySQL, and PHP are widely used, well-established web technologies that are common in production but not typically considered cloud-native or bleeding-edge.

AI index (0 = no AI use, 5 = totally AI-dependent · v2.1)

1.50 / 5

· Title match

· Has AI skill

· AI skill (primary)

· AI skill (secondary)

· On AI team

· Builds AI products

vocab breakdown (legacy)

Assistants (×1): —

Frameworks (×2): —

Models / concepts (×3): —

Evidence — skills matched in JD (4)

PHP Laravel Object-Oriented Programming MySQL

Skill cluster (2 dimension groups, role-scoped)

Relational Database Usage

MySQL

Cross-cutting / unaligned

PHP Laravel Object-Oriented Programming

Show KRA description ↓

• Develop, maintain, and optimize web applications using PHP and the Laravel framework. • Implement Object-Oriented Programming (OOPS) principles to create scalable and reusable code. • Design, optimize, and manage relational databases with MySQL. • Collaborate with cross-functional teams to understand project requirements and deliver high-quality solutions. • Troubleshoot and debug applications to ensure performance, reliability, and security. • Maintain coding standards and ensure best practices are followed in development. • Continuously research and implement the latest web technologies to improve processes and applications. • Extensive experience in PHP Development with at least 7 years of hands-on experience. • In-depth knowledge and experience with the Laravel Framework. • Strong understanding of Object-Oriented Programming (OOPS) concepts. • Expertise in MySQL database management, including designing and optimizing queries. • Proven problem-solving abilities and attention to detail. • Excellent coding practices, including clean, maintainable, and scalable code. • Bachelor’s degree in Computer Science (CS), Information Technology (IT), BCA, MCA, or any equivalent qualification.

Signals

Skill full-stack-engineer

0.50

Alias backend-engineer

1.00

KRA react-native-developer

0.60

Status: completed Created: 2026-05-27T16:02:53.767857Z Updated: 2026-05-27T16:03:39.734539Z API 3 duration: 13670 ms

Flow Current 3-step pipeline

1 POST /skills/extract-from-jd

2 POST /skills/extract-details

3 POST /skills/final-role-output

Role Chosen role & resolution

Web Developer

CASE A

slug: web-developer · id: 25 · source: db

Multi-alias tie (4 roles at 1.0) resolved by TIER_B_TITLE: Web Developer

Resolution: in_db — role exists in library; skill↔dim and role↔dim links saved when applicable.

New skills

Skill↔dim saved

Role↔dim saved

Skipped

Job description

Work Level: Junior Leadership
Core: Self Motivated, Organized, Adaptable, Problem Solving
Leadership: Decisive, Leading from the front
Role: Self motivated
Industry Type: IT Services & Consulting
Function: Software Development
Key Skills: PHP,Laravel,MySQL,AJAX,JSON,Object-Oriented Programming (OOP) Concepts
Education: Graduate

Note: This is a requirement for one of the Workassist Hiring Partner

Primary Responsibility:
• Develop, maintain, and optimize web applications using PHP and the Laravel framework.
• Implement Object-Oriented Programming (OOPS) principles to create scalable and reusable code.
• Design, optimize, and manage relational databases with MySQL.
• Collaborate with cross-functional teams to understand project requirements and deliver high-quality solutions.
• Troubleshoot and debug applications to ensure performance, reliability, and security.
• Maintain coding standards and ensure best practices are followed in development.
• Continuously research and implement the latest web technologies to improve processes and applications.

Required Skills
• Extensive experience in PHP Development with at least 7 years of hands-on experience.
• In-depth knowledge and experience with the Laravel Framework.
• Strong understanding of Object-Oriented Programming (OOPS) concepts.
• Expertise in MySQL database management, including designing and optimizing queries.
• Proven problem-solving abilities and attention to detail.
• Excellent coding practices, including clean, maintainable, and scalable code.

Qualifications
• Bachelor’s degree in Computer Science (CS), Information Technology (IT), BCA, MCA, or any equivalent qualification.

Perks and Benefits
• Competitive compensation package up to 15 LPA.
• Opportunities to work on challenging and impactful projects.
• A collaborative work environment fostering professional growth.
• Locations available in Delhi and Lucknow, with flexibility for the right candidate.

Company Description:-
Workassist is an online recruitment and employment solution provider in India. We offer a platform that connects job seekers with relevant profiles to employers and provides job opportunities to candidates across various industries and experience levels. Our technology-driven e-recruitment process ensures efficient and effective matchmaking between employers and job seekers.

We have adapted to the new normal by embracing virtual recruitment processes and are committed to assisting job seekers in finding the best opportunities and employers in hiring the best talent from around the world.

Working with over 10,000+ recruiters in sectors such as Banking & Finance, Consulting, Sales & Marketing, HR, IT, Operations, and Legal, we strive to connect them with emerging talents to fulfill their hiring needs.

For a seamless job search experience, please visit our website: https://bit.ly/3QBfBU2

(Note) :There are many more opportunities apart from this on the portal. Depending on the skills, you can apply for them as well).

So, if you are ready for a new challenge, a great work environment, and an opportunity to take your career to the next level, don't hesitate to apply today. We are waiting for you!

Skills from this JD

Each row merges API 1 extraction, API 2 library match / v3 orchestration (dimensions + locked dims), and API 3 persistence tags.

PHP Primary Library skill API 3: existing canonical (in_db) Existing skill (matched library)

Canonical: PHP id=2986 · php

Aliases — catalog

PHP (CANONICAL) primary

Stored enrichment (catalog DB)

Category: Language
Sub-category: Programming Language
Confidence: 0.99
Version strategy: NOT_APPLICABLE

Skill profile (library / DB)

Skill nature: LANGUAGE
Volatility: STABLE
Typical lifespan: EVERGREEN
Category id: 6
Sub-category id: 96
Extractable: True
Also category: False

Dimensions (API 2 worklist)

PHP and Magento Extension Points Catalog dimension db id 391

Library dimension (catalog)

Roles linked in library: Magento Dev
PHP and WordPress Hooks Catalog dimension db id 326

Library dimension (catalog)

Roles linked in library: WordPress Dev
Programming Languages & Template Languages Catalog dimension db id 359

Library dimension (catalog)

Roles linked in library: Drupal Dev

API 3 link attempts (this skill)

Dimension	Skill↔dim	Role↔dim	Outcome
PHP and Magento Extension Points php-and-magento-extension-points	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)
PHP and WordPress Hooks php-and-wordpress-hooks	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)
Programming Languages & Template Languages programming-languages-template-languages	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)

Laravel Primary Library skill API 3: existing canonical (in_db) Existing skill (matched library)

Canonical: Laravel id=3798 · laravel

Aliases — catalog

Laravel (CANONICAL) primary
Laravel 10 (VERSION)
Laravel 11 (VERSION)
Laravel 4 (VERSION)
Laravel 5 (VERSION)
Laravel 6 (VERSION)
Laravel 7 (VERSION)
Laravel 8 (VERSION)
Laravel 9 (VERSION)
laravel 10 (VERSION)
laravel 11 (VERSION)
laravel 4 (VERSION)
laravel 5 (VERSION)
laravel 6 (VERSION)
laravel 7 (VERSION)
laravel 8 (VERSION)
laravel 9 (VERSION)

Context tags (catalog)

API Resources Artisan Blade Composer Eloquent Laravel Mix MVC Middleware Queues RESTful Routing Service Providers Testing Tinker Validation

Stored enrichment (catalog DB)

Category: Framework
Sub-category: Web Framework
Vendor: Taylor Otwell
License: mit
Year introduced: 2011
Confidence: 0.99
Version strategy: SEPARATE_ENTITY
Version tag: 11

Maturity reasoning: Laravel appears in many web developer job postings and has strong GitHub activity; it remains a common PHP framework in hiring pipelines, not a niche or sunset technology.

Skill profile (library / DB)

Skill nature: FRAMEWORK
Volatility: STABLE
Typical lifespan: EVERGREEN
Category id: 5
Sub-category id: 35
Extractable: True
Also category: False

Dimensions (API 2 worklist)

Web Application Frameworks Catalog dimension db id 2

Library dimension (catalog)

Roles linked in library: Backend Developer, Fullstack Developer, Fullstack Developer, Java Backend Developer, Node.js Backend Developer, PHP Backend Developer, Python Backend Developer

API 3 link attempts (this skill)

Dimension	Skill↔dim	Role↔dim	Outcome
Web Application Frameworks web-application-frameworks	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)

Object-Oriented Programming Primary New / orchestrated API 3: new canonical path (new) New / unmatched skill (orchestrated in API 2)

Skill enrichment (orchestrator / LLM)

No Stage 7 enrichment blob on this skill (orchestrator skipped enrichment).

Derived legacy fields

Category: Programming Languages
Sub-category: general
Skill nature: CONCEPT
Volatility: STABLE
Typical lifespan: EVERGREEN
Version strategy: UNVERSIONED

MySQL Primary Library skill API 3: existing canonical (in_db) Existing skill (matched library)

Canonical: MySQL id=17 · mysql

Aliases — catalog

MySQL (CANONICAL) primary

Context tags (catalog)

ACID ACID compliance Backup Data Warehousing Database Design ER Diagrams EXPLAIN Indexes InnoDB JOIN Joins MyISAM Normalization PHPMyAdmin Query Optimization Replication SQL SQL queries Stored Procedures Transactions Triggers backup backup and restore backup strategies data modeling data normalization database design database normalization database schema foreign keys indexes indexing joins master-slave normalization performance tuning query optimization read replicas replication schema design schema management sharding stored procedures transaction isolation transaction management transactions triggers

Stored enrichment (catalog DB)

Category: Datastore
Sub-category: Relational Database
Vendor: Oracle Corporation
License: gpl_v2
Year introduced: 1995
Confidence: 0.99
Version strategy: NOT_APPLICABLE

Maturity reasoning: MySQL appears in a large share of backend/DB job descriptions and remains a standard managed offering across AWS RDS, Cloud SQL, and Azure Database, indicating broad hiring-pipeline demand.

Skill profile (library / DB)

Skill nature: TOOL
Volatility: STABLE
Typical lifespan: EVERGREEN
Category id: 3
Sub-category id: 29
Extractable: True
Also category: False

Dimensions (API 2 worklist)

Relational Data Modeling Catalog dimension db id 216

Library dimension (catalog)

Roles linked in library: Fullstack Developer, Fullstack Developer, PHP Backend Developer
Relational Database Design Catalog dimension db id 4

Library dimension (catalog)

Roles linked in library: .NET Backend Developer, Backend Developer, Kotlin Backend Developer, Node.js Backend Developer, Python Backend Developer, Ruby Backend Developer, Scala Backend Developer
Relational Database Usage Catalog dimension db id 371

Library dimension (catalog)

Roles linked in library: Go Backend Developer

API 3 link attempts (this skill)

Dimension	Skill↔dim	Role↔dim	Outcome
Relational Data Modeling relational-data-modeling	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)
Relational Database Design relational-database-design	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)
Relational Database Usage relational-database-usage	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)

All API 3 persistence rows

Same grid as the skill-extractor “Persistence items” table: one row per (skill × dimension) work item.

Skill	Tag	Dimension	Skill↔dim	Role↔dim	Outcome
PHP	in_db	PHP and Magento Extension Points php-and-magento-extension-points	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)
PHP	in_db	PHP and WordPress Hooks php-and-wordpress-hooks	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)
PHP	in_db	Programming Languages & Template Languages programming-languages-template-languages	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)
Laravel	in_db	Web Application Frameworks web-application-frameworks	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)
MySQL	in_db	Relational Data Modeling relational-data-modeling	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)
MySQL	in_db	Relational Database Design relational-database-design	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)
MySQL	in_db	Relational Database Usage relational-database-usage	✓	—	Existing dimension (library) · Role↔dimension skipped (dimension not under chosen role)

Library artifacts (this run)

Kind	Detail	DB id
canonical_skill_proposed	Object-Oriented Programming \| type=Programming Languages subtype=general nature=CONCEPT lifespan=EVERGREEN

nano JD Parser — gpt-4.1-nano click to toggle

RoleSelf motivated

CompanyWorkassist

Experienceat least 7 years of hands-on experience

CTC{'max': 15, 'min': None, 'raw': 'up to 15 LPA', 'period': 'annual', 'currency': 'INR'}

DomainIT Services & Consulting

Location Delhi, India (null)

JD type pass

Show raw JSON

{
  "JD_type": "pass",
  "about_company": {
    "source_marker": {
      "first_5_words": "Workassist is an online recruitment",
      "last_5_words": "fulfill their hiring needs."
    },
    "text": "Workassist is an online recruitment and employment solution provider in India. We offer a platform that connects job seekers with relevant profiles to employers and provides job opportunities to candidates across various industries and experience levels. Our technology-driven e-recruitment process ensures efficient and effective matchmaking between employers and job seekers.\n\nWe have adapted to the new normal by embracing virtual recruitment processes and are committed to assisting job seekers in finding the best opportunities and employers in hiring the best talent from around the world.\n\nWorking with over 10,000+ recruiters in sectors such as Banking \u0026 Finance, Consulting, Sales \u0026 Marketing, HR, IT, Operations, and Legal, we strive to connect them with emerging talents to fulfill their hiring needs.",
    "word_count": 104
  },
  "certifications": [],
  "company_name": "Workassist",
  "ctc": {
    "currency": "INR",
    "max": 15,
    "min": null,
    "period": "annual",
    "raw": "up to 15 LPA"
  },
  "domain": {
    "primary": {
      "aliases": [
        "IT Consulting",
        "Technology Services"
      ],
      "domain": "IT Services \u0026 Consulting"
    },
    "secondary": null
  },
  "education": [
    {
      "level": "Bachelor\u0027s",
      "qualification": "BTECH/BE/BSC/BCA/MCA - Computer Science / Information Technology (or equivalent)",
      "raw": "Bachelor\u2019s degree in Computer Science (CS), Information Technology (IT), BCA, MCA, or any equivalent qualification",
      "requirement": "required"
    }
  ],
  "experience": {
    "max": null,
    "min": 7,
    "raw": "at least 7 years of hands-on experience"
  },
  "job_locations": [
    {
      "aliases": [
        "New Delhi"
      ],
      "city": "Delhi",
      "country": "India",
      "state": null,
      "work_mode": "null"
    },
    {
      "aliases": [],
      "city": "Lucknow",
      "country": "India",
      "state": null,
      "work_mode": "null"
    }
  ],
  "role": "Self motivated",
  "role_aliases": [
    "Software Developer",
    "PHP Developer",
    "Web Developer"
  ],
  "role_archetype": "Engineering",
  "roles_and_responsibilities": [
    {
      "bullet_count": 7,
      "heading": "Primary Responsibility",
      "heading_was_present": true,
      "source_marker": {
        "first_5_words": "\u2022 Develop, maintain, and optimize",
        "last_5_words": "improve processes and applications."
      },
      "text": "\u2022 Develop, maintain, and optimize web applications using PHP and the Laravel framework.\n\u2022 Implement Object-Oriented Programming (OOPS) principles to create scalable and reusable code.\n\u2022 Design, optimize, and manage relational databases with MySQL.\n\u2022 Collaborate with cross-functional teams to understand project requirements and deliver high-quality solutions.\n\u2022 Troubleshoot and debug applications to ensure performance, reliability, and security.\n\u2022 Maintain coding standards and ensure best practices are followed in development.\n\u2022 Continuously research and implement the latest web technologies to improve processes and applications.",
      "word_count": 83
    },
    {
      "bullet_count": 6,
      "heading": "Required Skills",
      "heading_was_present": true,
      "source_marker": {
        "first_5_words": "\u2022 Extensive experience in PHP",
        "last_5_words": "clean, maintainable, and scalable code."
      },
      "text": "\u2022 Extensive experience in PHP Development with at least 7 years of hands-on experience.\n\u2022 In-depth knowledge and experience with the Laravel Framework.\n\u2022 Strong understanding of Object-Oriented Programming (OOPS) concepts.\n\u2022 Expertise in MySQL database management, including designing and optimizing queries.\n\u2022 Proven problem-solving abilities and attention to detail.\n\u2022 Excellent coding practices, including clean, maintainable, and scalable code.",
      "word_count": 66
    },
    {
      "bullet_count": 1,
      "heading": "Qualifications",
      "heading_was_present": true,
      "source_marker": {
        "first_5_words": "\u2022 Bachelor\u2019s degree in Computer",
        "last_5_words": "or any equivalent qualification."
      },
      "text": "\u2022 Bachelor\u2019s degree in Computer Science (CS), Information Technology (IT), BCA, MCA, or any equivalent qualification.",
      "word_count": 19
    }
  ],
  "urls": [
    {
      "type": "website",
      "url": "https://bit.ly/3QBfBU2"
    }
  ]
}

API 1 — extract-from-jd click to toggle

{
  "final_skills": [
    {
      "is_primary": true,
      "skill_name": "PHP"
    },
    {
      "is_primary": true,
      "skill_name": "Laravel"
    },
    {
      "is_primary": true,
      "skill_name": "Object-Oriented Programming"
    },
    {
      "is_primary": true,
      "skill_name": "MySQL"
    }
  ],
  "jd_role": {
    "display_name": "Self motivated",
    "rationale": null,
    "role_aliases": [
      "Software Developer",
      "PHP Developer",
      "Web Developer"
    ],
    "role_archetype": "Engineering",
    "slug": ""
  },
  "nano_parsed": {
    "JD_type": "pass",
    "about_company": {
      "source_marker": {
        "first_5_words": "Workassist is an online recruitment",
        "last_5_words": "fulfill their hiring needs."
      },
      "text": "Workassist is an online recruitment and employment solution provider in India. We offer a platform that connects job seekers with relevant profiles to employers and provides job opportunities to candidates across various industries and experience levels. Our technology-driven e-recruitment process ensures efficient and effective matchmaking between employers and job seekers.\n\nWe have adapted to the new normal by embracing virtual recruitment processes and are committed to assisting job seekers in finding the best opportunities and employers in hiring the best talent from around the world.\n\nWorking with over 10,000+ recruiters in sectors such as Banking \u0026 Finance, Consulting, Sales \u0026 Marketing, HR, IT, Operations, and Legal, we strive to connect them with emerging talents to fulfill their hiring needs.",
      "word_count": 104
    },
    "certifications": [],
    "company_name": "Workassist",
    "ctc": {
      "currency": "INR",
      "max": 15,
      "min": null,
      "period": "annual",
      "raw": "up to 15 LPA"
    },
    "domain": {
      "primary": {
        "aliases": [
          "IT Consulting",
          "Technology Services"
        ],
        "domain": "IT Services \u0026 Consulting"
      },
      "secondary": null
    },
    "education": [
      {
        "level": "Bachelor\u0027s",
        "qualification": "BTECH/BE/BSC/BCA/MCA - Computer Science / Information Technology (or equivalent)",
        "raw": "Bachelor\u2019s degree in Computer Science (CS), Information Technology (IT), BCA, MCA, or any equivalent qualification",
        "requirement": "required"
      }
    ],
    "experience": {
      "max": null,
      "min": 7,
      "raw": "at least 7 years of hands-on experience"
    },
    "job_locations": [
      {
        "aliases": [
          "New Delhi"
        ],
        "city": "Delhi",
        "country": "India",
        "state": null,
        "work_mode": "null"
      },
      {
        "aliases": [],
        "city": "Lucknow",
        "country": "India",
        "state": null,
        "work_mode": "null"
      }
    ],
    "role": "Self motivated",
    "role_aliases": [
      "Software Developer",
      "PHP Developer",
      "Web Developer"
    ],
    "role_archetype": "Engineering",
    "roles_and_responsibilities": [
      {
        "bullet_count": 7,
        "heading": "Primary Responsibility",
        "heading_was_present": true,
        "source_marker": {
          "first_5_words": "\u2022 Develop, maintain, and optimize",
          "last_5_words": "improve processes and applications."
        },
        "text": "\u2022 Develop, maintain, and optimize web applications using PHP and the Laravel framework.\n\u2022 Implement Object-Oriented Programming (OOPS) principles to create scalable and reusable code.\n\u2022 Design, optimize, and manage relational databases with MySQL.\n\u2022 Collaborate with cross-functional teams to understand project requirements and deliver high-quality solutions.\n\u2022 Troubleshoot and debug applications to ensure performance, reliability, and security.\n\u2022 Maintain coding standards and ensure best practices are followed in development.\n\u2022 Continuously research and implement the latest web technologies to improve processes and applications.",
        "word_count": 83
      },
      {
        "bullet_count": 6,
        "heading": "Required Skills",
        "heading_was_present": true,
        "source_marker": {
          "first_5_words": "\u2022 Extensive experience in PHP",
          "last_5_words": "clean, maintainable, and scalable code."
        },
        "text": "\u2022 Extensive experience in PHP Development with at least 7 years of hands-on experience.\n\u2022 In-depth knowledge and experience with the Laravel Framework.\n\u2022 Strong understanding of Object-Oriented Programming (OOPS) concepts.\n\u2022 Expertise in MySQL database management, including designing and optimizing queries.\n\u2022 Proven problem-solving abilities and attention to detail.\n\u2022 Excellent coding practices, including clean, maintainable, and scalable code.",
        "word_count": 66
      },
      {
        "bullet_count": 1,
        "heading": "Qualifications",
        "heading_was_present": true,
        "source_marker": {
          "first_5_words": "\u2022 Bachelor\u2019s degree in Computer",
          "last_5_words": "or any equivalent qualification."
        },
        "text": "\u2022 Bachelor\u2019s degree in Computer Science (CS), Information Technology (IT), BCA, MCA, or any equivalent qualification.",
        "word_count": 19
      }
    ],
    "urls": [
      {
        "type": "website",
        "url": "https://bit.ly/3QBfBU2"
      }
    ]
  },
  "rejected": false,
  "rejection_reason": null,
  "run_id": "e79bec17-46ca-47d3-b9fb-adda6dd18aaa",
  "stage3_signals": {
    "alias_found": true,
    "alias_match_roles": [
      {
        "display_name": "Backend Developer",
        "kra_matches": null,
        "matched_count": null,
        "matched_skills": null,
        "role_id": 1,
        "score": 1.0,
        "slug": "backend-engineer",
        "total_count": null
      },
      {
        "display_name": "PHP Backend Developer",
        "kra_matches": null,
        "matched_count": null,
        "matched_skills": null,
        "role_id": 86,
        "score": 1.0,
        "slug": "php-backend-developer",
        "total_count": null
      },
      {
        "display_name": "Frontend Developer",
        "kra_matches": null,
        "matched_count": null,
        "matched_skills": null,
        "role_id": 7,
        "score": 1.0,
        "slug": "frontend-engineer",
        "total_count": null
      },
      {
        "display_name": "Web Developer",
        "kra_matches": null,
        "matched_count": null,
        "matched_skills": null,
        "role_id": 25,
        "score": 1.0,
        "slug": "web-developer",
        "total_count": null
      }
    ],
    "kra_match_roles": [
      {
        "display_name": "React Native Developer",
        "kra_matches": [
          {
            "kra_text": "maintain code quality",
            "sentence": "Maintain coding standards and ensure best practices are followed in development.",
            "similarity": 0.6975
          },
          {
            "kra_text": "maintain code quality",
            "sentence": "Excellent coding practices, including clean, maintainable, and scalable code.",
            "similarity": 0.6558
          },
          {
            "kra_text": "maintain code quality",
            "sentence": "Implement Object-Oriented Programming (OOPS) principles to create scalable and reusable code.",
            "similarity": 0.4469
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 73,
        "score": 0.6001,
        "slug": "react-native-developer",
        "total_count": null
      },
      {
        "display_name": "Flutter Developer",
        "kra_matches": [
          {
            "kra_text": "collaborate with design, product, and backend teams",
            "sentence": "Collaborate with cross-functional teams to understand project requirements and deliver high-quality solutions.",
            "similarity": 0.637
          },
          {
            "kra_text": "structure reusable application code",
            "sentence": "Implement Object-Oriented Programming (OOPS) principles to create scalable and reusable code.",
            "similarity": 0.5522
          },
          {
            "kra_text": "structure reusable application code",
            "sentence": "Excellent coding practices, including clean, maintainable, and scalable code.",
            "similarity": 0.5019
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 74,
        "score": 0.5637,
        "slug": "flutter-developer",
        "total_count": null
      },
      {
        "display_name": "Fullstack Developer",
        "kra_matches": [
          {
            "kra_text": "Designs and queries relational databases like PostgreSQL and document stores like MongoDB, writing migrations, indexes, and optimized queries.",
            "sentence": "Design, optimize, and manage relational databases with MySQL.",
            "similarity": 0.5921
          },
          {
            "kra_text": "Works closely with product managers and UX designers to translate requirements and wireframes into working software features through iterative development.",
            "sentence": "Collaborate with cross-functional teams to understand project requirements and deliver high-quality solutions.",
            "similarity": 0.5382
          },
          {
            "kra_text": "Debugs full-stack issues that span frontend rendering, API behavior, database queries, and infrastructure configuration to identify root causes.",
            "sentence": "Troubleshoot and debug applications to ensure performance, reliability, and security.",
            "similarity": 0.5354
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 15,
        "score": 0.5553,
        "slug": "full-stack-engineer",
        "total_count": null
      },
      {
        "display_name": "Node.js Backend Developer",
        "kra_matches": [
          {
            "kra_text": "code review and refactoring",
            "sentence": "Excellent coding practices, including clean, maintainable, and scalable code.",
            "similarity": 0.5829
          },
          {
            "kra_text": "defect diagnosis and performance tuning",
            "sentence": "Troubleshoot and debug applications to ensure performance, reliability, and security.",
            "similarity": 0.5411
          },
          {
            "kra_text": "code review and refactoring",
            "sentence": "Maintain coding standards and ensure best practices are followed in development.",
            "similarity": 0.5164
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 82,
        "score": 0.5468,
        "slug": "node-backend-developer",
        "total_count": null
      },
      {
        "display_name": "Angular Frontend Developer",
        "kra_matches": [
          {
            "kra_text": "code review and refactoring",
            "sentence": "Excellent coding practices, including clean, maintainable, and scalable code.",
            "similarity": 0.5829
          },
          {
            "kra_text": "collaboration with design and QA",
            "sentence": "Collaborate with cross-functional teams to understand project requirements and deliver high-quality solutions.",
            "similarity": 0.5291
          },
          {
            "kra_text": "code review and refactoring",
            "sentence": "Maintain coding standards and ensure best practices are followed in development.",
            "similarity": 0.5164
          }
        ],
        "matched_count": null,
        "matched_skills": null,
        "role_id": 90,
        "score": 0.5428,
        "slug": "angular-frontend-developer",
        "total_count": null
      }
    ],
    "skill_match_roles": [
      {
        "display_name": "Fullstack Developer",
        "kra_matches": null,
        "matched_count": 2,
        "matched_skills": [
          "Laravel",
          "MySQL"
        ],
        "role_id": 15,
        "score": 0.5,
        "slug": "full-stack-engineer",
        "total_count": 4
      },
      {
        "display_name": "Node.js Backend Developer",
        "kra_matches": null,
        "matched_count": 2,
        "matched_skills": [
          "Laravel",
          "MySQL"
        ],
        "role_id": 82,
        "score": 0.5,
        "slug": "node-backend-developer",
        "total_count": 4
      },
      {
        "display_name": "Backend Developer",
        "kra_matches": null,
        "matched_count": 2,
        "matched_skills": [
          "Laravel",
          "MySQL"
        ],
        "role_id": 1,
        "score": 0.5,
        "slug": "backend-engineer",
        "total_count": 4
      },
      {
        "display_name": "Python Backend Developer",
        "kra_matches": null,
        "matched_count": 2,
        "matched_skills": [
          "Laravel",
          "MySQL"
        ],
        "role_id": 80,
        "score": 0.5,
        "slug": "python-backend-developer",
        "total_count": 4
      },
      {
        "display_name": "PHP Backend Developer",
        "kra_matches": null,
        "matched_count": 2,
        "matched_skills": [
          "Laravel",
          "MySQL"
        ],
        "role_id": 86,
        "score": 0.5,
        "slug": "php-backend-developer",
        "total_count": 4
      }
    ]
  },
  "stage4_decision": {
    "alias_collision_detected": true,
    "case": "A",
    "chosen_role": {
      "display_name": "Web Developer",
      "kra_matches": null,
      "matched_count": null,
      "matched_skills": null,
      "role_id": 25,
      "score": 1.0,
      "slug": "web-developer",
      "total_count": null
    },
    "confidence": 0.95,
    "is_new_role": false,
    "llm2_fired": false,
    "llm2_reasoning": null,
    "matched_dimensions": [],
    "matched_kras": [],
    "matched_skills": [],
    "new_role_display_name": null,
    "new_role_slug": null,
    "queued": false,
    "reasoning": "Multi-alias tie (4 roles at 1.0) resolved by TIER_B_TITLE: Web Developer",
    "sub_role": null
  },
  "stage5_updates": null
}

API 2 — extract-details

{
  "alias_matches": [
    {
      "alias_persist_skipped_reason": "alias_text already exists for this canonical skill",
      "alias_persisted": false,
      "existing_alias_id": 4444,
      "existing_alias_text": "PHP",
      "input_term": "PHP",
      "matched_canonical": {
        "category_id": 6,
        "display_name": "PHP",
        "id": 2986,
        "is_also_category": false,
        "is_extractable": true,
        "skill_nature": "LANGUAGE",
        "slug": "php",
        "sub_category_id": 96,
        "typical_lifespan": "EVERGREEN",
        "volatility": "STABLE"
      },
      "matched_via": "alias"
    },
    {
      "alias_persist_skipped_reason": "alias_text already exists for this canonical skill",
      "alias_persisted": false,
      "existing_alias_id": 5429,
      "existing_alias_text": "Laravel",
      "input_term": "Laravel",
      "matched_canonical": {
        "category_id": 5,
        "display_name": "Laravel",
        "id": 3798,
        "is_also_category": false,
        "is_extractable": true,
        "skill_nature": "FRAMEWORK",
        "slug": "laravel",
        "sub_category_id": 35,
        "typical_lifespan": "EVERGREEN",
        "volatility": "STABLE"
      },
      "matched_via": "alias"
    },
    {
      "alias_persist_skipped_reason": "alias_text already exists for this canonical skill",
      "alias_persisted": false,
      "existing_alias_id": 134,
      "existing_alias_text": "MySQL",
      "input_term": "MySQL",
      "matched_canonical": {
        "category_id": 3,
        "display_name": "MySQL",
        "id": 17,
        "is_also_category": false,
        "is_extractable": true,
        "skill_nature": "TOOL",
        "slug": "mysql",
        "sub_category_id": 29,
        "typical_lifespan": "EVERGREEN",
        "volatility": "STABLE"
      },
      "matched_via": "alias"
    }
  ],
  "candidate_roles": [
    {
      "display_name": "Magento Dev",
      "id": 231,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "magento-dev",
      "source": "db"
    },
    {
      "display_name": "WordPress Dev",
      "id": 227,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "wordpress-dev",
      "source": "db"
    },
    {
      "display_name": "Drupal Dev",
      "id": 228,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "drupal-dev",
      "source": "db"
    },
    {
      "display_name": "Backend Developer",
      "id": 1,
      "rationale": null,
      "role_archetype": "A Backend Engineer designs, builds, and maintains the server-side logic and data handling that power applications and services. They focus on implementing reliable business functionality, integrating with other systems, and ensuring the backend is scalable, maintainable, and observable.",
      "slug": "backend-engineer",
      "source": "db"
    },
    {
      "display_name": "Fullstack Developer",
      "id": 15,
      "rationale": null,
      "role_archetype": null,
      "slug": "full-stack-engineer",
      "source": "db"
    },
    {
      "display_name": "Fullstack Developer",
      "id": 435,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "fullstack-developer",
      "source": "db"
    },
    {
      "display_name": "Java Backend Developer",
      "id": 79,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "java-backend-developer",
      "source": "db"
    },
    {
      "display_name": "Node.js Backend Developer",
      "id": 82,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "node-backend-developer",
      "source": "db"
    },
    {
      "display_name": "PHP Backend Developer",
      "id": 86,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "php-backend-developer",
      "source": "db"
    },
    {
      "display_name": "Python Backend Developer",
      "id": 80,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "python-backend-developer",
      "source": "db"
    },
    {
      "display_name": ".NET Backend Developer",
      "id": 83,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "dotnet-backend-developer",
      "source": "db"
    },
    {
      "display_name": "Kotlin Backend Developer",
      "id": 84,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "kotlin-server-backend-developer",
      "source": "db"
    },
    {
      "display_name": "Ruby Backend Developer",
      "id": 85,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "ruby-backend-developer",
      "source": "db"
    },
    {
      "display_name": "Scala Backend Developer",
      "id": 87,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "scala-backend-developer",
      "source": "db"
    },
    {
      "display_name": "Go Backend Developer",
      "id": 81,
      "rationale": null,
      "role_archetype": "Engineering",
      "slug": "go-backend-developer",
      "source": "db"
    }
  ],
  "chosen_role": {
    "display_name": "Web Developer",
    "id": 25,
    "rationale": "Multi-alias tie (4 roles at 1.0) resolved by TIER_B_TITLE: Web Developer",
    "role_archetype": null,
    "slug": "web-developer",
    "source": "db"
  },
  "dimensions": [
    {
      "dimension": {
        "difficulty_hint": "well_known",
        "display_name": "PHP and Magento Extension Points",
        "id": 391,
        "rationale": "Core implementation surface for Magento customizations, including module code, event-driven hooks, and platform conventions. This is the primary language-and-framework cluster for building upgrade-safe storefront behavior.",
        "slug": "php-and-magento-extension-points",
        "source": "db"
      },
      "input_skill": "PHP",
      "llm_role": null,
      "roles_from_db": [
        {
          "display_name": "Magento Dev",
          "id": 231,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "magento-dev",
          "source": "db"
        }
      ]
    },
    {
      "dimension": {
        "difficulty_hint": "well_known",
        "display_name": "PHP and WordPress Hooks",
        "id": 326,
        "rationale": "Core implementation language and extension points used to build WordPress behavior. This covers PHP code that powers themes, plugins, and site-specific customizations, plus the hook system that stitches features into WordPress lifecycle events.",
        "slug": "php-and-wordpress-hooks",
        "source": "db"
      },
      "input_skill": "PHP",
      "llm_role": null,
      "roles_from_db": [
        {
          "display_name": "WordPress Dev",
          "id": 227,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "wordpress-dev",
          "source": "db"
        }
      ]
    },
    {
      "dimension": {
        "difficulty_hint": "well_known",
        "display_name": "Programming Languages \u0026 Template Languages",
        "id": 359,
        "rationale": "The languages and domain-specific templating languages used for Drupal development and theming.",
        "slug": "programming-languages-template-languages",
        "source": "db"
      },
      "input_skill": "PHP",
      "llm_role": null,
      "roles_from_db": [
        {
          "display_name": "Drupal Dev",
          "id": 228,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "drupal-dev",
          "source": "db"
        }
      ]
    },
    {
      "dimension": {
        "difficulty_hint": "well_known",
        "display_name": "Web Application Frameworks",
        "id": 2,
        "rationale": "Server frameworks and runtimes used to build HTTP services, controllers, middleware, and request pipelines. These frameworks shape how backend endpoints are structured and delivered.",
        "slug": "web-application-frameworks",
        "source": "db"
      },
      "input_skill": "Laravel",
      "llm_role": null,
      "roles_from_db": [
        {
          "display_name": "Backend Developer",
          "id": 1,
          "rationale": null,
          "role_archetype": "A Backend Engineer designs, builds, and maintains the server-side logic and data handling that power applications and services. They focus on implementing reliable business functionality, integrating with other systems, and ensuring the backend is scalable, maintainable, and observable.",
          "slug": "backend-engineer",
          "source": "db"
        },
        {
          "display_name": "Fullstack Developer",
          "id": 15,
          "rationale": null,
          "role_archetype": null,
          "slug": "full-stack-engineer",
          "source": "db"
        },
        {
          "display_name": "Fullstack Developer",
          "id": 435,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "fullstack-developer",
          "source": "db"
        },
        {
          "display_name": "Java Backend Developer",
          "id": 79,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "java-backend-developer",
          "source": "db"
        },
        {
          "display_name": "Node.js Backend Developer",
          "id": 82,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "node-backend-developer",
          "source": "db"
        },
        {
          "display_name": "PHP Backend Developer",
          "id": 86,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "php-backend-developer",
          "source": "db"
        },
        {
          "display_name": "Python Backend Developer",
          "id": 80,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "python-backend-developer",
          "source": "db"
        }
      ]
    },
    {
      "dimension": {
        "difficulty_hint": "well_known",
        "display_name": "Relational Data Modeling",
        "id": 216,
        "rationale": "Modeling and tuning relational persistence for backend features. PHP backend developers need this to shape schemas, indexes, transactions, and query-aware data structures that support application behavior.",
        "slug": "relational-data-modeling",
        "source": "db"
      },
      "input_skill": "MySQL",
      "llm_role": null,
      "roles_from_db": [
        {
          "display_name": "Fullstack Developer",
          "id": 435,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "fullstack-developer",
          "source": "db"
        },
        {
          "display_name": "Fullstack Developer",
          "id": 15,
          "rationale": null,
          "role_archetype": null,
          "slug": "full-stack-engineer",
          "source": "db"
        },
        {
          "display_name": "PHP Backend Developer",
          "id": 86,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "php-backend-developer",
          "source": "db"
        }
      ]
    },
    {
      "dimension": {
        "difficulty_hint": "well_known",
        "display_name": "Relational Database Design",
        "id": 4,
        "rationale": "Modeling and operating relational persistence for backend services. Includes schema design, normalization, indexing, transactions, and query tuning for operational data stores.",
        "slug": "relational-database-design",
        "source": "db"
      },
      "input_skill": "MySQL",
      "llm_role": null,
      "roles_from_db": [
        {
          "display_name": ".NET Backend Developer",
          "id": 83,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "dotnet-backend-developer",
          "source": "db"
        },
        {
          "display_name": "Backend Developer",
          "id": 1,
          "rationale": null,
          "role_archetype": "A Backend Engineer designs, builds, and maintains the server-side logic and data handling that power applications and services. They focus on implementing reliable business functionality, integrating with other systems, and ensuring the backend is scalable, maintainable, and observable.",
          "slug": "backend-engineer",
          "source": "db"
        },
        {
          "display_name": "Kotlin Backend Developer",
          "id": 84,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "kotlin-server-backend-developer",
          "source": "db"
        },
        {
          "display_name": "Node.js Backend Developer",
          "id": 82,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "node-backend-developer",
          "source": "db"
        },
        {
          "display_name": "Python Backend Developer",
          "id": 80,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "python-backend-developer",
          "source": "db"
        },
        {
          "display_name": "Ruby Backend Developer",
          "id": 85,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "ruby-backend-developer",
          "source": "db"
        },
        {
          "display_name": "Scala Backend Developer",
          "id": 87,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "scala-backend-developer",
          "source": "db"
        }
      ]
    },
    {
      "dimension": {
        "difficulty_hint": "well_known",
        "display_name": "Relational Database Usage",
        "id": 371,
        "rationale": "Working effectively with operational relational databases from Go backend services. This includes schema-aware querying, indexing awareness, transactions, and understanding how service code interacts with PostgreSQL or similar systems.",
        "slug": "relational-database-usage",
        "source": "db"
      },
      "input_skill": "MySQL",
      "llm_role": null,
      "roles_from_db": [
        {
          "display_name": "Go Backend Developer",
          "id": 81,
          "rationale": null,
          "role_archetype": "Engineering",
          "slug": "go-backend-developer",
          "source": "db"
        }
      ]
    }
  ],
  "input_final_skills": [
    "PHP",
    "Laravel",
    "Object-Oriented Programming",
    "MySQL"
  ],
  "input_llm_skills": [
    "PHP",
    "Laravel",
    "Object-Oriented Programming",
    "MySQL"
  ],
  "new_aliases_persisted": 0,
  "run_id": "e79bec17-46ca-47d3-b9fb-adda6dd18aaa",
  "skills_detail": [
    {
      "aliases_in_db": [
        {
          "alias_text": "PHP",
          "alias_type": "CANONICAL",
          "id": 4444,
          "is_primary": true,
          "match_strategy": "CASE_INSENSITIVE"
        }
      ],
      "canonical": {
        "category_id": 6,
        "display_name": "PHP",
        "id": 2986,
        "is_also_category": false,
        "is_extractable": true,
        "skill_nature": "LANGUAGE",
        "slug": "php",
        "sub_category_id": 96,
        "typical_lifespan": "EVERGREEN",
        "volatility": "STABLE"
      },
      "dimensions": [
        {
          "dimension": {
            "difficulty_hint": "well_known",
            "display_name": "PHP and Magento Extension Points",
            "id": 391,
            "rationale": "Core implementation surface for Magento customizations, including module code, event-driven hooks, and platform conventions. This is the primary language-and-framework cluster for building upgrade-safe storefront behavior.",
            "slug": "php-and-magento-extension-points",
            "source": "db"
          },
          "input_skill": "PHP",
          "llm_role": null,
          "roles_from_db": [
            {
              "display_name": "Magento Dev",
              "id": 231,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "magento-dev",
              "source": "db"
            }
          ]
        },
        {
          "dimension": {
            "difficulty_hint": "well_known",
            "display_name": "PHP and WordPress Hooks",
            "id": 326,
            "rationale": "Core implementation language and extension points used to build WordPress behavior. This covers PHP code that powers themes, plugins, and site-specific customizations, plus the hook system that stitches features into WordPress lifecycle events.",
            "slug": "php-and-wordpress-hooks",
            "source": "db"
          },
          "input_skill": "PHP",
          "llm_role": null,
          "roles_from_db": [
            {
              "display_name": "WordPress Dev",
              "id": 227,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "wordpress-dev",
              "source": "db"
            }
          ]
        },
        {
          "dimension": {
            "difficulty_hint": "well_known",
            "display_name": "Programming Languages \u0026 Template Languages",
            "id": 359,
            "rationale": "The languages and domain-specific templating languages used for Drupal development and theming.",
            "slug": "programming-languages-template-languages",
            "source": "db"
          },
          "input_skill": "PHP",
          "llm_role": null,
          "roles_from_db": [
            {
              "display_name": "Drupal Dev",
              "id": 228,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "drupal-dev",
              "source": "db"
            }
          ]
        }
      ],
      "input_skill": "PHP",
      "matched_via": "alias",
      "new_alias_persisted": false,
      "new_alias_text": null,
      "new_skill_meta": null,
      "source_tag": "db",
      "was_in_llm_skills": true
    },
    {
      "aliases_in_db": [
        {
          "alias_text": "Laravel",
          "alias_type": "CANONICAL",
          "id": 5429,
          "is_primary": true,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "Laravel 10",
          "alias_type": "VERSION",
          "id": 5442,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "Laravel 11",
          "alias_type": "VERSION",
          "id": 5443,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "Laravel 4",
          "alias_type": "VERSION",
          "id": 5430,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "Laravel 5",
          "alias_type": "VERSION",
          "id": 5431,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "Laravel 6",
          "alias_type": "VERSION",
          "id": 5432,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "Laravel 7",
          "alias_type": "VERSION",
          "id": 5433,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "Laravel 8",
          "alias_type": "VERSION",
          "id": 5434,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "Laravel 9",
          "alias_type": "VERSION",
          "id": 5435,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "laravel 10",
          "alias_type": "VERSION",
          "id": 5444,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "laravel 11",
          "alias_type": "VERSION",
          "id": 5445,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "laravel 4",
          "alias_type": "VERSION",
          "id": 5436,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "laravel 5",
          "alias_type": "VERSION",
          "id": 5437,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "laravel 6",
          "alias_type": "VERSION",
          "id": 5438,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "laravel 7",
          "alias_type": "VERSION",
          "id": 5439,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "laravel 8",
          "alias_type": "VERSION",
          "id": 5440,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        },
        {
          "alias_text": "laravel 9",
          "alias_type": "VERSION",
          "id": 5441,
          "is_primary": false,
          "match_strategy": "CASE_INSENSITIVE"
        }
      ],
      "canonical": {
        "category_id": 5,
        "display_name": "Laravel",
        "id": 3798,
        "is_also_category": false,
        "is_extractable": true,
        "skill_nature": "FRAMEWORK",
        "slug": "laravel",
        "sub_category_id": 35,
        "typical_lifespan": "EVERGREEN",
        "volatility": "STABLE"
      },
      "dimensions": [
        {
          "dimension": {
            "difficulty_hint": "well_known",
            "display_name": "Web Application Frameworks",
            "id": 2,
            "rationale": "Server frameworks and runtimes used to build HTTP services, controllers, middleware, and request pipelines. These frameworks shape how backend endpoints are structured and delivered.",
            "slug": "web-application-frameworks",
            "source": "db"
          },
          "input_skill": "Laravel",
          "llm_role": null,
          "roles_from_db": [
            {
              "display_name": "Backend Developer",
              "id": 1,
              "rationale": null,
              "role_archetype": "A Backend Engineer designs, builds, and maintains the server-side logic and data handling that power applications and services. They focus on implementing reliable business functionality, integrating with other systems, and ensuring the backend is scalable, maintainable, and observable.",
              "slug": "backend-engineer",
              "source": "db"
            },
            {
              "display_name": "Fullstack Developer",
              "id": 15,
              "rationale": null,
              "role_archetype": null,
              "slug": "full-stack-engineer",
              "source": "db"
            },
            {
              "display_name": "Fullstack Developer",
              "id": 435,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "fullstack-developer",
              "source": "db"
            },
            {
              "display_name": "Java Backend Developer",
              "id": 79,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "java-backend-developer",
              "source": "db"
            },
            {
              "display_name": "Node.js Backend Developer",
              "id": 82,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "node-backend-developer",
              "source": "db"
            },
            {
              "display_name": "PHP Backend Developer",
              "id": 86,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "php-backend-developer",
              "source": "db"
            },
            {
              "display_name": "Python Backend Developer",
              "id": 80,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "python-backend-developer",
              "source": "db"
            }
          ]
        }
      ],
      "input_skill": "Laravel",
      "matched_via": "alias",
      "new_alias_persisted": false,
      "new_alias_text": null,
      "new_skill_meta": null,
      "source_tag": "db",
      "was_in_llm_skills": true
    },
    {
      "aliases_in_db": [],
      "canonical": null,
      "dimensions": [],
      "input_skill": "Object-Oriented Programming",
      "matched_via": null,
      "new_alias_persisted": false,
      "new_alias_text": null,
      "new_skill_meta": {
        "derived": {
          "category": "Programming Languages",
          "skill_nature": "CONCEPT",
          "sub_category": "general",
          "typical_lifespan": "EVERGREEN",
          "version_strategy": "UNVERSIONED",
          "volatility": "STABLE"
        },
        "enrichment": null,
        "keep_log": [],
        "locked_dimensions": [],
        "merge_log": [],
        "placed": null,
        "relationships": null,
        "skill_id": "object-oriented-programming",
        "split_log": [],
        "typed": null,
        "warnings": []
      },
      "source_tag": "llm",
      "was_in_llm_skills": true
    },
    {
      "aliases_in_db": [
        {
          "alias_text": "MySQL",
          "alias_type": "CANONICAL",
          "id": 134,
          "is_primary": true,
          "match_strategy": "CASE_INSENSITIVE"
        }
      ],
      "canonical": {
        "category_id": 3,
        "display_name": "MySQL",
        "id": 17,
        "is_also_category": false,
        "is_extractable": true,
        "skill_nature": "TOOL",
        "slug": "mysql",
        "sub_category_id": 29,
        "typical_lifespan": "EVERGREEN",
        "volatility": "STABLE"
      },
      "dimensions": [
        {
          "dimension": {
            "difficulty_hint": "well_known",
            "display_name": "Relational Data Modeling",
            "id": 216,
            "rationale": "Modeling and tuning relational persistence for backend features. PHP backend developers need this to shape schemas, indexes, transactions, and query-aware data structures that support application behavior.",
            "slug": "relational-data-modeling",
            "source": "db"
          },
          "input_skill": "MySQL",
          "llm_role": null,
          "roles_from_db": [
            {
              "display_name": "Fullstack Developer",
              "id": 435,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "fullstack-developer",
              "source": "db"
            },
            {
              "display_name": "Fullstack Developer",
              "id": 15,
              "rationale": null,
              "role_archetype": null,
              "slug": "full-stack-engineer",
              "source": "db"
            },
            {
              "display_name": "PHP Backend Developer",
              "id": 86,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "php-backend-developer",
              "source": "db"
            }
          ]
        },
        {
          "dimension": {
            "difficulty_hint": "well_known",
            "display_name": "Relational Database Design",
            "id": 4,
            "rationale": "Modeling and operating relational persistence for backend services. Includes schema design, normalization, indexing, transactions, and query tuning for operational data stores.",
            "slug": "relational-database-design",
            "source": "db"
          },
          "input_skill": "MySQL",
          "llm_role": null,
          "roles_from_db": [
            {
              "display_name": ".NET Backend Developer",
              "id": 83,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "dotnet-backend-developer",
              "source": "db"
            },
            {
              "display_name": "Backend Developer",
              "id": 1,
              "rationale": null,
              "role_archetype": "A Backend Engineer designs, builds, and maintains the server-side logic and data handling that power applications and services. They focus on implementing reliable business functionality, integrating with other systems, and ensuring the backend is scalable, maintainable, and observable.",
              "slug": "backend-engineer",
              "source": "db"
            },
            {
              "display_name": "Kotlin Backend Developer",
              "id": 84,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "kotlin-server-backend-developer",
              "source": "db"
            },
            {
              "display_name": "Node.js Backend Developer",
              "id": 82,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "node-backend-developer",
              "source": "db"
            },
            {
              "display_name": "Python Backend Developer",
              "id": 80,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "python-backend-developer",
              "source": "db"
            },
            {
              "display_name": "Ruby Backend Developer",
              "id": 85,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "ruby-backend-developer",
              "source": "db"
            },
            {
              "display_name": "Scala Backend Developer",
              "id": 87,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "scala-backend-developer",
              "source": "db"
            }
          ]
        },
        {
          "dimension": {
            "difficulty_hint": "well_known",
            "display_name": "Relational Database Usage",
            "id": 371,
            "rationale": "Working effectively with operational relational databases from Go backend services. This includes schema-aware querying, indexing awareness, transactions, and understanding how service code interacts with PostgreSQL or similar systems.",
            "slug": "relational-database-usage",
            "source": "db"
          },
          "input_skill": "MySQL",
          "llm_role": null,
          "roles_from_db": [
            {
              "display_name": "Go Backend Developer",
              "id": 81,
              "rationale": null,
              "role_archetype": "Engineering",
              "slug": "go-backend-developer",
              "source": "db"
            }
          ]
        }
      ],
      "input_skill": "MySQL",
      "matched_via": "alias",
      "new_alias_persisted": false,
      "new_alias_text": null,
      "new_skill_meta": null,
      "source_tag": "db",
      "was_in_llm_skills": true
    }
  ],
  "unmatched_skills": [
    "Object-Oriented Programming"
  ]
}

API 3 — final-role-output

{
  "chosen_role": {
    "display_name": "Web Developer",
    "id": 25,
    "rationale": "Multi-alias tie (4 roles at 1.0) resolved by TIER_B_TITLE: Web Developer",
    "role_archetype": null,
    "slug": "web-developer",
    "source": "db"
  },
  "chosen_role_resolution": "in_db",
  "final_input_skills": [
    {
      "skill": "PHP",
      "tag": "in_db"
    },
    {
      "skill": "Laravel",
      "tag": "in_db"
    },
    {
      "skill": "Object-Oriented Programming",
      "tag": "new"
    },
    {
      "skill": "MySQL",
      "tag": "in_db"
    }
  ],
  "llm_cost_api1_usd": null,
  "llm_cost_api2_usd": null,
  "llm_cost_api3_usd": null,
  "llm_cost_total_usd": null,
  "persistence": {
    "items": [
      {
        "chosen_role_id": 25,
        "dimension": {
          "difficulty_hint": "well_known",
          "display_name": "PHP and Magento Extension Points",
          "id": 391,
          "rationale": "Core implementation surface for Magento customizations, including module code, event-driven hooks, and platform conventions. This is the primary language-and-framework cluster for building upgrade-safe storefront behavior.",
          "slug": "php-and-magento-extension-points",
          "source": "db"
        },
        "dimension_id": 391,
        "input_skill": "PHP",
        "llm_role": null,
        "matched_chosen_role": false,
        "outcome_line": "Existing dimension (library) \u00b7 Role\u2194dimension skipped (dimension not under chosen role)",
        "role_dimension_saved": false,
        "roles_from_db": [
          {
            "display_name": "Magento Dev",
            "id": 231,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "magento-dev",
            "source": "db"
          }
        ],
        "skill_dimension_saved": true,
        "skill_id": 2986,
        "skill_tag": "in_db",
        "skipped_reason": null
      },
      {
        "chosen_role_id": 25,
        "dimension": {
          "difficulty_hint": "well_known",
          "display_name": "PHP and WordPress Hooks",
          "id": 326,
          "rationale": "Core implementation language and extension points used to build WordPress behavior. This covers PHP code that powers themes, plugins, and site-specific customizations, plus the hook system that stitches features into WordPress lifecycle events.",
          "slug": "php-and-wordpress-hooks",
          "source": "db"
        },
        "dimension_id": 326,
        "input_skill": "PHP",
        "llm_role": null,
        "matched_chosen_role": false,
        "outcome_line": "Existing dimension (library) \u00b7 Role\u2194dimension skipped (dimension not under chosen role)",
        "role_dimension_saved": false,
        "roles_from_db": [
          {
            "display_name": "WordPress Dev",
            "id": 227,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "wordpress-dev",
            "source": "db"
          }
        ],
        "skill_dimension_saved": true,
        "skill_id": 2986,
        "skill_tag": "in_db",
        "skipped_reason": null
      },
      {
        "chosen_role_id": 25,
        "dimension": {
          "difficulty_hint": "well_known",
          "display_name": "Programming Languages \u0026 Template Languages",
          "id": 359,
          "rationale": "The languages and domain-specific templating languages used for Drupal development and theming.",
          "slug": "programming-languages-template-languages",
          "source": "db"
        },
        "dimension_id": 359,
        "input_skill": "PHP",
        "llm_role": null,
        "matched_chosen_role": false,
        "outcome_line": "Existing dimension (library) \u00b7 Role\u2194dimension skipped (dimension not under chosen role)",
        "role_dimension_saved": false,
        "roles_from_db": [
          {
            "display_name": "Drupal Dev",
            "id": 228,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "drupal-dev",
            "source": "db"
          }
        ],
        "skill_dimension_saved": true,
        "skill_id": 2986,
        "skill_tag": "in_db",
        "skipped_reason": null
      },
      {
        "chosen_role_id": 25,
        "dimension": {
          "difficulty_hint": "well_known",
          "display_name": "Web Application Frameworks",
          "id": 2,
          "rationale": "Server frameworks and runtimes used to build HTTP services, controllers, middleware, and request pipelines. These frameworks shape how backend endpoints are structured and delivered.",
          "slug": "web-application-frameworks",
          "source": "db"
        },
        "dimension_id": 2,
        "input_skill": "Laravel",
        "llm_role": null,
        "matched_chosen_role": false,
        "outcome_line": "Existing dimension (library) \u00b7 Role\u2194dimension skipped (dimension not under chosen role)",
        "role_dimension_saved": false,
        "roles_from_db": [
          {
            "display_name": "Backend Developer",
            "id": 1,
            "rationale": null,
            "role_archetype": "A Backend Engineer designs, builds, and maintains the server-side logic and data handling that power applications and services. They focus on implementing reliable business functionality, integrating with other systems, and ensuring the backend is scalable, maintainable, and observable.",
            "slug": "backend-engineer",
            "source": "db"
          },
          {
            "display_name": "Fullstack Developer",
            "id": 15,
            "rationale": null,
            "role_archetype": null,
            "slug": "full-stack-engineer",
            "source": "db"
          },
          {
            "display_name": "Fullstack Developer",
            "id": 435,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "fullstack-developer",
            "source": "db"
          },
          {
            "display_name": "Java Backend Developer",
            "id": 79,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "java-backend-developer",
            "source": "db"
          },
          {
            "display_name": "Node.js Backend Developer",
            "id": 82,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "node-backend-developer",
            "source": "db"
          },
          {
            "display_name": "PHP Backend Developer",
            "id": 86,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "php-backend-developer",
            "source": "db"
          },
          {
            "display_name": "Python Backend Developer",
            "id": 80,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "python-backend-developer",
            "source": "db"
          }
        ],
        "skill_dimension_saved": true,
        "skill_id": 3798,
        "skill_tag": "in_db",
        "skipped_reason": null
      },
      {
        "chosen_role_id": 25,
        "dimension": {
          "difficulty_hint": "well_known",
          "display_name": "Relational Data Modeling",
          "id": 216,
          "rationale": "Modeling and tuning relational persistence for backend features. PHP backend developers need this to shape schemas, indexes, transactions, and query-aware data structures that support application behavior.",
          "slug": "relational-data-modeling",
          "source": "db"
        },
        "dimension_id": 216,
        "input_skill": "MySQL",
        "llm_role": null,
        "matched_chosen_role": false,
        "outcome_line": "Existing dimension (library) \u00b7 Role\u2194dimension skipped (dimension not under chosen role)",
        "role_dimension_saved": false,
        "roles_from_db": [
          {
            "display_name": "Fullstack Developer",
            "id": 435,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "fullstack-developer",
            "source": "db"
          },
          {
            "display_name": "Fullstack Developer",
            "id": 15,
            "rationale": null,
            "role_archetype": null,
            "slug": "full-stack-engineer",
            "source": "db"
          },
          {
            "display_name": "PHP Backend Developer",
            "id": 86,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "php-backend-developer",
            "source": "db"
          }
        ],
        "skill_dimension_saved": true,
        "skill_id": 17,
        "skill_tag": "in_db",
        "skipped_reason": null
      },
      {
        "chosen_role_id": 25,
        "dimension": {
          "difficulty_hint": "well_known",
          "display_name": "Relational Database Design",
          "id": 4,
          "rationale": "Modeling and operating relational persistence for backend services. Includes schema design, normalization, indexing, transactions, and query tuning for operational data stores.",
          "slug": "relational-database-design",
          "source": "db"
        },
        "dimension_id": 4,
        "input_skill": "MySQL",
        "llm_role": null,
        "matched_chosen_role": false,
        "outcome_line": "Existing dimension (library) \u00b7 Role\u2194dimension skipped (dimension not under chosen role)",
        "role_dimension_saved": false,
        "roles_from_db": [
          {
            "display_name": ".NET Backend Developer",
            "id": 83,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "dotnet-backend-developer",
            "source": "db"
          },
          {
            "display_name": "Backend Developer",
            "id": 1,
            "rationale": null,
            "role_archetype": "A Backend Engineer designs, builds, and maintains the server-side logic and data handling that power applications and services. They focus on implementing reliable business functionality, integrating with other systems, and ensuring the backend is scalable, maintainable, and observable.",
            "slug": "backend-engineer",
            "source": "db"
          },
          {
            "display_name": "Kotlin Backend Developer",
            "id": 84,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "kotlin-server-backend-developer",
            "source": "db"
          },
          {
            "display_name": "Node.js Backend Developer",
            "id": 82,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "node-backend-developer",
            "source": "db"
          },
          {
            "display_name": "Python Backend Developer",
            "id": 80,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "python-backend-developer",
            "source": "db"
          },
          {
            "display_name": "Ruby Backend Developer",
            "id": 85,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "ruby-backend-developer",
            "source": "db"
          },
          {
            "display_name": "Scala Backend Developer",
            "id": 87,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "scala-backend-developer",
            "source": "db"
          }
        ],
        "skill_dimension_saved": true,
        "skill_id": 17,
        "skill_tag": "in_db",
        "skipped_reason": null
      },
      {
        "chosen_role_id": 25,
        "dimension": {
          "difficulty_hint": "well_known",
          "display_name": "Relational Database Usage",
          "id": 371,
          "rationale": "Working effectively with operational relational databases from Go backend services. This includes schema-aware querying, indexing awareness, transactions, and understanding how service code interacts with PostgreSQL or similar systems.",
          "slug": "relational-database-usage",
          "source": "db"
        },
        "dimension_id": 371,
        "input_skill": "MySQL",
        "llm_role": null,
        "matched_chosen_role": false,
        "outcome_line": "Existing dimension (library) \u00b7 Role\u2194dimension skipped (dimension not under chosen role)",
        "role_dimension_saved": false,
        "roles_from_db": [
          {
            "display_name": "Go Backend Developer",
            "id": 81,
            "rationale": null,
            "role_archetype": "Engineering",
            "slug": "go-backend-developer",
            "source": "db"
          }
        ],
        "skill_dimension_saved": true,
        "skill_id": 17,
        "skill_tag": "in_db",
        "skipped_reason": null
      }
    ],
    "new_skills_created": 0,
    "role_dimension_saved": 0,
    "skill_dimension_saved": 0,
    "skipped": 0
  },
  "planner_output": null,
  "run_id": "e79bec17-46ca-47d3-b9fb-adda6dd18aaa"
}