Oracle MCP Server
UnclaimedMCP Server for working with large Oracle databases
Install
uv pip install -e .Unclaimed listing
Is this your MCP server?
This listing was auto-indexed from the public record. Claim it to edit the page, set compatibility and unlock growth tools. Takes under two minutes.
Claim this serverTools (14)
get_database_vendor_info
Get information about the connected Oracle database version and schema.
get_dependent_objects
Find all objects that depend on a specified database object.
get_object_source
Retrieve the source code for a PL/SQL object. Useful for debugging and understanding database logic.
get_pl_sql_objects
Get information about PL/SQL objects like procedures, functions, packages, triggers, etc.
get_related_tables
Get all tables that are related to a specified table through foreign keys, showing both incoming and outgoing relationships.
get_table_constraints
Get all constraints (primary keys, foreign keys, unique constraints, check constraints) for a table.
get_table_indexes
Get all indexes defined on a table, helpful for query optimization.
get_table_schema
Get detailed schema information for a specific table including columns, data types, nullability, and relationships.
get_tables_schema
Get schema information for multiple tables at once. More efficient than calling gettableschema multiple times.
get_user_defined_types
Get information about user-defined types in the database.
rebuild_schema_cache
Force a rebuild of the schema cache. Use sparingly as this is resource-intensive.
run_sql_query
Execute a SQL query and return the results in a formatted table.
search_columns
Search for tables containing columns that match a specific term. Useful when you know what data you need but aren't sure which tables contain it.
search_tables_schema
Search for tables by name pattern and retrieve their schemas.