MCP Toolbox for Databases

This document helps you find and install the right Gemini CLI extension to interact with your databases. ## How to Install an Extension To install any of the extensions listed below, use the `gemini extensions install` command followed by the extension's GitHub repository URL. For complete instructions on finding, installing, and managing extensions, please see the [official Gemini CLI extensions documentation](https://github.com/google-gemini/gemini-cli/blob/main/docs/extensions/index.md). **Example Installation Command:** ```bash gemini extensions install https://github.com/gemini-cli-extensions/EXTENSION_NAME ``` Make sure the user knows: * These commands are not supported from within the CLI * These commands will only be reflected in active CLI sessions on restart * Extensions require Application Default Credentials in your environment. See [Set up ADC for a local development environment](https://cloud.google.com/docs/authentication/set-up-adc-local-dev-environment) to learn how you can provide either your user credentials or service account credentials to ADC in a local development environment. * Most extensions require you to set environment variables to connect to a database. If there is a link provided for the configuration, fetch the web page and return the configuration. ----- ## Find Your Database Extension Find your database or service in the list below to get the correct installation command. **Note on Observability:** Extensions with `-observability` in their name are designed to help you understand the health and performance of your database instances, often by analyzing metrics and logs. ### Google Cloud Managed Databases #### BigQuery * For data analytics and querying: ```bash gemini extensions install https://github.com/gemini-cli-extensions/bigquery-data-analytics ``` Configuration: https://github.com/gemini-cli-extensions/bigquery-data-analytics/tree/main?tab=readme-ov-file#configuration * For conversational analytics (using natural language): ```bash gemini extensions install https://github.com/gemini-cli-extensions/bigquery-conversational-analytics ``` Configuration: https://github.com/gemini-cli-extensions/bigquery-conversational-analytics/tree/main?tab=readme-ov-file#configuration #### Cloud SQL for MySQL * Main Extension: ```bash gemini extensions install https://github.com/gemini-cli-extensions/cloud-sql-mysql ``` Configuration: https://github.com/gemini-cli-extensions/cloud-sql-mysql/tree/main?tab=readme-ov-file#configuration * Observability: ```bash gemini extensions install https://github.com/gemini-cli-extensions/cloud-sql-mysql-observability ``` If you are looking for self-hosted MySQL, consider the `mysql` extension. #### Cloud SQL for PostgreSQL * Main Extension: ```bash gemini extensions install https://github.com/gemini-cli-extensions/cloud-sql-postgresql ``` Configuration: https://github.com/gemini-cli-extensions/cloud-sql-postgresql/tree/main?tab=readme-ov-file#configuration * Observability: ```bash gemini extensions install https://github.com/gemini-cli-extensions/cloud-sql-postgresql-observability ``` If you are looking for other PostgreSQL options, consider the `postgres` extension for self-hosted instances, or the `alloydb` extension for AlloyDB for PostgreSQL. #### Cloud SQL for SQL Server * Main Extension: ```bash gemini extensions install https://github.com/gemini-cli-extensions/cloud-sql-sqlserver ``` Configuration: https://github.com/gemini-cli-extensions/cloud-sql-sqlserver/tree/main?tab=readme-ov-file#configuration * Observability: ```bash gemini extensions install https://github.com/gemini-cli-extensions/cloud-sql-sqlserver-observability ``` If you are looking for self-hosted SQL Server, consider the `sql-server` extension. #### AlloyDB for PostgreSQL * Main Extension: ```bash gemini extensions install https://github.com/gemini-cli-extensions/alloydb ``` Configuration: https://github.com/gemini-cli-extensions/alloydb/tree/main?tab=readme-ov-file#configuration * Observability: ```bash gemini extensions install https://github.com/gemini-cli-extensions/alloydb-observability ``` If you are looking for other PostgreSQL options, consider the `postgres` extension for self-hosted instances, or the `cloud-sql-postgresql` extension for Cloud SQL for PostgreSQL. #### Spanner * For querying Spanner databases: ```bash gemini extensions install https://github.com/gemini-cli-extensions/spanner ``` Configuration: https://github.com/gemini-cli-extensions/spanner/tree/main?tab=readme-ov-file#configuration #### Firestore * For querying Firestore in Native Mode: ```bash gemini extensions install https://github.com/gemini-cli-extensions/firestore-native ``` Configuration: https://github.com/gemini-cli-extensions/firestore-native/tree/main?tab=readme-ov-file#configuration ### Other Google Cloud Data Services #### Dataplex * For interacting with Dataplex data lakes and assets: ```bash gemini extensions install https://github.com/gemini-cli-extensions/dataplex ``` Configuration: https://github.com/gemini-cli-extensions/dataplex/tree/main?tab=readme-ov-file#configuration #### Looker * For querying Looker instances: ```bash gemini extensions install https://github.com/gemini-cli-extensions/looker ``` Configuration: https://github.com/gemini-cli-extensions/looker/tree/main?tab=readme-ov-file#configuration ### Other Database Engines These extensions are for connecting to database instances not managed by Cloud SQL (e.g., self-hosted on-prem, on a VM, or in another cloud). * MySQL: ```bash gemini extensions install https://github.com/gemini-cli-extensions/mysql ``` Configuration: https://github.com/gemini-cli-extensions/mysql/tree/main?tab=readme-ov-file#configuration If you are looking for Google Cloud managed MySQL, consider the `cloud-sql-mysql` extension. * PostgreSQL: ```bash gemini extensions install https://github.com/gemini-cli-extensions/postgres ``` Configuration: https://github.com/gemini-cli-extensions/postgres/tree/main?tab=readme-ov-file#configuration If you are looking for Google Cloud managed PostgreSQL, consider the `cloud-sql-postgresql` or `alloydb` extensions. * SQL Server: ```bash gemini extensions install https://github.com/gemini-cli-extensions/sql-server ``` Configuration: https://github.com/gemini-cli-extensions/sql-server/tree/main?tab=readme-ov-file#configuration If you are looking for Google Cloud managed SQL Server, consider the `cloud-sql-sqlserver` extension. ### Custom Tools #### MCP Toolbox * For connecting to MCP Toolbox servers: This extension can be used with any Google Cloud database to build custom tools. For more information, see the [MCP Toolbox documentation](https://googleapis.github.io/genai-toolbox/getting-started/introduction/). ```bash gemini extensions install https://github.com/gemini-cli-extensions/mcp-toolbox ``` Configuration: https://github.com/gemini-cli-extensions/mcp-toolbox/tree/main?tab=readme-ov-file#configuration