MCP Oracle Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| ORACLE_HOST | Yes | Oracle database host (e.g., 10.10.10.10) | |
| ORACLE_PORT | Yes | Oracle database port (e.g., 1521) | |
| ORACLE_USER | Yes | Oracle database username | |
| ORACLE_DATABASE | Yes | Oracle database name | |
| ORACLE_PASSWORD | Yes | Oracle database 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 | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute_queryC | Ejecuta una consulta SELECT en la base de datos Oracle |
| describe_tableC | Describe la estructura de una tabla |
| list_tablesB | Lista todas las tablas disponibles para el usuario actual |
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 has a clearly distinct purpose: describe_table for table structure, execute_query for running SELECT queries, and list_tables for enumerating available tables. There is no overlap in functionality, making tool selection straightforward.
All tool names follow a consistent verb_noun pattern (describe_table, execute_query, list_tables) with clear, descriptive verbs and nouns. The naming is uniform and predictable throughout the set.
With only 3 tools, the set feels thin for an Oracle database server, lacking essential operations like INSERT, UPDATE, DELETE, or transaction management. While the tools cover basic query and metadata needs, the count is borderline for a database interface.
The toolset is severely incomplete for an Oracle database domain. It only supports SELECT queries and metadata listing, missing critical CRUD operations (create, update, delete), schema modifications, and advanced database management features, leading to significant gaps in agent workflows.