Oracle Link
Let Claude Code or Cursor run read-only Oracle SQL SELECTs against your schemas without writing a custom DB bridge.
Overview
Oracle Link is an MCP server for the Build phase that runs read-only Oracle SELECT queries from your AI coding agent over stdio.
What is this MCP server?
- Read-only SELECT execution over MCP with row limits via DEFAULT_MAX_ROWS
- stdio npm package @studious-xiaoyu/oracle-link v0.2.2
- Optional per-tool connection URL or ORACLE_USERNAME, ORACLE_PASSWORD, ORACLE_CONNECT_STRING env vars
- Optional SYSDBA or SYSOPER via ORACLE_PRIVILEGE
- Node.js transport suited to local Claude Desktop and Codex-style MCP hosts
- Server version 0.2.2
- Read-only SELECT semantics (no writes via MCP)
- npm package @studious-xiaoyu/oracle-link with stdio transport
What problem does it solve?
Agents cannot safely inspect Oracle production or staging data without a controlled read-only bridge and MCP wiring.
Who is it for?
Indie builders and small teams on Oracle who want MCP-native read-only SQL during backend or integration work.
Skip if: Teams that need INSERT/UPDATE/DDL, heavy ETL, or a managed warehouse UI instead of agent-driven SELECT.
What do I get? / Deliverables
After install, your agent can list schemas and run bounded SELECT queries using env-based or per-call Oracle credentials.
- MCP-registered read-only Oracle query tools in your agent
- Bounded SELECT results for schema and data checks
- Configurable max rows per query
Recommended MCP Servers
Journey fit
Oracle access is wired during product build when agents need live enterprise data for features, migrations, or debugging. MCP stdio integration maps cleanly to backend/data integrations rather than a standalone skill workflow.
How it compares
MCP database connector, not an agent skill or full SQL IDE.
Common Questions / FAQ
Who is Oracle Link for?
Developers and solo builders using Claude Code, Cursor, or similar agents who need read-only Oracle SELECT access from the IDE.
When should I use Oracle Link?
Use it during build and integration work when you want the agent to explore schemas or validate data without write privileges.
How do I add Oracle Link to my agent?
Install @studious-xiaoyu/oracle-link from npm, configure stdio MCP in your host, and set ORACLE_USERNAME, ORACLE_PASSWORD, and ORACLE_CONNECT_STRING or use the tool URL option documented in server.json.