# Cast AI Advisor API

**Canonical:** https://apis.io/apis/kimchi/kimchi-advisorapi-api/  
**Provider:** Cast AI — https://apis.io/providers/kimchi/  
**Base URL:** https://api.cast.ai/

Cast AI Advisor API is one of 137 APIs that [Cast AI](https://apis.io/providers/kimchi/) publishes on the [APIs.io](https://apis.io/) network, described by a machine-readable OpenAPI specification. Tagged areas include Advisor API. The published artifact set on APIs.io includes an OpenAPI specification.

AdvisorAPI provides a unified view of query (performance) and index recommendations

## Operations (15)

| Method | Path | Summary |
|---|---|---|
| GET | `/database-optimizer/advisor/v1alpha/organizations/{organizationId}/cache-groups` | List cache groups with combined advisor statistics |
| GET | `/database-optimizer/advisor/v1alpha/organizations/{organizationId}/cache-groups/{cacheGroupId}/databases` | List databases with combined advisor statistics |
| GET | `/database-optimizer/advisor/v1alpha/organizations/{organizationId}/cache-groups/{id}` | Get cache group with combined advisor statistics |
| GET | `/database-optimizer/advisor/v1alpha/organizations/{organizationId}/database-instances` | List database instances with advisor agent status |
| GET | `/database-optimizer/advisor/v1alpha/organizations/{organizationId}/database-instances/{id}` | Get database instance with advisor agent status |
| POST | `/database-optimizer/advisor/v1alpha/organizations/{organizationId}/database-instances/{id}:markDbAgentUninstalled` | Internal: Mark the DB agent for a cache group as uninstalled |
| GET | `/database-optimizer/advisor/v1alpha/organizations/{organizationId}/databases/{databaseId}/recommendations` | List combined query and index advisor recommendations |
| GET | `/database-optimizer/advisor/v1alpha/organizations/{organizationId}/databases/{databaseId}/recommendations/{id}` | Get advisor recommendation details |
| POST | `/database-optimizer/advisor/v1alpha/organizations/{organizationId}/databases/{databaseId}/recommendations/{id}:close` | Close an advisor recommendation |
| POST | `/database-optimizer/advisor/v1alpha/organizations/{organizationId}/databases/{databaseId}/recommendations/{id}:reopen` | Reopen a closed advisor recommendation |
| POST | `/database-optimizer/advisor/v1alpha/organizations/{organizationId}/databases/{databaseId}/recommendations:reset` | Reset all advisor recommendations for a database |
| POST | `/database-optimizer/advisor/v1alpha/organizations/{organizationId}/databases/{databaseId}/validation-requests:resend` | Resend validation request for advisor recommendations that don't already have a… |
| GET | `/database-optimizer/advisor/v1alpha/organizations/{organizationId}/databases/{id}` | Get database with combined advisor statistics |
| POST | `/database-optimizer/advisor/v1alpha/organizations/{organizationId}/databases:batchGetStats` | Batch get advisor stats for databases |
| GET | `/database-optimizer/advisor/v1alpha/organizations/{organizationId}/top-recommendations` | List top recommendations across the organization |

## Machine-readable artifacts (1)

- **OpenAPI** — https://raw.githubusercontent.com/api-evangelist/kimchi/refs/heads/main/openapi/kimchi-advisorapi-api-openapi.yml

## Other Cast AI APIs (12)

- [Cast AI Addons API](https://apis.io/apis/kimchi/kimchi-addonsapi-api/)
- [Cast AI AI Enabler API](https://apis.io/apis/kimchi/kimchi-aienablerapi-api/)
- [Cast AI AI Enabler Playground API](https://apis.io/apis/kimchi/kimchi-aienablerplaygroundapi-api/)
- [Cast AI AI Enabler Providers API](https://apis.io/apis/kimchi/kimchi-aienablerprovidersapi-api/)
- [Cast AI AI Enabler Settings API](https://apis.io/apis/kimchi/kimchi-aienablersettingsapi-api/)
- [Cast AI Allocation Group API](https://apis.io/apis/kimchi/kimchi-allocationgroupapi-api/)
- [Cast AI Analytics API](https://apis.io/apis/kimchi/kimchi-analyticsapi-api/)
- [Cast AI API Keys API](https://apis.io/apis/kimchi/kimchi-apikeysapi-api/)
- [Cast AI Audit API](https://apis.io/apis/kimchi/kimchi-auditapi-api/)
- [Cast AI Audit V2API API](https://apis.io/apis/kimchi/kimchi-auditv2api-api/)
- [Cast AI Auth API](https://apis.io/apis/kimchi/kimchi-authapi-api/)
- [Cast AI Authorize API](https://apis.io/apis/kimchi/kimchi-authorizeapi-api/)

## Tags

Advisor API

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/apis/kimchi/kimchi-advisorapi-api/). The API's provider profile, Kin Score and agent-readiness rating are at https://apis.io/providers/kimchi/.