oracle-mcp-server
The MCP Oracle DB Context server is designed to enhance AI assistants' interactions with large Oracle databases by efficiently managing and presenting schema information. Its standout features include intelligent caching, targeted schema lookup, and seamless integration with tools like GitHub Copilot. The server supports advanced Oracle database features through both thin and thick connection modes.
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