英文 |中文

一个强大的模型上下文协议（MCP）服务器，为大型 Oracle 数据库提供上下文数据库模式信息，使 AI 助手能够理解并处理包含数千个表的数据库。

目录

• 概述
• 特色
• 使用情况
• 与 VSCode Insiders 中的 GitHub Copilot 集成
• 选项1：使用 Docker （推荐）
• 选项2：使用UV（本地安装）
• 本地启动服务器
• 可用工具
• 建筑学
• 连接模式
• 瘦模式（默认）
• 厚模式
• 系统需求
• 性能考量
• 贡献
• 许可证
• 支持

概述

MCP Oracle DB Context服务器解决了处理大型 Oracle 数据库时的一个关键挑战：如何在不让数万张表和关系淹没它们的情况下，为 AI 模型提供准确且相关的数据库模式信息。

通过智能缓存和提供数据库模式信息，该服务器使AI助手能够：

• 按需查找特定的表模式
• 搜索与特定图案匹配的表格
• 理解表关系和外键
• 获取数据库供应商信息

MCP Server - Oracle DB Context

English | 中文

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.

Table of Contents

• Overview
• Features
• Usage
  • Integration with GitHub Copilot in VSCode Insiders
    • Option 1: Using Docker (Recommended)
    • Option 2: Using UV (Local Installation)
  • Starting the Server locally
  • Available Tools
• Architecture
• Connection Modes
  • Thin Mode (Default)
  • Thick Mode
• System Requirements
• Performance Considerations
• Contributing
• License
• Support

Overview

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
• 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
• MCP Integration: Works seamlessly with GitHub Copilot in VSCode, Claude, ChatGPT, and other AI assistants that support MCP
• Read-Only Mode: Default security mode that prevents write operations while allowing full read access

Usage

Integration with GitHub Copilot in VSCode Insiders

To use this MCP server with GitHub Copilot in VSCode Insiders, follow these steps:

1. Install VSCode Insiders

   • Download and install the latest version of VSCode Insiders

2. Install GitHub Copilot Extension

   • Open VSCode Insiders
   • Go to the Extensions marketplace
   • Search for and install “GitHub Copilot”

3. Configure MCP Server

   • Recommended: Using Docker
   • Alternative: Using UV

4. Enable Agent Mode