Is traceability enough when AI answers questions about open data?

Hi everyone,

We’ve published a blog post with early lessons from our pilots with Brazil and Uruguay, where we are prototyping an MCP bridge between open data portals and AI.

The main reflection from the work so far is that connecting an AI assistant to the data is quite straightforward. The harder part is making sure the system understands enough about the data to answer responsibly: what the fields mean, what units are used, what time period is covered, what assumptions should not be made, and where the limits of the dataset are.

This raised a few questions for us that we’d be interested to discuss:

  • What kind of metadata or documentation is most useful when open data is accessed through an AI interface?
  • How should we describe the limits of a dataset so that an AI system does not overstate what the data can support?
  • What role should domain experts play when preparing datasets for AI-based access?
  • Is traceability enough to build trust, or do we need additional forms of review and validation?
  • How should we test these systems: with generic benchmarks, real user questions, domain-expert review, or something else?

We are still early in this work, and the next step is user testing. We’d really welcome thoughts, examples, or related experiences from others working on similar projects.

3 Likes

Hi Kannika,

Thank you for sharing these reflections. The questions you have raised resonate deeply with our own experience at Open Knowledge Nepal, where we recently launched AI integration on Open Data Nepal (https://opendatanepal.com), our civil society-led open data repository for Nepal.

We would like to share a few early learnings that speak directly to the questions you have raised.

On metadata and documentation for AI interfaces
In our experience, metadata is not only important for data discovery but also for data interpretation, including insight generation and aggregation. However, how useful it is depends heavily on how you implement the system. We used SQL queries so that all computation happens at the database layer, and the AI generates insights based on those query results rather than interpreting raw data directly. This gave us much more reliable and accurate outputs.

On what kind of metadata is most useful: we believe a dataset should have a clear, descriptive title and a plain-language description covering what it is about, what it contains, its source, and relevant context. Beyond that overview, a detailed schema is valuable. The resource should specify what tables it includes and, for each field, what the column represents, its data type (text, number, date, etc.), the units of measurement, and any codes or abbreviations used. This kind of structured information helps an AI understand and interpret the data more accurately.

Open Data Nepal’s CKAN API exposes exactly this through its resource_show endpoint, which returns a resource’s title along with its field-level schema, giving an AI the structured context it needs to read the data correctly.

On describing the limits of a dataset so that AI does not overstate what the data can support
We were also concerned about misuse of the AI feature, for instance, scripted or automated querying, or prompts entirely unrelated to the portal’s data, which can drive up costs unpredictably. To address this, we introduced two safeguards.

First, guardrails restrict the AI to questions about datasets hosted on the portal, so it does not respond to off-topic or out-of-scope prompts. This keeps the feature focused on its intended purpose and prevents it from functioning as a general-purpose chatbot.

Second, we introduced rate limits to prevent excessive use. Each user can ask up to 20 questions per day and make no more than 6 requests within a 5-minute window. These limits curb automated or abusive access patterns while still leaving genuine users ample room to explore the data. Together, these measures keep usage within intended bounds and make operating costs predictable.

On traceability and trust
Traceability was a design principle from the start for us. Every response the assistant generates is grounded in the actual datasets on the portal, not generic internet sources. But we have found that traceability alone is necessary but not sufficient for trust, especially among our primary users, who are not data specialists. Trust is built through familiarity and repeated accurate responses, not through understanding the technical architecture. This suggests that domain-expert review during the dataset preparation phase, not just at the point of AI output, is important.

On testing
We are still in early days on this, but our instinct is that real user questions are the most valuable testing input, precisely because they surface assumptions the system makes that no generic benchmark would catch.

Looking forward to following this thread and learning!

4 Likes

Thank you, Nikesh, for this thoughtful response – it’s really helpful to hear how you’ve approached these same questions in practice.

Your points about metadata are especially useful. The idea of having clear, plain-language descriptions and field-level detail makes a lot of sense, and it’s encouraging to hear that this approach has given you more reliable outputs. The guardrails and rate-limiting you described are also very interesting – it’s something we know we’ll need to think about as the work grows.

What you said about trust really resonated with me: that for many users, trust comes through repeated accurate answers and familiarity, not just through technical traceability. I’d love to hear a bit more about how domain experts are involved in your dataset preparation phase, if you’re able to share.

Thanks again for sharing these learnings – it feels like we’re working on very similar challenges. I’ll be following your work on Open Data Nepal.

2 Likes

Sharing some insights from the Urban Institute here in the U.S. - They have been experimenting with how well LLM’s are able to answer questions using public data. They call for more testing, investments in AI discoverability (like MCP servers), and enhanced metadata and documentation. We’re starting to work on this here in Pittsburgh.

2 Likes

We had the same findings last September @Kannika when we built an Open Data Chatbot for CKAN last year.

https://dathere.com/2025/09/democratizing-data-access-introducing-datheres-ai-chatbot-and-ai-ready-data-solutions/

“How do I know I can trust the answer?” was the first question we’d normally get. That’s why we built the Data Concierge - where instead of answering questions directly, we prompt the AI to write a Python notebook instead.

And thanks to the step change in Agentic Coding last November with the introduction of Claude Code and Opus 4.5, the results have been encouraging - the Draft Answers are reproducible, traceable and deterministic - as we gave the model detailed guidance about the CKAN API AND we enriched and FAIRified the data first.

Further, we built a Verifiable Question Answering Harness that incorporated a GitHub based approval workflow to ensure that the Answers the Data Concierge provides always has multiple Verifiers-in-the-Loop:

  • Built-in deterministic confidence heuristic so the AI scores its own confidence in its Draft Answer
  • An Adversarial Review Agent, using another model, that reviews and grades the Draft Answer
  • GitHub-based workflows for approvals using familiar GitHub mechanisms - code reviews, issues, pull requests, etc. so Agents and Humans can work together in traceably refining the Draft Answer till its approved and becomes a Verified Answer.
  • And finally - Independent, third-party verification of AI-generated answers with TypedStandards.org - which provides a cryptographically-signed way for someone else to confirm the answer is reproducible and verifiable from its inputs, but it doesn’t attest to whether a specific answer is correct. Standardized provenance and reproducibility of AI output provide a baseline for others to independently evaluate trustworthiness based on their own criteria.

Also, we made the conscious decision to make it an INTERNAL TOOL - primarily, to help internal staff, so there’s no fear of providing wrong answers to external parties; to get their use cases; and to secure their confidence and trusts in the solution the only way we know how - by earning it the hard way over time.

The Data Concierge just provides the scaffolding to make it a little easier in a reproducible way.

We hope to share more about our experiments soon. We’re very lucky to have partners in Western Pennsylvania - WPRDC, Allegheny county, and the City of Pittsburgh with whom we’re #BuildingWithNotFor the Data Concierge.

2 Likes

Thank you @rgradeck & @jqnatividad for sharing your experiences and insights.

@rgradeck – I particularly enjoyed the Urban Institute’s findings – the angle on AI discoverability really resonated with what we observed during our own pilots.

@jqnatividad – Your progress on the Verifiable Question Answering Harness approach is very exciting; I look forward to following your developments closely.

On our side, we’ve just wrapped up the testing phase and are currently deep in the evaluation process. Given the momentum across the community – including the great work from you, @nikeshbalami @rgradeck and @jqnatividad – I would love to reignite our collaborative dialogue by hosting another Community Conversation Session, similar to the one we held back in March. This will be a great opportunity to dive into the details together. Please stay tuned for more information!

1 Like