MCP server and Big Query Databaes

Hi everyone!
I’m using BigQuery to store all the data from an online e-commerce shop — including orders, purchased products, inventory, and customer information.

I’m now looking to set up an AI agent that can query these datasets so that our team can easily access insights directly from a Slack channel.

I’d love to hear from anyone who has built something similar — especially around how to connect the agent to the database.
Did you use a specific MCP setup, or rely on dedicated tools like the BigQuery modules in Make?

Thanks in advance for any feedback or examples you can share! :folded_hands: