Oracle Link MCP Server

v1.0.0APIsstable

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 p

uncategorized
Share:
0
Stars
0
Downloads
0
Weekly
0/5

About

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 p

Features

  • oracle_query
  • oracle_list_tables
  • oracle_describe_table

Use Cases

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 p
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
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 index
Community

Maintainer

LicenseMIT
Languagetypescript
Versionv1.0.0
UpdatedN/A
Statushealthy
Maintenanceactive

Works with

ClaudeOpenAIwindowsmacoslinux

Installation

NPM

npx -y @studious-xiaoyu/oracle-link

Manual Installation

npx -y @studious-xiaoyu/oracle-link

Examples

Basic Configuration

Configure Oracle Link MCP Server

npx -y @studious-xiaoyu/oracle-link

Configuration

Configuration Details

Config File

claude_desktop_config.json

Web UI

Not available

Security

Authentication

RequiredNo

Features

Data Encryption
Audit Logging
RBAC Support

Performance

Response Metrics

Response Time< 200ms
ThroughputMedium

Resource Usage

Memory UsageLow
CPU UsageLow

More APIs MCP Servers

Explore other servers in the APIs category.

Quick Config Preview

{ "mcpServers": { "oracle-link": { "command": "npx", "args": ["-y", "@studious-xiaoyu/oracle-link"] } } }

Add this to your claude_desktop_config.json or .cursor/mcp.json

Read the full setup guide →

Ready to use Oracle Link MCP Server?

Browse our complete directory of 60+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.

60+ ServersFree & Open SourceStep-by-Step Guides