io.github.StudiousXiaoYu/oracle-link
NPM · @STUDIOUS-XIAOYU/ORACLE-LINK · SCANNED SEP 20
Oracle MCP Query Server (Node.js) - Read-only SELECT via MCP
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 Security98
- No malware found by supply-chain analysis.Pass
- No known CVEs affecting this package version or its production dependencies.Pass
- No install/post-install scripts declared.Pass
- 31 of 98 dependencies flagged as unhealthy. View diagnostics → Partial
Provenance & Transparency5
- Repository check failed: the declared repository URL returned HTTP 404. See how to fix → View diagnostics → Fail
- Provenance check failed: no build-provenance attestation is published. See how to fix → View diagnostics → Fail
- License check failed: no license is declared. See how to fix → Fail
- Actively maintained (last published 289 days ago).Pass
- Security-disclosure policy not yet verified: we couldn't inspect the source repository.Unverified
Schema Quality & AI Usability80
- AI-judged instruction clarity (excellent).Pass
- Context-footprint check failed: tool/resource definitions use about 499 tokens (~166/item across 3 items; 3 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 Coverage100
- 100% of tools have a non-trivial description (not blank, and not just the tool's name).Pass
- 100% of tool parameters carry a description.Pass
- Structured output schemas are declared (100% of tools); any adoption earns full credit.Pass
Tool Safety75
- No prompt-injection markers were found in the server instructions, tool names or descriptions we captured.Pass
- 0 of 1 tool(s) whose name or description implies an irreversible operation declare an MCP destructiveHint annotation; "oracle_query" implies "execute" and declares no destructiveHint at all, which the MCP spec reads as destructive by default. See how to fix → Fail
- An AI judge read all 3 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.StudiousXiaoYu/oracle-link MCP server?
io.github.StudiousXiaoYu/oracle-link runs locally as an npm package, launched with npx -y @studious-xiaoyu/oracle-link. Ready-made configuration for Claude, Cursor, VS Code, Codex and 5 more is on this page, copied from each client's own documentation.
npm · @studious-xiaoyu/oracle-link
claude mcp add studiousxiaoyu-oracle-link -- npx -y @studious-xiaoyu/oracle-link
{
"mcpServers": {
"studiousxiaoyu-oracle-link": {
"command": "npx",
"args": [
"-y",
"@studious-xiaoyu/oracle-link"
]
}
}
} {
"servers": {
"studiousxiaoyu-oracle-link": {
"command": "npx",
"args": [
"-y",
"@studious-xiaoyu/oracle-link"
]
}
}
} codex mcp add studiousxiaoyu-oracle-link -- npx -y @studious-xiaoyu/oracle-link
{
"$schema": "https://opencode.ai/config.json",
"mcp": {
"studiousxiaoyu-oracle-link": {
"type": "local",
"command": [
"npx",
"-y",
"@studious-xiaoyu/oracle-link"
],
"enabled": true
}
}
} openclaw mcp add studiousxiaoyu-oracle-link --command npx --arg -y --arg @studious-xiaoyu/oracle-link
mcp_servers:
studiousxiaoyu-oracle-link:
command: "npx"
args: ["-y", "@studious-xiaoyu/oracle-link"] {
"McpServers": {
"studiousxiaoyu-oracle-link": {
"Transport": "stdio",
"Command": "npx",
"Arguments": [
"-y",
"@studious-xiaoyu/oracle-link"
]
}
}
} assistant mcp add studiousxiaoyu-oracle-link -t stdio -c npx -a -y @studious-xiaoyu/oracle-link
{
"mcpServers": {
"studiousxiaoyu-oracle-link": {
"command": "npx",
"args": [
"-y",
"@studious-xiaoyu/oracle-link"
]
}
}
} 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 87 to 90. That category is still filling its 30-day observation window: 26 days of observed history at the previous scan, 27 at this one. The score rises as the window fills, whether or not the server changes.
- 16 Sept 26 −2
- Stability: pass → 0.80 functional
- 15 Sept 26 0
- Stability: 0.97 → pass security
- 14 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 87 to 90. That category is still filling its 30-day observation window: 26 days of observed history at the previous scan, 27 at this one. The score rises as the window fills, whether or not the server changes.
- 9 Sept 26 −2
- Stability: pass → 0.80 functional
- 8 Sept 26 0
- Stability: 0.97 → pass security
- 7 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 20 Sept 2026 · Analysed npm/@studious-xiaoyu/oracle-link@0.2.2
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 →
Dependencies 98 packages
| Packages resolved | 98 |
|---|---|
| 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 →
oracle_describe_table Oracle Describe Table ~168
Return detailed metadata for a table: table comment; columns with data type, length, precision/scale, nullability, default value, and column comment; primary key columns; unique constraints; foreign keys with referenced owner/table/columns; and indexes with uniqueness and columns. With owner provided, queries ALL_* views (may require privileges); otherwise uses USER_* views. Optional url supports per-call connection. table_name and owner are typically uppercase.
| Name | Type | Req | Description |
|---|---|---|---|
| owner | string | – | Schema/owner of the table. Uses ALL_* views when provided; otherwise USER_*. |
| table_name | string | yes | Target table name. Typically uppercase; quoted mixed-case identifiers require exact case. |
| url | string | – | Per-call connection string. Format: oracle://user:password@host:port/service |
| Name | Type | Req | Description |
|---|---|---|---|
| columns | array | yes | – |
| comment | – | yes | – |
| foreignKeys | array | yes | – |
| indexes | array | yes | – |
| message | string | yes | – |
| primaryKey | array | yes | – |
| success | boolean | yes | – |
| table | string | yes | – |
| uniqueConstraints | array | yes | – |
No examples provided.
oracle_list_tables Oracle List Tables ~139
List table names for the current user or the specified schema owner. Without owner, queries USER_TABLES; with owner, queries ALL_TABLES and may require appropriate privileges. Optional url enables per-call connection (oracle://user:password@host:port/service). The owner value is treated case-insensitively but typically uppercase is used. Returns the total count and the table name list.
| Name | Type | Req | Description |
|---|---|---|---|
| owner | string | – | Schema/owner name. Without owner uses USER_TABLES; with owner uses ALL_TABLES (requires privileges). |
| url | string | – | Per-call connection string. Format: oracle://user:password@host:port/service |
| Name | Type | Req | Description |
|---|---|---|---|
| count | integer | yes | – |
| message | string | yes | – |
| success | boolean | yes | – |
| tables | array | yes | – |
No examples provided.
oracle_query Oracle SELECT Query ~192
Execute a read-only SELECT/WITH query on Oracle. Rejects non-SELECT statements and enforces a row limit by appending FETCH FIRST when needed. Use max_rows to cap returned rows; when url includes maxRows, it overrides max_rows. Optional url supports per-call connection in the form oracle://user:password@host:port/service?privilege=SYSDBA&maxRows=N. Returns rows as an array of objects keyed by column names. Intended strictly for data retrieval.
| Name | Type | Req | Description |
|---|---|---|---|
| max_rows | integer | – | Maximum rows to return. Enforced by appending FETCH FIRST when needed. |
| sql | string | yes | SQL text of a read-only query. Must start with SELECT or WITH; DML/DDL are rejected. |
| url | string | – | Per-call connection string. Format: oracle://user:password@host:port/service?privilege=SYSDBA&maxRows=N |
| Name | Type | Req | Description |
|---|---|---|---|
| data | array | yes | – |
| message | string | yes | – |
| row_count | integer | yes | – |
| success | boolean | yes | – |
No examples provided.
What is the io.github.StudiousXiaoYu/oracle-link MCP server?
io.github.StudiousXiaoYu/oracle-link is an MCP server listed in the public MCP registry as io.github.StudiousXiaoYu/oracle-link. Oracle MCP Query Server (Node.js) - Read-only SELECT via MCP. This page covers its npm package (@studious-xiaoyu/oracle-link).
Is the io.github.StudiousXiaoYu/oracle-link MCP server safe to use?
io.github.StudiousXiaoYu/oracle-link scores 74 out of 100 on VerifyMCP. We found no known CVEs affecting it as of 20 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.StudiousXiaoYu/oracle-link MCP server expose?
io.github.StudiousXiaoYu/oracle-link exposes 3 tools: oracle_query, oracle_list_tables, oracle_describe_table. Their descriptions and schemas cost roughly 499 tokens of context every time the server is loaded.
Is the io.github.StudiousXiaoYu/oracle-link MCP server still maintained?
io.github.StudiousXiaoYu/oracle-link is still listed as active in the MCP registry. We last reached this channel on 20 September 2026. Those dates come from our own scans of the registry and the channel itself, not from anything the publisher announced.