How to embed structured data

[tacman]

Is there a way to embed structured data? I have a list of products that have a sku, price, category title and description.

I create a text documents and embed them:

SKU {{ sku }} is {{ title }} and can be described as {{ description }}. It's price is {{ price }} and is in the {{ category }} category.

then I can say

"what are our three cheapest products?"

This works perfectly, but it feels a bit odd. Can I send in key/value pairs in JSON or YAML? In particular, the SKU is unique and I want the system to know that.

Thoughts? I'm new to this, but obsessed. Thanks.

[ilvalerione]

Hi @tacman, structured data is not the use case of the vector database I think. You should implement tools to make the agent able to query your database directly. Or use an MCP server to makes your agent able to gather information from a SQL or whatever DB.

[tacman]

Thanks. I'm sure there are solution for stuff like this in python, it's a matter now for learning them to create tools and agents in php.

Like giving the agent the database schema and asking it to return a query.

[tacman]

I found meilisearch's guidance enlighting:

https://www.meilisearch.com/docs/learn/ai_powered_search/getting_started_with_ai_search

The embed liquid, a templating engine, and recommend expanding the record to read like natural language text.

I do think the better solution to to turn it into a query, but the embedding idea is interesting too.