Oracle MCP Server
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DEBUG | No | Enable debug logging | False |
| MAX_ROWS_EXPORT | No | Maximum rows for export operations | 10000 |
| QUERY_LIMIT_SIZE | No | Maximum rows returned per query | 100 |
| TABLE_WHITE_LIST | No | Comma-separated list of allowed tables | |
| COLUMN_WHITE_LIST | No | Comma-separated list of allowed columns | |
| DB_CONNECTION_STRING | Yes | Oracle connection string |
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
Server capabilities have not been inspected yet.
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute_queryA | Execute a SQL query against the Oracle database. Only SELECT, DESCRIBE, and EXPLAIN PLAN statements are allowed for safety. |
| describe_tableB | Get detailed information about a table including columns, data types, and constraints |
| list_tablesB | List all tables in the database with metadata |
| list_viewsC | List all views in the database |
| list_proceduresC | List all stored procedures, functions, and packages |
| explain_queryC | Get the execution plan for a SQL query to analyze performance |
| generate_sample_queriesC | Generate sample SQL queries for a given table to help with exploration |
| export_query_resultsC | Export query results in various formats (JSON, CSV) |
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 8 tools
Each tool has a clearly distinct purpose with no ambiguity: describe_table focuses on table structure, execute_query runs queries, explain_query analyzes performance, export_query_results handles output formatting, generate_sample_queries creates examples, list_procedures lists procedures/functions/packages, list_tables lists tables, and list_views lists views. The descriptions make it easy for an agent to differentiate between them.
All tools follow a consistent verb_noun pattern with snake_case throughout: describe_table, execute_query, explain_query, export_query_results, generate_sample_queries, list_procedures, list_tables, and list_views. This predictable naming scheme makes the tool set easy to navigate and understand.
With 8 tools, the server is well-scoped for database interaction and exploration. Each tool earns its place by covering distinct aspects like query execution, metadata listing, analysis, and export, without being overly sparse or bloated. This count aligns well with the server's purpose of providing safe Oracle database access.
The tool set covers core database exploration and query tasks effectively, including listing resources, describing structures, executing and analyzing queries, and exporting results. A minor gap exists in the lack of tools for modifying data or schema (e.g., INSERT, UPDATE, CREATE TABLE), but this is likely intentional for safety, and agents can still perform read-only operations and analysis without dead ends.