Keyword search
Find documents that contain the words in your query.
DATABASE / FULL TEXT SEARCHWhen the words matter,
When the words matter,
find them.
Use full-text search to retrieve records containing the terms and phrases your agents or users are looking for.
SEARCH PHRASE
“laptop sleeve”
PRODUCT_CATALOG / 001
Everyday backpack
A compact bag with a padded laptop sleeve, weather-resistant fabric, and room for daily essentials.
Illustrative phrase match
Phrase search
Look for a specific sequence of words, such as a product feature or document title.
A precise retrieval option
Use full-text retrieval when the wording itself is a useful signal.
From a phrase
to the right record.
Index searchable text
Make the text in your documents available for full-text retrieval.
Enter the terms
Search for a name, keyword, or phrase that matters to the task.
Use the matching context
Return the matching records to an agent with access or to your app.
FTS5 is SQLite’s full-text search extension. Read the FTS5 reference ↗