Skip to main content
Glama

Oracle MCP Server

by samscarrow

Server Configuration

Describes the environment variables required to run the server.

NameRequiredDescriptionDefault

No arguments

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
execute_query

Execute a SQL query on the Oracle database

list_tables

List tables from specified schema or all accessible schemas

describe_table

Get table structure including columns, data types, and constraints

get_table_indexes

Get indexes for a specific table

get_table_constraints

Get constraints (primary keys, foreign keys, unique, check) for a table

list_schemas

List all schemas in the database

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/samscarrow/oracle-mcp-server'

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