run_select
Run SELECT or WITH queries against Oracle with safety guardrails: read-only, auto-redaction of PII columns, row limit, and statement timeout.
Instructions
Run a SELECT or WITH query against Oracle.
Guardrails:
- Only SELECT / WITH statements allowed
- DDL, DML, PL/SQL blocks, DBMS_/UTL_/SYS. calls are rejected
- Result row count is capped (see MCP_MAX_ROWS)
- PII-named columns (SSN, SALARY, PASSWORD, …) are auto-redacted
- Server-side statement timeout enforced
Returns a list of column-name dicts.Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |