PgRest Demo

A PostgREST and Supabase-compatible REST API powered by Elixir and Ecto.

Example Queries

Click a play button to execute the PgRest query, which uses the @supabase/postgrest-js client in your browser.

Filter	Ecto	Example
Equality	`==`	/api/tasks?status=eq.pending
Not equal	`!=`	/api/projects?status=neq.archived
Greater than or equal	`>=`	/api/projects?budget=gte.50000
Less than	`<`	/api/tasks?complexity=lt.3
Boolean (IS)	`==`	/api/projects?archived=is.false
Pattern match (ILIKE)	`ilike/2`	/api/projects?name=ilike.API
IN list	`in/2`	/api/tasks?status=in.(pending,in_progress)
Array contains	`fragment("@>")`	/api/tasks?tags=cs.{backend}
Ordering	`order_by/2`	/api/projects?order=budget.desc
Pagination	`limit/2, offset/2`	/api/tasks?limit=5&offset=0
Select fields	`select/3`	/api/projects?select=name,status,budget
Combined	`==, >=, order_by/2, limit/2`	/api/tasks?status=eq.pending&priority=eq.high&order=due_date.asc&limit=10
Embed (has_many)	`preload/2`	/api/projects?select=name,status,tasks(title,status,priority)
Embed (belongs_to)	`preload/2`	/api/tasks?select=title,status,project(name,status)
Inner join (!inner)	`join/5, where/3`	/api/tasks?select=title,priority,project!inner(name)&project.status=eq.active
Embed filter	`preload + where/3`	/api/projects?select=name,tasks(title,priority)&tasks.status=eq.pending
Embed ordering	`preload + order_by + limit`	/api/projects?select=name,tasks(title,priority)&tasks.order=priority.desc&tasks.limit=3
Custom search	`ilike/2`	/api/projects?search=Phoenix