← All articles

MCP server — The totals are real

This is probably the part worth understanding first, because it is where most "AI on your data" integrations quietly fail. Ask a chatbot for the total value of your open deals and it will usually fetch a page of rows and add them up. If the filter matched 3,000 records and the page held 50, the number it hands you is confidently wrong, and nothing on screen says so. RowFold's MCP tools are the same tools its own Ask panel uses — not a thinner API written for outsiders. Aggregates are computed in Postgres, over every matching row. Filters can travel a relationship, so "deals whose company's region is EMEA" is one query rather than two round trips and an intersection done by hand. When a filter cannot be compiled, the result says which term was dropped and whether the answer is exact.
Nothing here answered it? Ask us directly — we usually reply within one working day.

Made with RowFold