Couchbase
Read post

When Column Names Lie: Bringing External Catalogs to NL2SQL++

Hardcoding schema into NL2SQL prompts fails when column names are opaque, misleading, or near-duplicate — a common reality in enterprise data. This project connects external data catalogs (DataHub, OpenMetadata) to Couchbase so that column descriptions, not just names, inform SQL++ generation. Column descriptions are embedded as 384-dimension vectors and stored in Couchbase; at query time, vector search retrieves semantically relevant columns, which are then passed to a Claude model on AWS Bedrock to generate correct SQL++. A pluggable provider pattern means switching catalogs is a config change. Two concrete examples show how schema-only approaches silently return wrong results — correct SQL that filters on invented string values or picks the wrong near-duplicate column — while catalog-enhanced queries get the right answer because the encoding or tolerance clause is in the description.

    #llm#vector-search#couchbase
Aug 03•9m read time•From couchbase.com
Post cover image
Table of contents
The ProblemThe Big Idea: One Interface, Any Catalog
63 Impressions
Couchbase's image
Couchbase

Couchbase provides insights into NoSQL database technology, distributed systems, and cloud-native ar...

78 Followers

•

257 Upvotes

Would you recommend this post?

Copy link
WhatsApp
Facebook
X
New Squad
  • © 2026 Daily Dev Ltd.
  • Guidelines
  • Explore
  • Tags
  • Sources
  • Squads
  • Leaderboard