Skip to main content
Glama
smith-nathanh

Oracle MCP Server

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
DEBUGNoEnable debug loggingFalse
MAX_ROWS_EXPORTNoMaximum rows for export operations10000
QUERY_LIMIT_SIZENoMaximum rows returned per query100
TABLE_WHITE_LISTNoComma-separated list of allowed tables
COLUMN_WHITE_LISTNoComma-separated list of allowed columns
DB_CONNECTION_STRINGYesOracle 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

NameDescription
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

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

TDQS

A3.5/5.0

Scored across 8 tools

Disambiguation5/5

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.

Naming Consistency5/5

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.

Tool Count5/5

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.

Completeness4/5

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.