# lifecyclemodel-hybrid-search

> Supabase edge function supabase/functions/lifecyclemodel_hybrid_search that builds hybrid search queries for lifecycle models and calls `hybrid_search_lifecyclemodels`. Use when tuning prompts, embeddings, or auth/env for lifecycle model retrieval.

- Author: Nan LI
- Repository: tiangong-lca/skills
- Version: 20260203164930
- Stars: 3
- Forks: 2
- Last Updated: 2026-02-06
- Source: https://github.com/tiangong-lca/skills
- Web: https://mule.run/skillshub/@@tiangong-lca/skills~lifecyclemodel-hybrid-search:20260203164930

---

---
name: lifecyclemodel-hybrid-search
description: Supabase edge function supabase/functions/lifecyclemodel_hybrid_search that builds hybrid search queries for lifecycle models and calls `hybrid_search_lifecyclemodels`. Use when tuning prompts, embeddings, or auth/env for lifecycle model retrieval.
---

# Lifecycle Model Hybrid Search

## Quick start (remote only)
- Endpoint: `https://qgzvkongdjqiiamzbbts.supabase.co/functions/v1/`
- Header: `x-region: us-east-1`
- Requires `Authorization: Bearer <TOKEN>`.
- `TOKEN` is either an OAuth JWT or a user key generated in the system (derived from email + password).
- Example call:
  ```bash
  curl -i --location --request POST "https://qgzvkongdjqiiamzbbts.supabase.co/functions/v1/lifecyclemodel_hybrid_search" \
    --header 'Content-Type: application/json' \
    --header 'x-region: us-east-1' \
    --header "Authorization: Bearer $TOKEN" \
    --data @assets/example-request.json
  ```
- Model/SageMaker is configured in the deployed function; callers do not set extra env.

## Request & output
- POST `{ "query": string, "filter"?: object|string }`.
- 200 with `{ data }` from RPC or `[]`; 400 if query missing; 500 on embedding/RPC failures.

## Processing flow
1) CORS OPTIONS handled.
2) ChatOpenAI structured output with schema (semantic_query_en + fulltext_query_en/zh arrays) and lifecycle-model specific system prompt.
3) Embed `semantic_query_en` via SageMaker; build full-text OR string from English+Chinese lists.
4) Call `supabase.rpc('hybrid_search_lifecyclemodels', { query_text, query_embedding, filter_condition })` (non-string filters JSON.stringify).
5) Return results with CORS headers; log errors on failure.

## Change points
- Adjust structured schema or prompt for domain nuance (e.g., LCIA, system boundaries).
- Swap model/embedding endpoint; update `OPENAI_CHAT_MODEL` or SageMaker constants.
- Filter handling: ensure caller format matches RPC expectations.

## References
- `references/env.md` - env notes.
- `references/request-response.md` - payload, filter semantics, RPC details.
- `references/prompts.md` - prompt requirements for query generation.
- `references/testing.md` - curl & checklist.

## Assets
- `assets/example-request.json`