OracleDB MCP Server

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault
DEBUGNoEnable debug loggingFalse
QUERY_LIMIT_SIZENoDefault value is 10 records if not provided10
TABLE_WHITE_LISTYesWhite Listed table names in list format ["table1", "table2"]
COLUMN_WHITE_LISTYesWhite Listed table-column names in list format ["table.column1", "table.column2"]
DB_CONNECTION_STRINGYesOracle DB connection String for execution of queries
COMMENT_DB_CONNECTION_STRINGYesOracle DB connection String for comments

Schema

Prompts

Interactive templates invoked by user choice

NameDescription

No prompts

Resources

Contextual data attached and managed by the client

NameDescription

No resources

Tools

Functions exposed to the LLM to take actions

NameDescription

No tools

ID: g0rbd0qg0w