Three Postgres backends. $10 a month.

Save as auto-embed.sh and run: bash auto-embed.sh. Requires Bash and cURL 7.76+.

#!/usr/bin/env bash
set -euo pipefail
: "${PROJECT_URL:?Set PROJECT_URL to your project API URL}"
: "${API_KEY:?Set API_KEY to your server-side secret key}"
export PROJECT_URL="${PROJECT_URL%/}"

# Create the table once (skip this step if it already exists)
curl --fail-with-body -X POST "$PROJECT_URL/schema" \
  -H "apikey: $API_KEY" \
  -H "content-type: application/json" \
  -d '{
  "kind": "create_table",
  "name": "help_articles",
  "columns": [
    {
      "name": "id",
      "type": "integer",
      "primaryKey": true
    },
    {
      "name": "title",
      "type": "text",
      "nullable": false
    },
    {
      "name": "category",
      "type": "text",
      "nullable": false
    },
    {
      "name": "published",
      "type": "boolean",
      "default": "false"
    },
    {
      "name": "content",
      "type": "text",
      "nullable": false
    },
    {
      "name": "embedding",
      "type": "vector(768)",
      "nullable": false
    }
  ]
}'
printf '\n'

# Send text; starterpg automatically generates and stores embeddings
curl --fail-with-body -X POST "$PROJECT_URL/rest/help_articles?embed=true&on_conflict=id" \
  -H "apikey: $API_KEY" \
  -H "Prefer: resolution=merge-duplicates,return=minimal" \
  -H "content-type: application/json" \
  -d '[
  {
    "id": 1,
    "title": "Reset your password",
    "category": "account",
    "published": true,
    "content": "Use Forgot password on the login page to receive a reset link by email."
  },
  {
    "id": 2,
    "title": "Change your plan",
    "category": "billing",
    "published": true,
    "content": "Open Billing in your dashboard to upgrade your subscription or change your plan."
  },
  {
    "id": 3,
    "title": "Invite a teammate",
    "category": "account",
    "published": false,
    "content": "Open your team settings and send an invitation to a colleague by email."
  }
]'
printf '\n'

# Search with a sentence; starterpg also embeds the query
curl --fail-with-body -X POST "$PROJECT_URL/vector/help_articles?embed=true" \
  -H "apikey: $API_KEY" \
  -H "content-type: application/json" \
  -d '{
  "text": "I cannot sign in because I forgot my password",
  "column": "embedding",
  "metric": "cosine",
  "select": "id,title,content",
  "limit": 3
}'
printf '\n'

# Search only published articles in the account category
curl --fail-with-body -X POST "$PROJECT_URL/vector/help_articles?embed=true" \
  -H "apikey: $API_KEY" \
  -H "content-type: application/json" \
  -d '{
  "text": "I cannot sign in because I forgot my password",
  "column": "embedding",
  "metric": "cosine",
  "select": "id,title,content",
  "limit": 3,
  "filters": {
    "category": "eq.account",
    "published": "eq.true"
  }
}'
printf '\n'

# Update text and automatically regenerate its embedding
curl --fail-with-body -X PATCH "$PROJECT_URL/rest/help_articles?id=eq.1&embed=true" \
  -H "apikey: $API_KEY" \
  -H "Prefer: return=minimal" \
  -H "content-type: application/json" \
  -d '{
  "content": "Choose Forgot password on the login page. Open the emailed reset link and choose a new password."
}'
printf '\n'

# Search again using the updated content
curl --fail-with-body -X POST "$PROJECT_URL/vector/help_articles?embed=true" \
  -H "apikey: $API_KEY" \
  -H "content-type: application/json" \
  -d '{
  "text": "I cannot sign in because I forgot my password",
  "column": "embedding",
  "metric": "cosine",
  "select": "id,title,content",
  "limit": 3
}'
printf '\n'