Select Single Row
@vibecode-db/client
v3
Playground & Docs
Getting Started
3
Introduction
Installation
Creating a Client
Adapters
4
Mock Adapter
Supabase Adapter
PocketBase Adapter
REST Adapter
CRUD
9
Select All Rows
Select Specific Columns
Select Single Row
Select Maybe Single
Insert a Row
Insert Multiple Rows
Update Rows
Upsert a Row
Delete Rows
Filters
10
Equal (eq)
Not Equal (neq)
Pattern Match (like)
Case-Insensitive Match (ilike)
In Array (in)
Is Null
OR Filter
Negated Filter (not)
Match Multiple (match)
Greater Than / Less Than
Transforms
5
Order Ascending
Order Descending
Limit Results
Range (Pagination)
Combined Query
Auth
4
Sign Up
Sign In
Get Session
Sign Out
Storage
4
Create & List Buckets
Upload & Download
List Files
Get Public URL
Realtime
2
Listen for Inserts
Listen for All Changes
RPC
2
Call RPC Function
RPC with String Result
Relational
6
One-to-Many
Many-to-One
Nested Relations
Relations + Filter
Deep Nesting (3 levels)
Comments with Task & User
Sample Expo App
4
Overview
Folder Structure
Architecture
Switching Adapters
Select Single Row
mock
Fetch a single row by email.
Adapter:
Mock
Supabase
PocketBase
REST
Ready
Code
Run
const { data, error } = await client .from('users') .select('*') .eq('email', 'alice@test.com') .single(); return { data, error };
Press
Cmd+Enter
to run
Result
Click Run to execute the query