oracle-mcp-server

oracle-mcp-server

3.5

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.

A powerful Model Context Protocol (MCP) server that provides contextual database schema information for large Oracle databases, enabling AI assistants to understand and work with databases containing thousands of tables.

get_table_schema

Get detailed schema information for a specific table

get_tables_schema

Get schema information of multiple tables at once

search_tables_schema

Search the table by name pattern and retrieve its pattern

rebuild_schema_cache

Forced rebuild mode cache

get_database_vendor_info

Get connected Oracle database version and schema information

search_columns

Search for a table containing a column of specific terms

get_pl_sql_objects

Get PL/SQL object information

get_object_source

Search the source code of PL/SQL objects

get_table_constraints

Get all constraints of the table

get_table_indexes

Get all indexes of the table

get_dependent_objects

Find all objects that depend on the specified database object

get_user_defined_types

Get information about user-defined types in the database

get_related_tables

Get all tables related to the specified table by foreign keys