Schema | Oracle DB MCP Server

Oracle DB MCP Server

Describes the environment variables required to run the server.

Name	Required	Description	Default
`ORACLE_HOST`	No	Database server hostname
`ORACLE_MODE`	No	Connection mode: readonly or readwrite
`ORACLE_PORT`	No	Port number for the Oracle database	1521
`ORACLE_USER`	No	Database username
`ORACLE_SERVICE`	No	Oracle service name
`ORACLE_PASSWORD`	No	Database password
`ORACLE_MCP_CONFIG`	No	Path to the connections.json configuration file
`ORACLE_CONNECTION_NAME`	No	The name identifier for the Oracle database connection

Features and capabilities supported by this server

Capability	Details
`tools`	{}
`resources`	{}

Functions exposed to the LLM to take actions

Name	Description
list_connectionsA	List all configured Oracle database connections with their status (connected/disconnected) and mode (readonly/readwrite).
test_connectionA	Test connectivity to a named Oracle database connection. Returns database version and schema information if successful.
connectB	Establish a connection to a named Oracle database.
disconnectA	Close a connection to a named Oracle database.
execute_queryA	Execute a SELECT query on an Oracle database. Returns results as a formatted table. Only SELECT statements are allowed.
execute_dmlA	Execute a DML statement (INSERT, UPDATE, DELETE) on an Oracle database. Only works on connections with readwrite mode.
execute_plsqlB	Execute a PL/SQL block or DDL statement (CREATE FUNCTION, CREATE PROCEDURE, etc.). Only works on connections with readwrite mode.
execute_procedureC	Execute a stored procedure with input and output parameters.
list_tablesB	List tables and views in a database schema.
describe_tableA	Get detailed information about a table including columns, constraints, and indexes.
list_proceduresB	List stored procedures, functions, and packages in a schema.
get_procedure_sourceB	Get the source code of a stored procedure, function, or package.
get_procedure_paramsB	Get the parameters of a stored procedure or function.
explain_queryC	Get the execution plan for a SQL query.
commitB	Commit the current transaction on a connection.
rollbackB	Rollback the current transaction on a connection.

Interactive templates invoked by user choice

Name	Description
No prompts

Contextual data attached and managed by the client

Name	Description
No resources

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

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

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