crud-otagent-supabase

Query, aggregate, and safely write OT-Agent eval data in Supabase.

276|37|Updated Dec 5, 2025
One-click install
npx skills add https://github.com/open-thoughts/OpenThoughts-Agent --skill crud-otagent-supabase
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: crud-otagent-supabase
Source: https://github.com/open-thoughts/OpenThoughts-Agent/tree/main/.claude/skills/crud-otagent-supabase
Command: npx skills add https://github.com/open-thoughts/OpenThoughts-Agent --skill crud-otagent-supabase

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires supabase.

What problem does it solve?

The OT-Agent Supabase is the source of truth for model eval results (the numbers behind every ablation/paper table). The scores live in sandbox_jobs; this skill teaches how to query them correctly, aggregate ID/OOD means (and their binomial SE) the way the tables do, and write rows safely.

Core Features & Use Cases

  • Query and reconcile model IDs, benchmarks, and evaluation results from sandbox_jobs, models, and benchmarks.
  • Aggregate across multiple entries per model/benchmark, enforce identical-setting averaging, and handle sibling model rows.
  • Register new models and evaluations, repair failed uploads, and maintain FK safety with cross-user checks.

Quick Start

Connect locally using your secret environment variables and run the provided scripts to register models and evaluations.

Frequently Asked Questions about crud-otagent-supabase

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query and aggregate OT-Agent evaluation data in Supabase?

To query and aggregate OT-Agent evaluation data in Supabase, you access the sandbox_jobs, models, and benchmarks schemas. You can aggregate ID/OOD means and binomial SE using canonical rules for multiple entries per model.

What is the best way to register new models and evaluation jobs in a Supabase registry?

The best way to register new models and eval jobs is by running provided scripts connected via local secrets. This safely writes rows to the registry and maintains cross-user foreign key safety.

How does Supabase handle data integrity for cross-user model evaluations?

Supabase handles data integrity for cross-user model evaluations by enforcing cross-user foreign key safety checks. This ensures relationships between models, benchmarks, and sandbox_jobs remain consistent across different users.

Can I repair failed uploads for model benchmark results in Supabase?

Yes, you can repair failed uploads for model benchmark results in Supabase. The skill provides scripts to reconcile and safely write rows, fixing failed uploads while maintaining database integrity.

How do I identify ID and OOD benchmarks when querying model evaluation results?

You identify ID and OOD benchmarks by querying the benchmarks schema within Supabase. The skill supports identifying these benchmark types to correctly aggregate their means and binomial standard errors.

Do I need local secrets to access the Supabase evaluation database?

Yes, you need local secrets to access the Supabase evaluation database. Connecting locally using your secret environment variables is required to run the scripts for querying and registering data.