Sign in

v17

latestOpenAPI 3.0.1raw.githubusercontent.com2026-07-08165682.0 MB
Schema recommendations

Dismiss a schema recommendation

Authorization

A service token or OAuth token must have at least one of the following access or scopes in order to use this API endpoint:

Service Token Accesses write_database

OAuth Scopes

ResourceScopes
Organizationwrite_databases
Databasewrite_database
post/organizations/{organization}/databases/{database}/schema-recommendations/{number}/dismiss

Path parameters

organizationstring required

Organization name slug from list_organizations. Example: acme.

databasestring required

Database name slug from list_databases. Example: app-db.

numberinteger required

Schema recommendation sequence number. Example: 42.

Request body

reasonstring

The reason for dismissing the recommendation (max 500 characters)

Response

Returns the dismissed schema recommendation

idstring required

The ID of the schema recommendation

html_urlstring required

The URL to the schema recommendation in the app

titlestring required

The title of the schema recommendation

table_namestring required

The name of the table the recommendation applies to

keyspacestring required

The keyspace the recommendation applies to

ddl_statementstring required

The DDL statement to apply the recommendation

numberinteger required

The number of the schema recommendation

state'open' | 'applied' | 'dismissed' | 'stale' required

The state of the recommendation

recommendation_type'unused_table' | 'unused_index' | 'duplicate_index' | 'sequence_overflow' | 'sequence_overflow_foreign_key' | 'new_index' | 'encoding_upgrade' | 'bloated_table' | 'bloated_index' required

The type of recommendation

created_atstring required

When the recommendation was created

updated_atstring required

When the recommendation was last updated

applied_atstring nullable required

When the recommendation was applied

dismissed_atstring nullable required

When the recommendation was dismissed