test_get_id.py

import os
from supabase import create_client
from dotenv import load_dotenv

load_dotenv('/workspaces/govbridge/.env')
sb = create_client(os.getenv('SUPABASE_URL'), os.getenv('SUPABASE_KEY'))

res = sb.table('schemes').select('id, title, is_verified').limit(5).execute()
for r in res.data:
    print(f"{r['title']} -> ID: {r['id']} (Verified: {r['is_verified']})")