Skip to main content

Basic Query Builder

Location: Sidebar → Query Builder

The Query Builder lets you construct and run Supabase database queries through a visual form — no code required. The query builder allows you to easily create queries and displays the Javascript required to run the query. This can be useful for you to test your queries and then deploy them into your code.

The Basic Query builder is excellent for quickly creating simple CRUD style queries, whereas, the Advanced Query builder is designed for you to go deep on build advanced queries that might include nested tables, etc.

Building a Query​

  1. Select a table from the dropdown. Supatester loads its columns from the schema automatically.
  2. Choose an operation: SELECT, INSERT, UPDATE, or DELETE.
  3. Configure the operation:
    • SELECT — choose which columns to return, add filters, set ordering and row limits.
    • INSERT — select columns and enter values for each.
    • UPDATE — choose which columns to update, set new values, and add filters to target specific rows.
    • DELETE — add filters to target the rows to delete. A confirmation step is shown before execution.
  4. Select an auth context using the context selector at the top.
  5. Click Run to execute.

Filters​

Add filters using the Add Filter button. Each filter has three parts:

  • Column — the column to filter on.
  • Operator — one of 18+ operators: eq, neq, gt, gte, lt, lte, like, ilike, is, in, contains, containedBy, overlaps, textSearch, match, not, or, or a raw PostgREST filter.
  • Value — the value to compare against. Supports {{variable}} syntax for dynamic values.

Code Preview​

Every query you configure generates a live code preview showing the exact supabase-js code that will be executed. Use this to learn the API or copy the snippet directly into your application.

Saving to a Collection​

Click Save to Collection to store the current request in a collection folder for later reuse in test plans or as a quick reference.