Good day. There is a chat with the frontend, created on AI SDK 5, https://ai-sdk.dev/. It is necessary to fix backend errors. In particular, the following tasks need to be done:
1. Implement job search with a database in chat mode. The job database is MariaDB (MySQL).
2. Enable job addition through chat so that a job added via chat goes to My Jobs or to General jobs. The table and structure of the database have been developed with existing jobs.
3. Implement file insertion in tsx format in the chat when displaying search results for jobs; when adding a new job, the insertion does not add them to the job database, and the search does not occur. A ready solution is available here https://vercel.com/templates/next.js/gemini-ai-chatbot
4. Jobs for search are currently structured in the job database mariadb by tables.
5. The chat should analyze available jobs and suggest the best solutions.
6. Other minor adjustments according to AI SDK 5; a working solution is available in git and can be provided if necessary.
OpenAI API, Gemini are available. We are considering candidates for further collaboration on this project. There are several safes after the completion of this.