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