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.
The MCP Oracle DB Context server solves a critical challenge when working with very large Oracle databases: how to provide AI models with accurate, relevant database schema information without overwhelming them with tens of thousands of tables and relationships. By intelligently caching and serving database schema information, this server allows AI assistants to look up specific table schemas on demand, search for tables that match specific patterns, understand table relationships and foreign keys, and get database vendor information.
Features
- Smart Schema Caching: Builds and maintains a local cache of your database schema to minimize database queries
- Targeted Schema Lookup: Retrieve schema for specific tables without loading the entire database structure
- Table Search: Find tables by name pattern matching
- Relationship Mapping: Understand foreign key relationships between tables
- Oracle Database Support: Built specifically for Oracle databases
Tools
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
