Skip to main content
Glama
sagar1012

oracle-sqlplus-mcp

by sagar1012

execute_query

Execute a SQL SELECT query on an Oracle database. Provide the SQL without a trailing semicolon to retrieve results.

Instructions

Execute a SQL SELECT query against the Oracle database and return the results. Use standard Oracle SQL syntax. Do NOT include a trailing semicolon — it is added automatically.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
queryYesSQL SELECT query to execute (without trailing semicolon)
Behavior2/5

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

No annotations are provided, so the description carries full burden. Only one behavioral trait is disclosed (semicolon handling). It does not mention safety (SELECT is read-only), authentication needs, rate limits, or error behavior. Minimal disclosure.

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?

Two sentences, front-loaded with purpose, and no wasted words. Efficient and clear.

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?

For a simple one-parameter tool with no output schema, the description covers purpose and a key syntax constraint. It lacks explanation of return format or error behavior, but overall adequate for basic use.

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 100%, so baseline 3. The description repeats the no-semicolon rule already in the schema definition. No additional meaning beyond what the schema provides.

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 executes a SQL SELECT query against the Oracle database and returns results. The verb 'execute' and resource 'SQL SELECT query' are specific, and it distinguishes itself from sibling tools like execute_ddl and describe_table.

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 provides a syntax rule ('use standard Oracle SQL syntax, do NOT include a trailing semicolon') but does not explicitly say when to use this tool versus alternatives like execute_ddl. The context is implied but lack of explicit when-to-use or when-not-to-use guidance.

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/sagar1012/oracle-sqlplus-mcp'

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