Supabase Auth

sb_list_records

List records from a Supabase table/view with PostgREST filtering, column selection, ordering, and pagination. Filter syntax: age=gt.18, status=eq.active, name=ilike.*john*, id=in.(1,2,3). Resource embedding (JOINs): select=*,orders(*)

Remote node2flow/supabase

Other tools also called sb_list_records? See providers with this name

Input Schema


            {
  "type": "object",
  "properties": {
    "limit": {
      "type": "number",
      "description": "Maximum number of records to return"
    },
    "order": {
      "type": "string",
      "description": "Sort order. Example: created_at.desc or name.asc.nullslast"
    },
    "table": {
      "type": "string",
      "description": "Table or view name"
    },
    "filter": {
      "type": "string",
      "description": "PostgREST filter string. Example: age=gt.18&status=eq.active&or=(role.eq.admin,role.eq.mod)"
    },
    "offset": {
      "type": "number",
      "description": "Number of records to skip (for pagination)"
    },
    "select": {
      "type": "string",
      "description": "Columns to return. Supports embedding: *,orders(*) or id,user:user_id(name,email)"
    },
    "_fields": {
      "type": "string",
      "description": "Comma-separated list of fields to include in the response (Smithery quality param)"
    }
  }
}