Modeling Google Analytics data with OpenAI Codex and Four MCP servers
Teaching AI to build data models and verify its work
By plugging AI agents directly into our infrastructure, I gave them the ability to explore database schemas, read documentation, run tests, and verify results against live APIs — turning what is usually a manual, error-prone verification process into a single command. For the examples in this blog, I used Codex from OpenAI to connect to MCP servers from Omni’s, BigQuery, Context7, and Google Analytics.
