Oracle MCP Server

MIT License

Overview InspectNew Endpoints Schema Related Servers Reviews Score

get_table_indexes

Retrieve indexes for a specified table in Oracle databases. Input the table name and optional schema to identify and analyze relevant indexes for database optimization and query performance.

Instructions

Get indexes for a specific table

Input Schema

Name	Required	Description	Default
`schema`	No	Schema name (optional, searches all accessible schemas if not specified)
`table_name`	Yes	Table name

Input Schema (JSON Schema)

{
  "properties": {
    "schema": {
      "description": "Schema name (optional, searches all accessible schemas if not specified)",
      "type": "string"
    },
    "table_name": {
      "description": "Table name",
      "type": "string"
    }
  },
  "required": [
    "table_name"
  ],
  "type": "object"
}

This server cannot be installed

Other Tools from Oracle MCP Server

Related Tools

get_indexes
@sbfulfil/pg-mcp
describe_table
@anpy-j/mcp-oracle
get_table_index
@wenb1n-dev/mysql_mcp_server_pro
get_table_constraints
@samscarrow/oracle-mcp-server
list_indexes
@MadeByNando/mcp-postgres-server
list_indexes
@nolleh/mcp-vertica

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/samscarrow/oracle-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server