u/Classic_Hall_9482

For context, I am using Claude with Notion connectors.

Hitting a wall trying to run agents over Notion databases via the official MCP. The main retrieval primitive it exposes is semantic search, which works ok for loose lookups but falls apart once queries get even mildly structured – filter-by-property, "find rows where status = X and date > Y," exact matches on titles, etc. Results are inconsistent run-to-run and frequently miss obvious hits.

Anyone landed on potential workarounds? Would appreciate any tips.

For context, I am using Claude with Notion connectors.

Hitting a wall trying to run agents over Notion databases via the official MCP. The main retrieval primitive it exposes is semantic search, which works ok for loose lookups but falls apart once queries get even mildly structured – filter-by-property, "find rows where status = X and date > Y," exact matches on titles, etc. Results are inconsistent run-to-run and frequently miss obvious hits.

Anyone landed on potential workarounds? Would appreciate any tips.

EDIT: I fully agree that semantic search is a wrong tool here - no debate here. I am particularly curious about workarounds.