cloud-gemini-data-analytics-query

A tool to convert natural language queries into SQL statements using the Gemini Data Analytics QueryData API.

  4 minute read  

About

The cloud-gemini-data-analytics-query tool allows you to send natural language questions to the Gemini Data Analytics API and receive structured responses containing SQL queries, natural language answers, and explanations. For details on defining data agent context for database data sources, see the official documentation.

[!NOTE] Only alloydb, spannerReference, and cloudSqlReference are supported as datasource references.

Compatible Sources

This tool can be used with the following database sources:

Source Name
Gemini Data Analytics

Example

kind: tool
name: my-gda-query-tool
type: cloud-gemini-data-analytics-query
source: my-gda-source
description: "Use this tool to send natural language queries to the Gemini Data Analytics API and receive SQL, natural language answers, and explanations."
location: ${your_database_location}
context:
  datasourceReferences:
    cloudSqlReference:
      databaseReference:
        projectId: "${your_project_id}"
        region: "${your_database_instance_region}"
        instanceId: "${your_database_instance_id}"
        databaseId: "${your_database_name}"
        engine: "POSTGRESQL"
      agentContextReference:
        contextSetId: "${your_context_set_id}" # E.g. projects/${project_id}/locations/${context_set_location}/contextSets/${context_set_id}
generationOptions:
  generateQueryResult: true
  generateNaturalLanguageAnswer: true
  generateExplanation: true
  generateDisambiguationQuestion: true

Usage Flow

When using this tool, a query parameter containing a natural language query is provided to the tool (typically by an agent). The tool then interacts with the Gemini Data Analytics API using the context defined in your configuration.

The structure of the response depends on the generationOptions configured in your tool definition (e.g., enabling generateQueryResult will include the SQL query results).

See Data Analytics API REST documentation for details.

Example Input Query:

How many accounts who have region in Prague are eligible for loans? A3 contains the data of region.

Example API Response:

{
  "generatedQuery": "SELECT COUNT(T1.account_id) FROM account AS T1 INNER JOIN loan AS T2 ON T1.account_id = T2.account_id INNER JOIN district AS T3 ON T1.district_id = T3.district_id WHERE T3.A3 = 'Prague'",
  "intentExplanation": "I found a template that matches the user's question. The template asks about the number of accounts who have region in a given city and are eligible for loans. The question asks about the number of accounts who have region in Prague and are eligible for loans. The template's parameterized SQL is 'SELECT COUNT(T1.account_id) FROM account AS T1 INNER JOIN loan AS T2 ON T1.account_id = T2.account_id INNER JOIN district AS T3 ON T1.district_id = T3.district_id WHERE T3.A3 = ?'. I will replace the named parameter '?' with 'Prague'.",
  "naturalLanguageAnswer": "There are 84 accounts from the Prague region that are eligible for loans.",
  "queryResult": {
    "columns": [
      {
        "type": "INT64"
      }
    ],
    "rows": [
      {
        "values": [
          {
            "value": "84"
          }
        ]
      }
    ],
    "totalRowCount": "1"
  }
}

Reference

fieldtyperequireddescription
typestringtrueMust be “cloud-gemini-data-analytics-query”.
sourcestringtrueThe name of the cloud-gemini-data-analytics source to use.
descriptionstringtrueA description of the tool’s purpose.
locationstringtrueThe Google Cloud location of the target database resource (e.g., “us-central1”). This is used to construct the parent resource name in the API call.
contextobjecttrueThe context for the query, including datasource references. See QueryDataContext for details.
generationOptionsobjectfalseOptions for generating the response. See GenerationOptions for details.

Advanced Usage

Parameterized Secure Views (PSV)

Parameterized Secure Views (PSV) provide a robust mechanism for Row-Level Access Control (RLAC). A PSV is a view defined on a base table that requires mandatory parameters at query time, users cannot read from the view without supplying the defined parameters, and direct access to the underlying base tables is revoked.

This is useful in agentic applications where each end-user should only see their own data, without the application having broad access to the base tables.

How it works:

  1. The database administrator creates a parameterized secure view and grants the API caller access only to that view, not the base table.
  2. At query time, the caller supplies parameterizedSecureViewParameters in the tool context. These key/value pairs are injected into the view’s filter, ensuring the query returns only the rows matching the provided parameters.
  3. The base tables are invisible to the caller; any attempt to query them directly will fail with a permissions error.

CloudSQL PostgreSQL example:

kind: tool
name: my-gda-psv-pg-tool
type: cloud-gemini-data-analytics-query
source: my-gda-source
description: "Query user-specific data via a parameterized secure view on CloudSQL Postgres."
location: ${your_database_location}
context:
  datasourceReferences:
    cloudSqlReference:
      databaseReference:
        projectId: "${your_project_id}"
        region: "${your_database_instance_region}"
        instanceId: "${your_database_instance_id}"
        databaseId: "${your_database_name}"
        engine: "POSTGRESQL"
      agentContextReference:
        contextSetId: "${your_context_set_id}" # E.g. projects/${project_id}/locations/${context_set_location}/contextSets/${context_set_id}
  parameterizedSecureViewParameters:
    parameters:
      - key: "app_end_userid"  # The parameter name defined in your secure view
        value: "303"           # The value to filter rows by (e.g., the end-user's ID)
generationOptions:
  generateQueryResult: true
  generateNaturalLanguageAnswer: true
  generateExplanation: true


Last modified March 26, 2026: chore(main): release 0.31.0 (#2814) (c6b811c)