oracle-mcp-server

samscarrow/oracle-mcp-server

3.3

If you are the rightful owner of oracle-mcp-server and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.

The Oracle MCP Server is a Model Context Protocol server designed to provide flexible access to Oracle databases for AI assistants like Claude, supporting multi-schema querying and comprehensive database introspection.

Tools

Functions exposed to the LLM to take actions

execute_query

Execute any SQL query with parameter binding and automatic conversion.

list_tables

List database tables with schema filtering and pattern matching.

describe_table

Get table structure details including columns, types, and constraints.

get_table_indexes

View table indexes with details on types, uniqueness, and columns.

get_table_constraints

View table constraints including primary keys, foreign keys, and unique constraints.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources