fafa-ai-data-lab/ai-data-analyst-agent

This repository is a methodology and template kit for turning an AI coding agent, such as Claude Code or Cursor, into something that behaves like a careful, trustworthy data analyst rather than a chatbot that just answers questions from memory. It does not contain any real company data, table names, or business specific metric definitions. Instead, it shares the underlying structure that makes an AI data analyst dependable, and expects each team to fill in their own data and rules using the provided templates. The approach centers on four ideas. First, metric definitions come before any calculation: the agent is expected to look up a single authoritative definition of a metric from a shared registry rather than inventing one on the fly from conversation context. Second, an agent should never be the sole judge of its own work, because self checking is unreliable, so any SQL query or report the agent produces must be reviewed by a separate validator agent that only has read access and cannot make changes itself. Third, the project keeps a rule library that grows over time: whenever a mistake is corrected, a new numbered rule gets added so the same mistake is automatically caught the next time, and the validator is expected to flag situations its current rules do not yet cover. Fourth, every number delivered to a person should carry a short note explaining where its definition came from, how fresh the underlying data is, which source table it used, and who validated it. The repository includes a template for the agent's persona and instructions, a ready to use validator skill with a set of general purpose rules covering things like sanity checks on SQL results and A/B test methodology, a template for adding your own business specific rules, and guidance for setting up a metric registry. It deliberately leaves out real table names, real metric definitions, and specific past mistakes, since those are considered private to each organization. It is released under the MIT license, so it can be used, changed, and sold freely, with no warranty from the author.