Skip to main content
Glama
Kuass

oracle-db-mcp

by Kuass

get_object_details

Retrieve detailed information about an Oracle database object. Provide the object name and optional type (TABLE, VIEW, SEQUENCE) to get its details.

Instructions

Get detailed information about a database object

Args:
    object_name (string): The name of the object
    object_type (string, optional): The type of object (TABLE, VIEW, SEQUENCE). Default is TABLE

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
object_nameYes
object_typeNoTABLE

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.0.1

TDQS

C2.9/5.0
Behavior2/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

No annotations are provided, so the description carries the full behavioral burden. It does not state that this is a read-only operation, what kind of details are returned, whether permissions are required, or what happens for invalid object types. Only the parameter list is included, adding minimal behavioral context.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is short, front-loaded, and structured with a clear Args section. Every line earns its place with no redundancy or filler.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness2/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

With no annotations, no output schema, and 0% schema description coverage, the description should do more. It omits what 'detailed information' includes, whether it is a read-only operation, and when to prefer it over siblings like describe_table. It covers parameters but leaves significant gaps.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 0%, so the description must compensate. It documents both parameters and usefully lists possible object_type values (TABLE, VIEW, SEQUENCE) and the default (TABLE), which the schema does not provide. However, object_name is only described as 'the name of the object' with no format or qualification details.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose4/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description states a specific verb ('Get') and resource ('detailed information about a database object'), making the core purpose clear. However, it does not differentiate this tool from siblings like describe_table or list_objects, so it falls short of a 5.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines2/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides no guidance on when to use this tool versus alternatives such as describe_table, list_objects, or explain_query. It only documents the arguments, leaving the agent to infer usage from the name alone.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.