oracle_list_profiles | Oracle List Profiles | List configured connection profiles without exposing connect strings, usernames, or credential references. | READ_ONLY | no |
oracle_connection_info | Oracle Connection Info | Describe the active profile, its effective MCP access (operating level, profile max_level, protected status, and whether writes are permitted now), and Oracle connection state. | READ_ONLY | no |
oracle_switch_profile | Oracle Switch Profile | Reconnect this MCP server to another configured profile by name and report that profile's effective MCP access. | READ_ONLY | no |
oracle_set_session_level | Oracle Set Session Level | Preview or apply a temporary session operating-level elevation within the active profile ceiling, or drop back to READ_ONLY. | READ_ONLY | yes |
oracle_query | Oracle Query | Run a read-only SELECT with positional binds; paginated and row/byte capped. | READ_ONLY | no |
oracle_semantic_search | Oracle Semantic Search | Run a bounded, fail-closed 23ai vector search through the same policy, semantic-resolution, masking, and audit path as oracle_query. | READ_ONLY | no |
oracle_diff | Oracle Diff | Diff one proven read-only SELECT across two Oracle SCNs, or across two databases. | READ_ONLY | no |
oracle_preview_sql | Oracle Preview SQL | Classify SQL without executing it and bind the exact SQL, typed binds, commit/hold mode, output caps and timeout into any confirmation. | READ_ONLY | no |
oracle_execute | Oracle Execute | Execute one non-read SQL statement through the classifier and active profile gate; DML rolls back by default. | READ_ONLY | yes |
oracle_checkpoint | Oracle Checkpoint | Establish a named checkpoint (a native Oracle SAVEPOINT) on this session, opening the reversible workspace: oracle_execute with hold=true and a matching preview confirmation leaves DML pending instead of rolling it back, and oracle_undo_to walks it back. | READ_WRITE | yes |
oracle_undo_to | Oracle Undo To | Undo the reversible workspace: ROLLBACK TO SAVEPOINT discards every held statement executed after that checkpoint and releases the checkpoints stacked above it, leaving the transaction open. | READ_WRITE | yes |
oracle_preview_dml | Oracle Preview DML | Dry-run one DML statement: the server brackets it in its own savepoint, executes it, reads the rows it touched, then rolls back to that savepoint and presents the result — nothing is committed and nothing is left behind. | READ_WRITE | yes |
oracle_compile_object | Oracle Compile Object | Preview or compile one PL/SQL/view object through the active DDL profile gate; preview is the default and execution requires the returned confirmation token. | DDL | yes |
oracle_create_or_replace | Oracle Create Or Replace | Preview or apply one CREATE OR REPLACE statement through the classifier and active DDL profile gate. | DDL | yes |
oracle_patch_source | Oracle Patch Source | Preview or apply an exact old_text to new_text replacement against one stored source object; preview refetches the current source and execute uses the existing DDL confirmation gate. | DDL | yes |
oracle_list_schemas | Oracle List Schemas | List schemas that own objects visible to this session, optionally filtered by name. | READ_ONLY | no |
oracle_schema_inspect | Oracle Schema Inspect | List objects in the current schema, one owner, or all accessible schemas, with optional type/name filters. | READ_ONLY | no |
oracle_search_objects | Oracle Search Objects | Unified read-only object search/inspection with a detail_level. | READ_ONLY | no |
oracle_orient | Oracle Orient | Return bounded orientation evidence: by default one cacheable snapshot for the active profile; fleet=true maps every MCP-visible profile independently with schema, version, freshness, drift, and typed UNREACHABLE/FAIL_CLOSED lane status. | READ_ONLY | no |
oracle_describe | Oracle Describe | Describe a table/view's columns and constraint metadata. | READ_ONLY | no |
oracle_describe_index | Oracle Describe Index | Describe one index's metadata, indexed columns, and function-based expressions. | READ_ONLY | no |
oracle_describe_trigger | Oracle Describe Trigger | Describe one trigger's timing, event, target table, status, and body. | READ_ONLY | no |
oracle_describe_view | Oracle Describe View | Describe one view's definition metadata and columns. | READ_ONLY | no |
oracle_get_ddl | Oracle Get DDL | Fetch an object's DDL via DBMS_METADATA.GET_DDL (allowlisted object types). | READ_ONLY | no |
oracle_get_source | Oracle Get Source | Fetch an object's full source text or inclusive line range from ALL_SOURCE, or fetch a view definition from ALL_VIEWS.TEXT, with a character cap. | READ_ONLY | no |
oracle_sample_rows | Oracle Sample Rows | Read arbitrary first rows of a table or view with a hard row cap. | READ_ONLY | no |
oracle_read_clob | Oracle Read CLOB | Read one CLOB/NCLOB/text value by key with a character cap. | READ_ONLY | no |
oracle_compile_errors | Oracle Compile Errors | Retrieve compile errors for the current schema, an owner, or one object (ALL_ERRORS). | READ_ONLY | no |
oracle_search_source | Oracle Search Source | Full-text search across ALL_SOURCE for a needle (row- and line-capped). | READ_ONLY | no |
oracle_plscope_inspect | Oracle PL/Scope Inspect | Inspect PL/Scope identifier and SQL statement metadata for one PL/SQL object when ALL_IDENTIFIERS/ALL_STATEMENTS are populated. | READ_ONLY | no |
oracle_explain_plan | Oracle Explain Plan | Explicit diagnostic-write EXPLAIN PLAN for a vetted SELECT; writes PLAN_TABLE, requires READ_WRITE plus allow_plan_table_write, and is disabled on read-only standby. | READ_WRITE | yes |
oracle_top_queries | Oracle Top Queries | Read-only top-SQL ranked by elapsed/CPU/buffer-gets/disk-reads over the free live cursor cache (V$SQLSTATS); live calls may narrow by exact sql_id or bounded sql_text. | READ_ONLY | no |
oracle_plan_timeline | Oracle Plan Timeline | Read-only historical optimizer plan and relative-cost timeline from AWR snapshots for one SQL ID. | READ_ONLY | no |
oracle_db_health | Oracle Db Health | Read-only DBA health-check suite. | READ_ONLY | no |
oracle_plsql_parse | Oracle Plsql Parse | Parse PL/SQL source with the offline plsql-intelligence lowerer and return declaration and diagnostic counts. | READ_ONLY | no |
oracle_plsql_analyze | Oracle Plsql Analyze | Run the offline plsql-intelligence engine over a local project root and return doctor summaries. | READ_ONLY | no |
oracle_plsql_what_breaks | Oracle Plsql What Breaks | Predict invalidation and recompilation impact for a PL/SQL ChangeSet without touching Oracle. | READ_ONLY | no |
oracle_plsql_lineage | Oracle Plsql Lineage | Run offline dependency-lineage traversal from a logical object id in a local PL/SQL project. | READ_ONLY | no |
oracle_lineage | Oracle Lineage | Live-verified COLUMN lineage: cross-check source-derived owner.object.column edges against the guarded Oracle catalog and mark verified, missing, or type-mismatched drift. | READ_ONLY | no |
oracle_plsql_sast | Oracle Plsql Sast | Run the offline plsql-sast rule harness over a local PL/SQL project and return findings plus skipped-rule evidence. | READ_ONLY | no |
oracle_plsql_doc | Oracle Plsql Doc | Extract doc comments from source or render an existing plsql-doc DocSet. | READ_ONLY | no |
oracle_plsql_live_snapshot | Oracle Plsql Live Snapshot | Extract live Oracle dictionary rowsets and normalize them through plsql-intelligence CatalogSnapshotBuilder. | READ_ONLY | no |
oracle_plsql_blast_radius | Oracle Plsql Blast Radius | Extract a live catalog snapshot, then run the plsql-cicd change-impact predictor for a proposed ChangeSet. | READ_ONLY | no |