oracle-mcp-server
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