Public API & Schema

This site documents the public Supabase REST API and the underlying Prisma schema used by GaiaLabs. All endpoints are powered by PostgREST with Row Level Security.

Base URL

https://adwobxutnpmjbmhdxrzx.supabase.co/rest/v1

Authentication

Use the publishable anon key in both apikey and Authorization headers.

curl "https://adwobxutnpmjbmhdxrzx.supabase.co/rest/v1/Project" \
  -H "apikey: sb_publishable_uBZdKmgGql5sDNGpj1DVMQ_opZ2V4kV" \
  -H "Authorization: Bearer sb_publishable_uBZdKmgGql5sDNGpj1DVMQ_opZ2V4kV"

Open Example Response

Schema Models

Generated from the canonical Prisma schema at build-time.

Platform

View

Field	Type	Attributes
id	String	@id
name	String	@unique
meta	Json?
createdAt	DateTime
updatedAt	DateTime	@updatedAt
branches	PlatformBranch[]

PlatformBranch

View

Field	Type	Attributes
id	String	@id
name	String?
version	Int?
isActive	Boolean?
notes	String[]
platform	Platform	@relation

Developer

View

Field	Type	Attributes
id	String	@id
name	String
meta	Json?
platform	Platform	@relation
platformId	String
games	Game[]

Region

View

Field	Type	Attributes
id	String	@id
name	String
meta	Json?
platform	Platform	@relation
platformId	String
createdAt	DateTime

Game

View

Field	Type	Attributes
id	String	@id
name	String
meta	Json?
platform	Platform	@relation
platformId	String
developer	Developer?	@relation

GameRom

View

Field	Type	Attributes
id	String	@id
crc	Int	@unique
meta	Json?
game	Game	@relation
gameId	String
region	Region?	@relation

GameRomBranch

View

Field	Type	Attributes
id	String	@id
name	String?
version	Int?
isActive	Boolean?
notes	String[]
gameRom	GameRom	@relation

BaseRom

View

Field	Type	Attributes
id	String	@id
name	String	@unique
game	Game	@relation
gameId	String
gameRom	GameRom	@relation
gameRomId	String

BaseRomBranch

View

Field	Type	Attributes
id	String	@id
name	String?
version	Int?
isActive	Boolean?
notes	String[]
baseRom	BaseRom	@relation

BaseRomFile

View

Field	Type	Attributes
id	String	@id
name	String
type	String
version	Int?
crc	Int?
meta	Json?

Project

View

Field	Type	Attributes
id	String	@id
name	String	@unique
meta	Json?
game	Game	@relation
gameId	String
baseRom	BaseRom	@relation

ProjectBranch

View

Field	Type	Attributes
id	String	@id
name	String?
version	Int?
isActive	Boolean?
notes	String[]
project	Project	@relation

ProjectFile

View

Field	Type	Attributes
id	String	@id
name	String
type	String
module	String?
version	Int?
crc	Int?

Filtering & Embedding

Endpoints support PostgREST filtering (e.g. ?select=*,Game(*), ?name=eq.Illusion%20of%20Gaia%3A%20Retranslated), ordering (&order=updatedAt.desc), and pagination (&limit=20&offset=0).

curl "https://adwobxutnpmjbmhdxrzx.supabase.co/rest/v1/Project?select=*&order=updatedAt.desc" \
  -H "apikey: sb_publishable_uBZdKmgGql5sDNGpj1DVMQ_opZ2V4kV" \
  -H "Authorization: Bearer sb_publishable_uBZdKmgGql5sDNGpj1DVMQ_opZ2V4kV"