Skip to main content
Glama
sevoniva

OceanBase MCP

by sevoniva

Compare Query Results

ob_compare_query_results

Compare two previously returned query results to detect differences without re-reading the database or storing row values.

Instructions

Compare two already returned query results without reading the database or storing row values.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
columnsNo
profileNo
leftNameNo
leftRowsYes
rightNameNo
rightRowsYes
keyColumnsNo
compareColumnsNo
maxDifferencesNo
Behavior2/5

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

Without annotations, the description partially discloses behavior: it does not read the database or store row values. However, it omits important details such as max rows (1000 from schema), how differences are returned, and any side effects or limitations.

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

Conciseness3/5

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

The description is a single concise sentence, but it is too brief for a tool with 9 parameters. The key function is front-loaded, but the lack of parameter detail sacrifices completeness.

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

Completeness1/5

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

Given the absence of an output schema, annotations, and any parameter descriptions, the description is wholly inadequate. It does not clarify what 'compare' outputs, how to use keys, or the result format, making it hard for an agent to invoke correctly.

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

Parameters1/5

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

The description does not explain any of the 9 parameters (e.g., 'keyColumns', 'compareColumns') despite 0% schema description coverage. The agent receives no additional meaning beyond the property names in the schema.

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 the action ('compare') and resource ('already returned query results'). It distinguishes this tool from siblings like ob_compare_schemas or ob_compare_tables, making it clear that it operates on query results rather than metadata.

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 explicit guidance on when to use this tool versus alternatives (e.g., ob_compare_metadata_snapshots). It implies that it compares in-memory results without reading the database, but does not state prerequisites or when not to use it.

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/sevoniva/oceanbase-mcp'

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