[Feature]: Change the migration for the AiSearch table to be optional.

[pboers1988]

Contact Details

No response

What should we build?

This migration assumes the pgvector extension, however this may not be installed in all environments. Proposed solution would be to remove the migration from the tree and run the migration when LLM_ENABLED = True with an on CONFLICT DO NOTHING clause. In that case when the migration fails, people can be pointed at the documentation where we indicate how to install pgvector. In other words instrument it in the AgenticOrchestratorCore class

Relevant pseudo code

def run_migration():
    op.execute(
         "CREATE TABLE ...... ON CONFLICT DO NOTHING"
     )
    ....

class AgenticOrchestratorCore():
     def __init__(self, *args,**kwargs):
         run_migration()
         ....