Skip to main content
Glama
shopsmartai

mcp-oracle-dba

by shopsmartai
OverviewSchemaSourceRelated ServersDiscussionsAdmin
Python
Remote

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
ORA_DSNYesEasy-Connect or TNS-format DSN
ORA_USERYesDB user (should be read-only)
MCP_MAX_ROWSNoHard cap on rows returned by run_select100
ORA_PASSWORDYesDB password
MCP_AUDIT_LOGNoJSON-line audit log path./audit.log
MCP_COLUMN_DENYLISTNoColumn-name substrings to redactSSN,SALARY,TAX_ID,PASSWORD,…
MCP_SCHEMA_ALLOWLISTNoComma-separated schemas allowed for describe_tableAPPS,APPLSYS,SYS,RAGAPP
MCP_STATEMENT_TIMEOUT_SECONDSNoServer-side statement timeout5

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

CapabilityDetails
tools
{
  "listChanged": false
}
prompts
{
  "listChanged": false
}
resources
{
  "subscribe": false,
  "listChanged": false
}
experimental
{}

Tools

Functions exposed to the LLM to take actions

NameDescription
list_schemasA

List schemas the MCP server is allowed to query.

Schemas are configured via MCP_SCHEMA_ALLOWLIST. This is a
metadata tool — no DB call required.
describe_tableA

Return column metadata for SCHEMA.TABLE.

Errors if `schema` is not in the configured allowlist.
run_selectA

Run a SELECT or WITH query against Oracle.

Guardrails:
  - Only SELECT / WITH statements allowed
  - DDL, DML, PL/SQL blocks, DBMS_/UTL_/SYS. calls are rejected
  - Result row count is capped (see MCP_MAX_ROWS)
  - PII-named columns (SSN, SALARY, PASSWORD, …) are auto-redacted
  - Server-side statement timeout enforced

Returns a list of column-name dicts.
explain_planB

Return Oracle EXPLAIN PLAN output for a SELECT query.

top_sqlA

Top SQL by elapsed time from v$sql within the last N minutes.

Useful for "what's been slow recently?" investigations from Claude Desktop.

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Deploy Server
One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

TDQS

A4/5.0

Scored across 5 tools

Disambiguation5/5

Each tool has a distinct purpose: listing schemas, describing table columns, executing arbitrary SELECT queries, explaining query plans, and showing top SQL by elapsed time. No overlaps.

Naming Consistency5/5

All tool names follow a consistent lowercase snake_case verb_noun pattern (describe_table, explain_plan, list_schemas, run_select, top_sql).

Tool Count5/5

5 tools is well-scoped for an Oracle DBA assistant covering metadata, query execution, performance analysis, and plan analysis.

Completeness4/5

Covers core DBA query workflow: schema discovery, table structure, arbitrary queries, explain plans, and top SQL. Missing list tables in a schema but that can be done via run_select.

Maintenance

ActivityInactive
ResponsivenessNo issues

Resources