Skip to main content
Glama
shopsmartai

mcp-oracle-dba

by shopsmartai
OverviewSchemaRelated ServersScoreDiscussions
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

Capabilities

Features and capabilities supported by this server

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

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/shopsmartai/mcp-oracle-dba'

If you have feedback or need assistance with the MCP directory API, please join our Discord server