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
Name | Required | Description | Default |
---|---|---|---|
params | No | Optional parameters for parameterized queries | |
sql | Yes | SQL 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"
}