oracle-mcp-server

oracle-mcp-server

41
databasesdeveloper_tools

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.

Overview

The MCP Oracle DB Context server addresses the challenge of managing large Oracle databases by providing AI models with precise schema information while avoiding data overload. It enables AI assistants to look up table schemas, search tables, understand relationships, and more.

Features

  • Smart Schema Caching
  • Targeted Schema Lookup
  • Table Search
  • Relationship Mapping
  • Oracle Database Support
  • MCP Integration with tools like GitHub Copilot, Claude, and ChatGPT

Usage

Integration with GitHub Copilot in VSCode Insiders

  1. Install VSCode Insiders and GitHub Copilot extension.
  2. Configure MCP Server using Docker or UV options.
  3. Enable Agent Mode in Copilot chat.

Starting the Server locally

  • Use uv run main.py for running the server directly.
  • Use mcp-cli for development and testing.

Available Tools

  • get_table_schema
  • get_tables_schema
  • search_tables_schema
  • rebuild_schema_cache
  • get_database_vendor_info
  • search_columns
  • get_pl_sql_objects
  • get_object_source
  • get_table_constraints
  • get_table_indexes
  • get_dependent_objects
  • get_user_defined_types
  • get_related_tables