---
title: "Can You Run Hybrid Search on One Database? Yes! Here's How CrateDB Does It"
url: https://daily.dev/posts/can-you-run-hybrid-search-on-one-database-yes-here-s-how-cratedb-does-it-eeizjqb8w
source_url: https://cratedb.com/blog/can-you-run-hybrid-search-on-one-database-yes-heres-how-cratedb-does-it
type: article
source: "CrateDB"
published: 2026-08-03T09:59:07.768Z
updated: 2026-08-03T09:59:33.565Z
tags: ["mcp", "rag", "vector-search", "cratedb"]
reading_time: 11
upvotes: 0
comments: 0
language: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# Can You Run Hybrid Search on One Database? Yes! Here's How CrateDB Does It

**[CrateDB](https://daily.dev/sources/cratedb)** · 11 min read · 0 upvotes · 0 comments

## Summary

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.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://cratedb.com/blog/can-you-run-hybrid-search-on-one-database-yes-heres-how-cratedb-does-it>

## Similar posts on daily.dev

- [Inside CrateDB’s Real-Time Query Engine: Aggregations, Ad-Hoc Queries, Hybrid Search, and AI](https://daily.dev/posts/inside-cratedb-s-real-time-query-engine-aggregations-ad-hoc-queries-hybrid-search-and-ai-sl7jvqmbr) · CrateDB · 1 upvotes · 0 comments
- [The Two Hybrid Searches in Microsoft SQL](https://daily.dev/posts/the-two-hybrid-searches-in-microsoft-sql-hhfmi7plf) · DevBlogs · 0 upvotes · 0 comments

---

Tags: [#mcp](https://daily.dev/tags/mcp), [#rag](https://daily.dev/tags/rag), [#vector-search](https://daily.dev/tags/vector-search), [#cratedb](https://daily.dev/tags/cratedb)

[View this post on daily.dev](https://daily.dev/posts/can-you-run-hybrid-search-on-one-database-yes-here-s-how-cratedb-does-it-eeizjqb8w)