mcp-server-bigquery
If you are the rightful owner of mcp-server-bigquery and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
A Model Context Protocol server that provides access to BigQuery, enabling LLMs to inspect database schemas and execute queries.
The BigQuery MCP server is designed to facilitate seamless interaction between language models and Google's BigQuery database. It allows language models to perform operations such as inspecting database schemas and executing SQL queries using the BigQuery dialect. This server is particularly useful for applications that require dynamic data retrieval and manipulation from large datasets stored in BigQuery. The server can be configured using command line arguments or environment variables, making it flexible and adaptable to various deployment environments. It supports multiple datasets and can be integrated with different platforms, including Claude Desktop, through simple configuration scripts. The server also provides tools for listing tables and describing table schemas, which are essential for understanding the structure of the data being queried. Additionally, the server supports development and debugging processes with tools like the MCP Inspector, ensuring that developers can efficiently build and troubleshoot their applications.
Features
- Execute SQL queries using BigQuery dialect
- List all tables in the BigQuery database
- Describe the schema of specific tables
- Configurable via command line or environment variables
- Supports multiple datasets and integration with various platforms
Tools
execute-query
Executes a SQL query using BigQuery dialect
list-tables
Lists all tables in the BigQuery database
describe-table
Describes the schema of a specific table
