BigQuery

BigQuery MCP Server provides a secure interface for LLMs to interact with Google BigQuery databases, enabling data exploration and SQL query execution. Built with TypeScript and the Bun runtime, it offers tools for executing read-only queries, listing tables, retrieving schema information, and estimating query costs. The implementation includes safeguards like query validation, configurable processing limits, and partition filter recommendations to prevent excessive costs. It supports both Application Default Credentials and service account authentication, making it ideal for data analysts and developers who need to give AI assistants access to structured data in BigQuery without compromising security.