Oracle MCP Server
未申請MCP Server for working with large Oracle databases
インストール
uv pip install -e .未申請リスティング
このMCPサーバーはあなたのものですか？
このリスティングは公開情報から自動的にインデックスされました。申請することで、ページの編集、互換性の設定、成長ツールのアンロックができます。2分以内に完了します。
このサーバーを申請するツール（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.