Properties
| Name | Type | Description |
|---|---|---|
| name | string | Index name |
| fields | array | Fields to index |
| unique | boolean | Whether the index enforces uniqueness |
| language | string | Language for text indexes |
| spatial | string | Spatial index specification |
| search_on | string | Full-text search specification |
JSON Schema
{
"$schema": "https://json-schema.org/draft/2020-12/schema",
"$id": "#/components/schemas/IndexSpecification",
"title": "IndexSpecification",
"type": "object",
"required": [
"name"
],
"properties": {
"name": {
"type": "string",
"description": "Index name"
},
"fields": {
"type": "array",
"description": "Fields to index",
"items": {
"type": "object",
"properties": {
"path": {
"type": "string",
"description": "JSON path to the field"
},
"datatype": {
"type": "string",
"description": "Data type for indexing",
"enum": [
"string",
"number",
"date",
"timestamp"
]
},
"maxLength": {
"type": "integer",
"description": "Maximum length for string fields"
},
"order": {
"type": "string",
"enum": [
"asc",
"desc"
]
}
}
}
},
"unique": {
"type": "boolean",
"description": "Whether the index enforces uniqueness"
},
"language": {
"type": "string",
"description": "Language for text indexes"
},
"spatial": {
"type": "string",
"description": "Spatial index specification"
},
"search_on": {
"type": "string",
"description": "Full-text search specification",
"enum": [
"none",
"text",
"text_value"
]
}
}
}
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/oracle-database-indexspecification"
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.