run_aggregation_query

com.googleapis.firestore/mcp · Verify this server

Run an aggregation query against a Firestore database. Executes an aggregation query (such as COUNT, SUM, or AVG) over a structured query and returns the aggregated results. Required Parameters: - `parent`: The parent resource name in `projects/{project_id}/databases/{database_id}/documents` format (e.g., `projects/my-project/databases/(default)/documents`). - `structured_aggregation_query`: A `StructuredAggregationQuery` object defining the aggregation query to execute. Example usage (COUNT and AVG): ```json { "parent": "projects/my-project/databases/(default)/documents", "structured_aggregation_query": { "structured_query": { "from": [{"collection_id": "orders"}], "where": { "field_filter": { "field": {"field_path": "status"}, "op": "EQUAL", "value": {"string_value": "COMPLETED"} } } }, "aggregations": [ { "alias": "total_orders", "count": {} }, { "alias": "average_amount", "avg": { "field": {"field_path": "amount"} } } ] } } ```