Arabic AI Auto-Responder with Embedded Links
Budget: $30 – $250 USD
Hybrid AI + Database Search Assistant (OpenAI + ASP.NET + SQL Server)
Description:
We are building a smart question-answering assistant that combines natural language understanding (via OpenAI) with accurate, real-time search results from a structured SQL Server database.
Objective:
Create a system that:
Accepts a user’s question (in Arabic).
Uses OpenAI (e.g., GPT-4 Turbo) to understand the query semantically and extract key search criteria.
Queries a pre-existing database using these extracted fields (e.g., keywords, dates, IDs).
Generates a smart AI answer and attaches real, validated links from our database that support the response.
What We Need:
AI Integration:
Process Arabic user input using OpenAI’s API (chat/completions endpoint).
Extract structured data such as keywords, year ranges, IDs, etc.
Optional: Score keyword importance.
Data Linking:
Search SQL Server based on AI-extracted metadata.
Return real matching records and generate links from our existing URL schema.
Output Construction:
Display an AI-generated natural-language answer.
At the bottom, add real links from the database (no hallucinated URLs).
Example:
[AI Answer]
Sources:
Document 1
Document 2
Stack:
Backend: ASP.NET Core MVC 8 (C#)
Database: SQL Server
AI: OpenAI API (chat/completions or instruct models)
Important Notes:
Input language: Arabic
Output: Arabic or English
Responses must be grounded in real data — no AI-invented links
Experience handling RTL and UTF-8 content is important
Deliverables:
End-to-end working API or class with:
OpenAI query
SQL Server search logic
Combined response output
Code must be clean, extensible, and commented
Any configuration details (API keys, base URLs, etc.) should be clearly isolated
Description:
We are building a smart question-answering assistant that combines natural language understanding (via OpenAI) with accurate, real-time search results from a structured SQL Server database.
Objective:
Create a system that:
Accepts a user’s question (in Arabic).
Uses OpenAI (e.g., GPT-4 Turbo) to understand the query semantically and extract key search criteria.
Queries a pre-existing database using these extracted fields (e.g., keywords, dates, IDs).
Generates a smart AI answer and attaches real, validated links from our database that support the response.
What We Need:
AI Integration:
Process Arabic user input using OpenAI’s API (chat/completions endpoint).
Extract structured data such as keywords, year ranges, IDs, etc.
Optional: Score keyword importance.
Data Linking:
Search SQL Server based on AI-extracted metadata.
Return real matching records and generate links from our existing URL schema.
Output Construction:
Display an AI-generated natural-language answer.
At the bottom, add real links from the database (no hallucinated URLs).
Example:
[AI Answer]
Sources:
Document 1
Document 2
Stack:
Backend: ASP.NET Core MVC 8 (C#)
Database: SQL Server
AI: OpenAI API (chat/completions or instruct models)
Important Notes:
Input language: Arabic
Output: Arabic or English
Responses must be grounded in real data — no AI-invented links
Experience handling RTL and UTF-8 content is important
Deliverables:
End-to-end working API or class with:
OpenAI query
SQL Server search logic
Combined response output
Code must be clean, extensible, and commented
Any configuration details (API keys, base URLs, etc.) should be clearly isolated