Skip to main content
Glama

search_objects

Search Oracle Fusion/ERP Cloud database objects by matching object name. Apply optional filters for object types, owner, and result limit to discover tables, views, procedures, and functions.

Instructions

Search ALL_OBJECTS in Oracle Fusion / ERP Cloud by object name pattern.

keyword: substring to match against object_name (case-insensitive) object_types: optional filter, e.g. ['TABLE','VIEW','PROCEDURE','FUNCTION','PACKAGE'] owner: optional schema owner filter (e.g. 'FUSION') limit: max results (capped at 200)

Returns: owner, object_name, object_type, status, last_ddl_time, table_comment

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
keywordYes
object_typesNo
ownerNo
limitNo
Behavior4/5

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

No annotations are provided, so the description bears full burden. It discloses that the limit is capped at 200 and lists return fields. It does not mention permissions or side effects, but the read-only nature is implied. Overall, good transparency for a search tool.

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

Conciseness4/5

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

The description is three sentences plus a bullet list of return fields. It is front-loaded with purpose and efficient, though the bullet list could be integrated into prose. No redundancy.

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

Completeness4/5

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

The tool has 4 parameters and no output schema. The description covers all parameters and return fields, and mentions the limit cap. It lacks details on error handling, pagination (though limit is given), or ordering, but is reasonably complete for a simple search.

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

Parameters5/5

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

Schema coverage is 0%, so the description fully compensates by explaining each parameter: keyword as substring match, object_types as optional filter, owner as schema filter, and limit with max cap. This adds significant meaning beyond the schema's bare types.

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

Purpose5/5

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

The description clearly states it searches ALL_OBJECTS in Oracle Fusion/ERP Cloud by object name pattern, specifying the verb (search), resource (ALL_OBJECTS), and system. It distinguishes from siblings like search_tables, search_columns, etc., which have narrower scope.

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

Usage Guidelines3/5

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

The description explains keyword matching (case-insensitive, substring) and optional filters (object_types, owner, limit). However, it lacks explicit guidance on when to use this tool over siblings like search_tables or search_source, leaving the agent to infer context.

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

Install Server

Other Tools

Latest Blog Posts

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/ramesharavapally/FUSION-MCP'

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