Oracle MCP Server

MIT License

Overview InspectNew Schema Related Servers Reviews Score

execute_query

Run SQL queries on Oracle databases using parameters and row limits. Supports database introspection and schema access for efficient data retrieval.

Instructions

Execute a SQL query on the Oracle database

Input Schema

Name	Required	Description
`maxRows`	No	Maximum number of rows to return (default: 1000)
`params`	No	Query parameters (optional)
`query`	Yes	SQL query to execute

Input Schema (JSON Schema)

{
  "properties": {
    "maxRows": {
      "default": 1000,
      "description": "Maximum number of rows to return (default: 1000)",
      "type": "number"
    },
    "params": {
      "description": "Query parameters (optional)",
      "items": {
        "type": [
          "string",
          "number",
          "boolean",
          "null"
        ]
      },
      "type": "array"
    },
    "query": {
      "description": "SQL query to execute",
      "type": "string"
    }
  },
  "required": [
    "query"
  ],
  "type": "object"
}

Install Server

HTTP connection URL

Other Tools from Oracle MCP Server

Related Tools

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

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