Generate a CV for this Job!
Based on your profile and this job description, you can create a tailored CV to apply directly.
Laravel Chatbot Developer | ChatGPT + PgVector Integration
Upwork • , US • Remote
Posted on: 5th March, 2025
Employment Type: CONTRACTOR
Job Description
We need a Laravel developer to build a chatbot demo that integrates ChatGPT with product details and support FAQs stored in MySQL & PgVector. The chatbot should intelligently retrieve structured data from MySQL and use semantic search via PgVector for unstructured FAQ-based queries.
Key Requirements:
✅ Chatbot Development:
• Implement a chatbot UI to handle product & support-related queries.
• Use OpenAI’s ChatGPT API for response generation.
• Prioritize MySQL for structured data and PgVector for semantic search.
✅ Database & AI Integration:
• Store product details in MySQL for exact lookups.
• Store FAQs & knowledge in PgVector for fuzzy matching.
• Automatically update both databases when new data is added.
✅ Functionality:
• If the query is direct (e.g., “What is the price of X?”) → Search MySQL.
• If the query is contextual (e.g., “Which product is best for travelers?”) → Search PgVector.
• If no relevant data is found → Fallback to ChatGPT’s general knowledge.
✅ Tech Stack:
• Laravel (backend)
• MySQL (structured product storage)
• PgVector (vector-based knowledge search)
• ChatGPT API (AI-powered responses)
• Blade / Vue.js (chat UI)
Who We Need:
• Experience with Laravel, MySQL, and PgVector.
• Hands-on experience with ChatGPT API & semantic search.
• Ability to optimize fast, intelligent data retrieval.
Deliverables:
• A working chatbot demo with real-time MySQL & PgVector integration.
• A system that auto-updates PgVector when new knowledge is added.
• Documentation on how to manage chatbot knowledge.
If you’ve built AI-powered chatbots before, apply with examples of your work. We look forward to working with you!
Key Requirements:
✅ Chatbot Development:
• Implement a chatbot UI to handle product & support-related queries.
• Use OpenAI’s ChatGPT API for response generation.
• Prioritize MySQL for structured data and PgVector for semantic search.
✅ Database & AI Integration:
• Store product details in MySQL for exact lookups.
• Store FAQs & knowledge in PgVector for fuzzy matching.
• Automatically update both databases when new data is added.
✅ Functionality:
• If the query is direct (e.g., “What is the price of X?”) → Search MySQL.
• If the query is contextual (e.g., “Which product is best for travelers?”) → Search PgVector.
• If no relevant data is found → Fallback to ChatGPT’s general knowledge.
✅ Tech Stack:
• Laravel (backend)
• MySQL (structured product storage)
• PgVector (vector-based knowledge search)
• ChatGPT API (AI-powered responses)
• Blade / Vue.js (chat UI)
Who We Need:
• Experience with Laravel, MySQL, and PgVector.
• Hands-on experience with ChatGPT API & semantic search.
• Ability to optimize fast, intelligent data retrieval.
Deliverables:
• A working chatbot demo with real-time MySQL & PgVector integration.
• A system that auto-updates PgVector when new knowledge is added.
• Documentation on how to manage chatbot knowledge.
If you’ve built AI-powered chatbots before, apply with examples of your work. We look forward to working with you!
Responsibilities
- The chatbot should intelligently retrieve structured data from MySQL and use semantic search via PgVector for unstructured FAQ-based queries
- Implement a chatbot UI to handle product & support-related queries
- Use OpenAI’s ChatGPT API for response generation
- Prioritize MySQL for structured data and PgVector for semantic search
- Store product details in MySQL for exact lookups
- Store FAQs & knowledge in PgVector for fuzzy matching
- If the query is contextual (e.g., “Which product is best for travelers?”) → Search PgVector
- Laravel (backend)
- A working chatbot demo with real-time MySQL & PgVector integration
Requirements
- Automatically update both databases when new data is added
- MySQL (structured product storage)
- PgVector (vector-based knowledge search)
- Experience with Laravel, MySQL, and PgVector
- Hands-on experience with ChatGPT API & semantic search
- Ability to optimize fast, intelligent data retrieval
- A system that auto-updates PgVector when new knowledge is added
- Documentation on how to manage chatbot knowledge
Upwork
Technology
Job Type
CONTRACTOR
Loading...
Loading...
AI Cover Letter Generator
Generate a Tailored Cover Letter!
Our AI will analyze your profile and create a personalized cover letter that highlights your relevant skills and experience.
Related Jobs
GovTribe
1 month ago
Senior Front-End Engineer (Vue.js, Laravel)
District of Columbia, US
View Job
Upwork
1 month ago
Laravel Developer Team Needed for Redesign and Feature Enhancement
, US
View Job