---
updatedAt: 2026-08-26T11:11:10.000Z
agentTools:
  projectIndex: https://docs.cast.ai/llms.txt
---

# Get cache database

Get a cache database
 Gets a specific cache databases

# OpenAPI definition

```json
{
  "openapi": "3.0.3",
  "servers": [
    {
      "url": "https://api.cast.ai/",
      "description": "US endpoint"
    },
    {
      "url": "https://api.eu.cast.ai/",
      "description": "EU endpoint"
    }
  ],
  "info": {
    "title": "Database Optimizer",
    "version": "0.0.1"
  },
  "security": [
    {
      "BearerAuth": []
    },
    {
      "ApiKeyAuth": []
    }
  ],
  "paths": {
    "/database-optimizer/index-advisor/v1alpha/organizations/{organizationId}/cache-groups/{cacheGroupId}/databases/{id}": {
      "get": {
        "tags": [
          "DatabasesAPI"
        ],
        "summary": "Get cache database",
        "description": "Get a cache database\n Gets a specific cache databases",
        "operationId": "DatabasesAPI_GetCacheDatabase",
        "parameters": [
          {
            "name": "organizationId",
            "in": "path",
            "description": "Organization identifier",
            "required": true,
            "schema": {
              "type": "string"
            }
          },
          {
            "name": "cacheGroupId",
            "in": "path",
            "description": "Cache group ID",
            "required": true,
            "schema": {
              "type": "string"
            }
          },
          {
            "name": "id",
            "in": "path",
            "description": "Database ID",
            "required": true,
            "schema": {
              "type": "string"
            }
          }
        ],
        "responses": {
          "200": {
            "description": "OK",
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/CacheDatabase"
                }
              }
            }
          },
          "default": {
            "description": "Default error response",
            "content": {
              "application/json": {
                "schema": {
                  "$ref": "#/components/schemas/Status"
                }
              }
            }
          }
        }
      }
    }
  },
  "components": {
    "securitySchemes": {
      "BearerAuth": {
        "type": "http",
        "scheme": "bearer",
        "bearerFormat": "JWT"
      },
      "ApiKeyAuth": {
        "type": "apiKey",
        "in": "header",
        "name": "X-API-Key"
      }
    },
    "schemas": {
      "CacheDatabase": {
        "required": [
          "id",
          "name",
          "totalIndexes",
          "indexesSize",
          "recommendationsSummary"
        ],
        "type": "object",
        "properties": {
          "id": {
            "type": "string",
            "description": "Database ID"
          },
          "name": {
            "type": "string",
            "description": "Name of the database"
          },
          "totalIndexes": {
            "type": "integer",
            "description": "Total number of existing indexes",
            "format": "uint32"
          },
          "indexesSize": {
            "type": "string",
            "description": "Total size of indexes in bytes"
          },
          "recommendationsSummary": {
            "allOf": [
              {
                "$ref": "#/components/schemas/RecommendationSummary"
              }
            ],
            "description": "Summary of recommendations"
          }
        },
        "description": "Database owned by a cache group"
      },
      "GoogleProtobufAny": {
        "type": "object",
        "properties": {
          "@type": {
            "type": "string",
            "description": "The type of the serialized message."
          }
        },
        "additionalProperties": true,
        "description": "Contains an arbitrary serialized message along with a @type that describes the type of the serialized message."
      },
      "RecommendationSummary": {
        "required": [
          "totalCreateIndex",
          "totalDropIndex",
          "totalCount"
        ],
        "type": "object",
        "properties": {
          "totalCreateIndex": {
            "type": "integer",
            "description": "Number of create index recommendations",
            "format": "uint32"
          },
          "totalDropIndex": {
            "type": "integer",
            "description": "Number of drop index recommendations",
            "format": "uint32"
          },
          "totalCount": {
            "type": "integer",
            "description": "Total number of recommendations",
            "format": "uint32"
          }
        },
        "description": "Recommendations summary"
      },
      "Status": {
        "type": "object",
        "properties": {
          "code": {
            "type": "integer",
            "description": "The status code, which should be an enum value of [google.rpc.Code][google.rpc.Code].",
            "format": "int32"
          },
          "message": {
            "type": "string",
            "description": "A developer-facing error message, which should be in English. Any user-facing error message should be localized and sent in the [google.rpc.Status.details][google.rpc.Status.details] field, or localized by the client."
          },
          "details": {
            "type": "array",
            "items": {
              "$ref": "#/components/schemas/GoogleProtobufAny"
            },
            "description": "A list of messages that carry the error details.  There is a common set of message types for APIs to use."
          }
        },
        "description": "The `Status` type defines a logical error model that is suitable for different programming environments, including REST APIs and RPC APIs. It is used by [gRPC](https://github.com/grpc). Each `Status` message contains three pieces of data: error code, error message, and error details. You can find out more about this error model and how to work with it in the [API Design Guide](https://cloud.google.com/apis/design/errors)."
      }
    }
  },
  "tags": [
    {
      "name": "DatabasesAPI",
      "description": "DatabasesAPI provides operations for managing databases for Index Advisor"
    }
  ]
}
```