Skip to main content
Glama

Oracle MCP Server

execute_query

Execute SQL queries to retrieve data, analyze query performance, or examine database structure using SELECT, DESCRIBE, and EXPLAIN PLAN statements in Oracle Database.

Instructions

Execute a SQL query against the Oracle database. Only SELECT, DESCRIBE, and EXPLAIN PLAN statements are allowed for safety.

Input Schema

NameRequiredDescriptionDefault
paramsNoOptional parameters for parameterized queries
sqlYesSQL query to execute (SELECT, DESCRIBE, or EXPLAIN PLAN only)

Input Schema (JSON Schema)

{ "properties": { "params": { "default": [], "description": "Optional parameters for parameterized queries", "items": { "type": "string" }, "type": "array" }, "sql": { "description": "SQL query to execute (SELECT, DESCRIBE, or EXPLAIN PLAN only)", "type": "string" } }, "required": [ "sql" ], "type": "object" }

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/smith-nathanh/oracle-mcp-server'

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