Schema recommendation API endpoints
We've added new API endpoints for managing schema recommendations. You can now list, view, and dismiss schema recommendations for your databases through the API.
/v1/organizations/{organization}/databases/{database}/schema-recommendations— List schema recommendations for a database (GET)/v1/organizations/{organization}/databases/{database}/schema-recommendations/{number}— Get details about a specific schema recommendation (GET)/v1/organizations/{organization}/databases/{database}/schema-recommendations/{number}/dismiss— Dismiss a schema recommendation (POST)
These endpoints work with both Vitess and Postgres databases. To use them with a service token, grant your token read_database permission. Grant write_database to dismiss recommendations.
You can also use the pscale CLI to access these endpoints:
pscale api organizations/{org-name}/databases/{database-name}/schema-recommendations | jq