Properties
| Name | Type | Description |
|---|---|---|
| hiddenIndexes | array | List that contains the documents with information about the hidden indexes that the Performance Advisor suggests to remove. |
| redundantIndexes | array | List that contains the documents with information about the redundant indexes that the Performance Advisor suggests to remove. |
| unusedIndexes | array | List that contains the documents with information about the unused indexes that the Performance Advisor suggests to remove. |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "https://raw.githubusercontent.com/api-evangelist/mongodb/main/json-schema/mongodb-drop-index-suggestions-response-schema.json",
"title": "DropIndexSuggestionsResponse",
"x-generated": "2026-10-03",
"x-method": "derived",
"x-generator": "derive-json-schema.py",
"x-source": "openapi/mongodb-performance-advisor-api-openapi.yml#/components/schemas/DropIndexSuggestionsResponse",
"properties": {
"hiddenIndexes": {
"description": "List that contains the documents with information about the hidden indexes that the Performance Advisor suggests to remove.",
"items": {
"$ref": "#/$defs/DropIndexSuggestionsIndex"
},
"readOnly": true,
"type": "array"
},
"redundantIndexes": {
"description": "List that contains the documents with information about the redundant indexes that the Performance Advisor suggests to remove.",
"items": {
"$ref": "#/$defs/DropIndexSuggestionsIndex"
},
"readOnly": true,
"type": "array"
},
"unusedIndexes": {
"description": "List that contains the documents with information about the unused indexes that the Performance Advisor suggests to remove.",
"items": {
"$ref": "#/$defs/DropIndexSuggestionsIndex"
},
"readOnly": true,
"type": "array"
}
},
"type": "object",
"$defs": {
"DropIndexSuggestionsIndex": {
"properties": {
"accessCount": {
"description": "Usage count (since last restart) of index.",
"format": "int64",
"type": "integer"
},
"index": {
"description": "List that contains documents that specify a key in the index and its sort order.",
"items": {
"description": "One index key paired with its sort order. A value of `1` indicates an ascending sort order. A value of `-1` indicates a descending sort order. Keys in indexes with multiple keys appear in the same order that they appear in the index.",
"type": "object"
},
"type": "array"
},
"name": {
"description": "Name of index.",
"type": "string"
},
"namespace": {
"description": "Human-readable label that identifies the namespace on the specified host. The resource expresses this parameter value as `<database>.<collection>`.",
"type": "string"
},
"shards": {
"description": "List that contains strings that specifies the shards where the index is found.",
"items": {
"description": "Shard name.",
"type": "string"
},
"type": "array"
},
"since": {
"description": "Date of most recent usage of index. This parameter expresses its value in the ISO 8601 timestamp format in UTC.",
"format": "date-time",
"type": "string"
},
"sizeBytes": {
"description": "Size of index.",
"format": "int64",
"type": "integer"
}
},
"type": "object"
}
}
}
Work with this as data
Every JSON Schema here is available over the APIs.io API and to AI agents over MCP.
MCP server
One button, every client — Claude, Cursor, VS Code and the rest.
https://apis.io/mcp
Tools for schemas
4 MCP tools reach this
find_json_schemasBrowse and filter every JSON Schema in the catalog.apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.resolveTurn a domain, URL or GitHub org into the provider it belongs to.find_cohortsEvery scored population of providers in the catalog.
Call it yourself
curl for this page
This JSON Schema
curl "https://apis.io/api/v1/json-schemas/mongodb-drop-index-suggestions-response"
All schemas
curl "https://apis.io/api/v1/json-schemas?limit=25"
Discovery needs no key. Ratings and market analysis are Pro.
Get an API key
Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.
A second provider on the same verified email joins the account you already have.