Can You Run Hybrid Search on One Database? Yes! Here's How CrateDB Does It
This title could be clearer and more informative.Try out Clickbait Shieldfor free (5 uses left this month).
CrateDB supports combining geospatial, full-text (BM25), and vector (KNN) searches within a single database, eliminating the need for multiple specialized data stores. The post walks through concrete SQL examples using a German regions dataset: a WITHIN() geospatial query, a MATCH() full-text query, and a combined query finding wine-region towns near Stuttgart. It also demonstrates using CrateDB as a backend for an MCP server connected to Claude, enabling natural-language queries over weather and regional data. The MCP section highlights how prompt engineering and schema instructions significantly affect query quality and correctness, including polygon-filtering to avoid near-border foreign locations.
