Oracle MCP Server

MIT License

Overview InspectNew Endpoints Schema Related Servers Reviews Score

execute_query

Run SQL queries on Oracle databases directly through the Oracle MCP Server. Execute specific queries, set parameters, and control row limits for precise data retrieval and analysis.

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"
}

This server cannot be installed

Other Tools from Oracle MCP Server

Related Tools

reqd_query
@anpy-j/mcp-oracle
execute-query
@NakiriYuuzu/Mssql-Mcp
mysql_query
@pickstar-2002/mysql-mcp
execute_sql
@crystaldba/postgres-mcp
mcp_execute_query
@hendrickcastro/MCPQL
execute_query
@nolleh/mcp-vertica

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