Schema | Oracle MCP Server

Oracle MCP Server

Describes the environment variables required to run the server.

Name	Required	Description	Default
`DEBUG`	No	Enable debug logging	False
`MAX_ROWS_EXPORT`	No	Maximum rows for export operations	10000
`QUERY_LIMIT_SIZE`	No	Maximum rows returned per query	100
`TABLE_WHITE_LIST`	No	Comma-separated list of allowed tables
`COLUMN_WHITE_LIST`	No	Comma-separated list of allowed columns
`DB_CONNECTION_STRING`	Yes	Oracle connection string

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.

Server capabilities have not been inspected yet.

Functions exposed to the LLM to take actions

Name	Description
execute_queryA	Execute a SQL query against the Oracle database. Only SELECT, DESCRIBE, and EXPLAIN PLAN statements are allowed for safety.
describe_tableB	Get detailed information about a table including columns, data types, and constraints
list_tablesB	List all tables in the database with metadata
list_viewsC	List all views in the database
list_proceduresC	List all stored procedures, functions, and packages
explain_queryC	Get the execution plan for a SQL query to analyze performance
generate_sample_queriesC	Generate sample SQL queries for a given table to help with exploration
export_query_resultsC	Export query results in various formats (JSON, CSV)

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

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