io.github.marcelo-ochoa/oracle
NPM · @MARCELO-OCHOA/SERVER-ORACLE · SCANNED SEP 21
MCP server for interacting with Oracle databases
Available components
How this component scores in each security and reliability category. Every signal is checked automatically from public evidence about the published package, including repeated runs of it in an isolated sandbox, and we only credit what we can confirm. How we score → Why this is hard to score →
Supply Chain Security81
- No malware found by supply-chain analysis.Pass
- CVE check failed: a known high-severity CVE affects @toon-format/toon 1.4.0, a direct dependency. A fixed version is available. View diagnostics → Fail
- No install/post-install scripts declared.Pass
- 31 of 97 dependencies flagged as unhealthy. View diagnostics → Partial
Provenance & Transparency48
- Source repository is publicly reachable at the declared URL. View diagnostics → Pass
- Provenance check failed: no build-provenance attestation is published. See how to fix → View diagnostics → Fail
- Clear OSI-approved license (MIT).Pass
- Actively maintained (last published 193 days ago).Pass
- Publishes a security disclosure policy (SECURITY.md).Pass
Schema Quality & AI Usability76
- 100% of prompts and resources have a non-trivial description (not blank, and not just the item's name).Pass
- AI-judged instruction clarity (excellent).Pass
- Context-footprint check failed: tool/resource definitions use about 1270 tokens (~254/item across 5 items; 5 tools + 0 resources), over budget; trim descriptions and params. See how to fix → Fail
- Usage-examples check failed: none of the tools include examples. See how to fix → Fail
Stability & Change Management93
- Stability observed for 28 of 30 days with no destabilising changes; credit accrues until the full window elapses.Partial
Tool Coverage97
- 100% of tools have a non-trivial description (not blank, and not just the tool's name).Pass
- 92% of tool parameters carry a description.Partial
Tool Safety100
- No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.Pass
- We read all 5 captured tool definition(s), and no name or description among them implies an irreversible operation.Pass
- An AI judge read all 5 captured unit(s) of tool text and found none that tries to manipulate the model reading it.Pass
Capabilities100
- Implements a supported MCP spec version (2025-11-25); the latest is 2026-07-28.Pass
How do I install the io.github.marcelo-ochoa/oracle MCP server?
io.github.marcelo-ochoa/oracle runs locally as an npm package, launched with npx -y @marcelo-ochoa/server-oracle. Ready-made configuration for Claude, Cursor, VS Code, Codex and 5 more is on this page, copied from each client's own documentation.
npm · @marcelo-ochoa/server-oracle
claude mcp add marcelo-ochoa-oracle -- npx -y @marcelo-ochoa/server-oracle
{
"mcpServers": {
"marcelo-ochoa-oracle": {
"command": "npx",
"args": [
"-y",
"@marcelo-ochoa/server-oracle"
]
}
}
} {
"servers": {
"marcelo-ochoa-oracle": {
"command": "npx",
"args": [
"-y",
"@marcelo-ochoa/server-oracle"
]
}
}
} codex mcp add marcelo-ochoa-oracle -- npx -y @marcelo-ochoa/server-oracle
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"marcelo-ochoa-oracle": {
"type": "local",
"command": [
"npx",
"-y",
"@marcelo-ochoa/server-oracle"
],
"enabled": true
}
}
} openclaw mcp add marcelo-ochoa-oracle --command npx --arg -y --arg @marcelo-ochoa/server-oracle
mcp_servers:
marcelo-ochoa-oracle:
command: "npx"
args: ["-y", "@marcelo-ochoa/server-oracle"] {
"McpServers": {
"marcelo-ochoa-oracle": {
"Transport": "stdio",
"Command": "npx",
"Arguments": [
"-y",
"@marcelo-ochoa/server-oracle"
]
}
}
} assistant mcp add marcelo-ochoa-oracle -t stdio -c npx -a -y @marcelo-ochoa/server-oracle
{
"mcpServers": {
"marcelo-ochoa-oracle": {
"command": "npx",
"args": [
"-y",
"@marcelo-ochoa/server-oracle"
]
}
}
} Every change we have recorded for this component, newest first. Security-relevant changes are always shown. ▲ marks a change for the better, ▼ a change for the worse; unmarked changes are neutral.
- 19 Sept 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 83 to 87. That category is still filling its 30-day observation window: 25 days of observed history at the previous scan, 26 at this one. The score rises as the window fills, whether or not the server changes.
- 17 Sept 26 −2
- Stability: pass → 0.80 functional
- 16 Sept 26 0
- Stability: 0.97 → pass security
- 15 Sept 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 93 to 97. That category is still filling its 30-day observation window: 28 days of observed history at the previous scan, 29 at this one. The score rises as the window fills, whether or not the server changes.
- 12 Sept 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 83 to 87. That category is still filling its 30-day observation window: 25 days of observed history at the previous scan, 26 at this one. The score rises as the window fills, whether or not the server changes.
- 10 Sept 26 −2
- Stability: pass → 0.80 functional
- 9 Sept 26 0
- Stability: 0.97 → pass security
- 8 Sept 26 +1
No change was recorded against any check on this day. Stability & Change Management went from 93 to 97. That category is still filling its 30-day observation window: 28 days of observed history at the previous scan, 29 at this one. The score rises as the window fills, whether or not the server changes.
Diagnostic detail from the automated scan of this channel: what the scanner observed at each step, so you can see exactly where a check passed or failed. It is informational only and never changes the trust score.
Captured 21 Sept 2026 · Analysed npm/@marcelo-ochoa/server-oracle@1.0.7
Provenance No attestation
The registry publishes no build provenance for this version, so there is nothing to verify.
| Result | No attestation |
|---|---|
| Ecosystem | npm |
Background: How many MCP packages publish verified provenance →
Vulnerabilities 1 finding
| ID | CVE | Severity | Vector | Fix available |
|---|---|---|---|---|
| GHSA-p95v-992w-h6c3 | CVE-2026-82404 | high | CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:C/C:L/I:L/A:L | yes |
Background: What a vulnerability scan can and cannot prove →
Dependencies 97 packages
| Packages resolved | 97 |
|---|---|
| Stale | 31 |
| Tree resolution | Complete |
Background: SBOMs and build attestations, explained →
The tools this component advertises to a client, with an estimated token cost for each. Expand a tool to see its parameters and schema. The per-tool counts are indicative and are not scored directly; the schema's total context footprint is one signal in Schema Quality & AI Usability. A tool's description is untrusted text the model reads on every call, which is what makes this list a security surface and not just an inventory: how tool poisoning works →
orcl-awr ~248
Generate an Automatic Workload Repository (AWR) report or AWR SQL report for Oracle database performance analysis. AWR reports provide comprehensive performance metrics including database statistics, wait events, top SQL statements, system resources, and performance recommendations. If no sql_id is provided, generates a full AWR database report with: - Database instance information and configuration - Load profile and instance efficiency metrics - Top wait events and time model statistics - SQL statistics ordered by various metrics (elapsed time, CPU time, executions, etc.) - Segment statistics and I/O statistics - Memory and SGA statistics - System and session statistics If a sql_id is provided, generates an AWR SQL report focused on that specific SQL statement with: - SQL text and execution statistics - Execution plans and plan history - Bind variable information - Wait events specific to the SQL - Performance metrics over time Args: sql_id (optional): The SQL ID for generating an AWR SQL report. If omitted, generates a full AWR database report. Returns: Comprehensive performance report in text or HTML format with actionable insights for database tuning and optimization.
| Name | Type | Req | Description |
|---|---|---|---|
| sql_id | string | – | – |
No output schema declared.
No examples provided.
orcl-connect ~160
Provides an interface to connect to a specified database. If a database connection is already active, prompt the user for confirmation before switching to the new connection. The `model` argument should only be used to specify the name and version of the LLM (Large Language Model) you are using, with no additional information. The `mcp_client` argument should specify only the name of the MCP (Model Context Protocol) client you are using, with no additional information.
| Name | Type | Req | Description |
|---|---|---|---|
| connectionString | string | yes | The Oracle connect string (e.g. host.docker.internal:1521/freepdb1 |
| password | string | yes | The Oracle password (e.g. tiger |
| user | string | yes | The Oracle user (e.g. scott |
No output schema declared.
No examples provided.
orcl-explain ~253
Generate and display the execution plan for a given SQL query using Oracle's EXPLAIN PLAN command. This tool helps you understand how Oracle will execute your query, including information about table access methods, join operations, indexes used, estimated costs, and cardinality estimates. Args: sql: The SQL query to explain. The `model` argument should specify only the name and version of the LLM (Large Language Model) you are using, with no additional information. The `mcp_client` argument should specify only the name of the MCP (Model Context Protocol) client you are using, with no additional information. Returns: Detailed execution plan showing how Oracle will process the query, including operation types, object names, costs, bytes, and cardinality estimates.
| Name | Type | Req | Description |
|---|---|---|---|
| mcp_client | string | yes | Specify the name and version of the MCP client implementation being used (e.g. Copilot, Claude, Cline...) |
| model | string | yes | The name (and version) of the language model being used by the MCP client to process requests (e.g. gpt-4.1, claude-sonnet-4, llama4...) |
| sql | string | yes | The SQL query to explain |
No output schema declared.
No examples provided.
orcl-query ~348
This tool executes SQL queries in a READY ONLY session connected to an Oracle database. If no active connection exists, it uses MCP server registration argument and environment variables ORACLE_USER and ORACLE_PASSWORD. You should: Execute the provided SQL query. Return the results in Json format. Args: sql: The SQL query to execute. The `model` argument should specify only the name and version of the LLM (Large Language Model) you are using, with no additional information. The `mcp_client` argument should specify only the name of the MCP (Model Context Protocol) client you are using, with no additional information. Returns: Json-formatted query results. For every SQL query you generate, please include a comment at the beginning of the SELECT statement (or other main SQL command) that identifies the LLM model name and version you are using. Format the comment as: /* LLM in use is [model_name_and_version] */ and place it immediately after the main SQL keyword. For example: SELECT /* LLM in use is claude-sonnet-4 */ column1, column2 FROM table_name; Please apply this format consistently to all SQL queries you generate, using your actual model name and version in the comment
| Name | Type | Req | Description |
|---|---|---|---|
| mcp_client | string | yes | Specify the name and version of the MCP client implementation being used (e.g. Copilot, Claude, Cline...) |
| model | string | yes | The name (and version) of the language model being used by the MCP client to process requests (e.g. gpt-4.1, claude-sonnet-4, llama4...) |
| sql | string | yes | The SQL query to execute |
No output schema declared.
No examples provided.
orcl-stats ~261
Get comprehensive statistics for a specific Oracle database object (table, index, or view). This tool retrieves detailed information including row counts, block statistics, segment size, index information, column statistics, partition details, and other metadata that can help optimize queries and understand data distribution. Args: name: The name of the database object to get statistics for. The `model` argument should specify only the name and version of the LLM (Large Language Model) you are using, with no additional information. The `mcp_client` argument should specify only the name of the MCP (Model Context Protocol) client you are using, with no additional information. Returns: Json-formatted object statistics including row counts, block usage, size information, indexes, partitions, and column details with histograms and data distribution metrics.
| Name | Type | Req | Description |
|---|---|---|---|
| mcp_client | string | yes | Specify the name and version of the MCP client implementation being used (e.g. Copilot, Claude, Cline...) |
| model | string | yes | The name (and version) of the language model being used by the MCP client to process requests (e.g. gpt-4.1, claude-sonnet-4, llama4...) |
| name | string | yes | SQL Object to get stats |
No output schema declared.
No examples provided.
What is the io.github.marcelo-ochoa/oracle MCP server?
io.github.marcelo-ochoa/oracle is an MCP server listed in the public MCP registry as io.github.marcelo-ochoa/oracle. MCP server for interacting with Oracle databases. This page covers its npm package (@marcelo-ochoa/server-oracle).
Is the io.github.marcelo-ochoa/oracle MCP server safe to use?
io.github.marcelo-ochoa/oracle scores 78 out of 100 on VerifyMCP. We recorded 1 known advisory against it as of 21 September 2026. It declares no install or post-install scripts. That is a record of what we were able to check automatically, not an endorsement. The category breakdown on this page shows every signal behind the number, including the ones we could not confirm.
What tools does the io.github.marcelo-ochoa/oracle MCP server expose?
io.github.marcelo-ochoa/oracle exposes 5 tools: orcl-query, orcl-explain, orcl-stats, orcl-connect, orcl-awr. Their descriptions and schemas cost roughly 1,270 tokens of context every time the server is loaded.
Is the io.github.marcelo-ochoa/oracle MCP server still maintained?
io.github.marcelo-ochoa/oracle is still listed as active in the MCP registry. We last reached this channel on 21 September 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.
What licence is the io.github.marcelo-ochoa/oracle MCP server under?
io.github.marcelo-ochoa/oracle declares the MIT licence, which is OSI-approved. That covers the source only, and says nothing about the cost of any service it calls.