backend/inspect_columns.py

import asyncio
import os
from supabase import create_client
from dotenv import load_dotenv

load_dotenv()

SUPABASE_URL = os.environ.get("SUPABASE_URL")
SUPABASE_KEY = os.environ.get("SUPABASE_SERVICE_ROLE_KEY") or os.environ.get("SUPABASE_KEY")
client = create_client(SUPABASE_URL, SUPABASE_KEY)

async def inspect():
    print("--- Profile Embeddings Columns ---")
    p_res = client.table("profile_embeddings").select("*").limit(1).execute()
    if p_res.data:
        for k in sorted(p_res.data[0].keys()):
            print(f"  - {k}")
    else:
        print("No profile embeddings found")

    print("\n--- Job Embeddings Columns ---")
    j_res = client.table("job_embeddings").select("*").limit(1).execute()
    if j_res.data:
        for k in sorted(j_res.data[0].keys()):
            print(f"  - {k}")
    else:
        print("No job embeddings found")

if __name__ == "__main__":
    asyncio.run(inspect())