fix: truncate question input to 500 characters for embedding generation

refactor: update database connection handling and dependency injection for PostgreSQL and Qdrant

init