fn_ora_mcp
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| ORACLE_HOST | Yes | Oracle DB server IP | |
| ORACLE_PORT | No | Port (default 1521) | 1521 |
| ORACLE_USER | Yes | DB account | |
| ORACLE_SCHEMA | No | Target schema (empty uses ORACLE_USER) | |
| ORACLE_SERVICE | Yes | Service name or SID | |
| ORACLE_PASSWORD | Yes | DB password |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
| logging | {} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| extensions | {
"io.modelcontextprotocol/ui": {}
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| get_package_sourceC | Oracle 패키지 소스 조회. |
| list_package_objectsB | 패키지 내 함수/프로시저 목록 조회. |
| search_packagesA | 패키지명 패턴 검색. % 없으면 자동으로 %pattern% 적용. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 3 tools
Each tool targets a distinct aspect: package search, listing contents, and source retrieval. No overlap exists.
All tools follow a consistent verb_noun pattern using snake_case: get_package_source, list_package_objects, search_packages.
Three tools is lean but sufficient for a read-only Oracle package exploration server. No unnecessary tools.
Covers core read operations: search, list objects, get source. Minor gap in distinguishing package header vs body, but adequate for typical use.