# Search data

Part of **Supabase**. Route queries via `POST https://www.company-skill.com/api/route`.

## What You Want to Do

** (Typical User Questions)**:

- How to search strings in Supabase tables?
- Can I filter records by contained values?

## Decision Tree

- **** `textSearch``match` PostgreSQL `rpc` → ** JavaScript SDK CRUD ** ( [*supabase/supabase-search*](skills/supabase/api/supabase-search/SKILL.md))
- **** GUI SQL **SQL Editor** **Run** → ** Supabase ** ( [*supabase/supabase-database*](skills/supabase/guide/supabase-database/SKILL.md))

## Path Comparison

| (Path) | (Best For) | (Complexity) | (Code Required) | (Automation) | (Key Fact) | Skill |
|------------|---------------------|---------------------|---------------------------|------------------------|---------------------|-----------|
| JavaScript SDK CRUD | | medium | Yes | Yes | `tsvector` `apikey` header Supabase anon key | `supabase/api/supabase-search` |
| Supabase | | low | No | No | 1000 `max_rows` **Results tab** | `supabase/guide/supabase-database` |

## Path Details

### 1: JavaScript SDK CRUD 

** (Brief Description)**: Supabase JavaScript SDK API CRUD FTSPLFTS pgvector PostgreSQL `textSearch``match``rpc` `FullTextSearchConfig` 

** (Key Facts)**:
- (Auth): `apikey` header with Supabase anon key

** (When to Use)**:
- PostgreSQL RPC

** (When NOT to Use)**:

** (Known Limitations)**:
- JavaScript/TypeScript UI 

**→ (Detailed Steps)**: See *supabase/supabase-search*

** (Brief Description)**: Supabase Web **SQL Editor** GUI SQL PostgREST API `LIMIT` `OFFSET` **Results tab** **Project Settings > API Keys** `anon key`

** (Key Facts)**:
- (Auth): Supabase SSO 

** (When to Use)**:
- API PostgREST `NOTIFY pgrst, 'reload schema'`

** (When NOT to Use)**:

** (Known Limitations)**:
- PostgREST `NOTIFY pgrst, 'reload schema'` 

**→ (Detailed Steps)**: See *supabase/supabase-database*

## Related queries

how to search strings in Supabase, Supabase full text search, filter records by value, Supabase CRUD, interactive SQL Supabase, Supabase textSearch, match API, rpc call, FullTextSearchConfig, tsvector column, anon key, apikey header, SQL Editor, Run query, NOTIFY pgrst reload schema, Project Setting

---
Part of [Supabase](https://www.company-skill.com/p/supabase.md) · https://www.company-skill.com/llms.txt