← Back

Documentation

About OCDB

OCDB is an open reference database for collectible trading cards. Card records are inferred from publicly observed listings and normalized over time.

All data is publicly readable and designed to be reusable by developers, sellers, and researchers. No authentication required.

Why OCDB?

  • Open by default — All card data is publicly readable. No accounts required. No scraping restrictions.
  • Programmatic access — Data can be queried directly via SQL-compatible APIs and batch exports.
  • Observed, not curated — Records are derived from repeated real-world listings rather than manual data entry.
  • Confidence-aware — Each record includes a confidence score based on agreement across observed data.
  • Infrastructure, not a marketplace — OCDB does not sell cards or provide pricing advice.

Querying the Database

OCDB is built on Supabase and can be queried directly via SQL or the Supabase client libraries. Public read access is available with no authentication required.

Connection Details

Supabase URL
https://xoheywavlyadnczmdzaf.supabase.co
Anon Key (Public)
eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6InhvaGV5d2F2bHlhZG5jem1kemFmIiwicm9sZSI6ImFub24iLCJpYXQiOjE3NjY3NzkyMjIsImV4cCI6MjA4MjM1NTIyMn0.MhnvwVJvyclQbCFBTpp1dZ7d3yLU5a-s6fHsGjC86K0
# Using Supabase JavaScript client
const supabase = createClient(
'https://xoheywavlyadnczmdzaf.supabase.co',
'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9...'
);
const { data } = await supabase
.from('cards')
.select('*')
.eq('sport', 'baseball')
.limit(10);

View Supabase API documentation →

Data Schema

cards

table
Core card records
id uuid
sport text
year integer
brand text
set_name text
card_number text
player text
confidence double precision
sightings integer
attributes jsonb
source_notes text
created_at timestamp
updated_at timestamp

card_images

table
Image URLs for cards
id uuid
card_id uuid → cards.id
image_url text
image_type text
source text
image_hash text
license text (default: CC-BY)
created_at timestamp

card_sightings

table
Observed listing data
id uuid
card_id uuid → cards.id
source text
external_id text
title text
price numeric
condition text
seen_at timestamp

Confidence Scores

Confidence reflects agreement across multiple observed listings and may change as new data is ingested. Higher scores indicate stronger consensus across observed sources.

Open Access

OCDB allows public read access, batch downloads, and programmatic use. Attribution and contributor licensing apply where relevant.