Guides
Intermediate
Full-Text Search
PostgreSQL-powered full-text search for collection entries with stemming support
Overview
Airogel CMS includes PostgreSQL full-text search optimized for content discovery with automatic stemming and relevance ranking.
What Gets Indexed
Each entry's searchable content includes:
- Title - Entry title (highest weight)
- Handle - URL slug
- Text fields - All text field values
- Rich text fields - All rich text values (HTML stripped)
Using Search
Search is available via the MCP search.query tool with parameters for query text, collection filtering, and pagination.
Features
- Automatic stemming ("programming" matches "program")
- Multi-word queries (AND logic)
- Relevance ranking
- Sub-millisecond performance with GIN indexes