広告掲載
MCP.so
ログイン

MCP Server - Oracle DB Context

@danielmeppiel

リポジトリ

基本情報

カテゴリ

データベース

ライセンス

MIT

トランスポート

stdio

作者

danielmeppiel

MCP Server - Oracle DB Context について

MCP Server for working with large Oracle databases

#db-context#oracle-db#mcp-server

MCP Server - Oracle DB Context の設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

{
  "mcpServers": {
    "db-context": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "ORACLE_CONNECTION_STRING",
        "-e",
        "TARGET_SCHEMA",
        "-e",
        "CACHE_DIR",
        "dmeppiel/mcp-db-context"
      ],
      "env": {
        "ORACLE_CONNECTION_STRING": "user/pass@localhost:1521/mydb",
        "TARGET_SCHEMA": "",
        "CACHE_DIR": ".cache"
      }
    }
  }
}

MCP Server - Oracle DB Context のツール

ツール一覧はまだありません

この掲載には表示できるツール一覧がまだありません。サーバーにツールがないという意味ではありません。対応機能はプロジェクトのドキュメントをご確認ください。

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

What is MCP Server - Oracle DB Context?

A Model Context Protocol (MCP) server that provides contextual database schema information for large Oracle databases. It enables AI assistants such as GitHub Copilot, Claude, and ChatGPT to understand and work with databases containing thousands of tables by intelligently caching and serving schema data.

How to use MCP Server - Oracle DB Context?

Install and configure it via Docker (recommended) or UV local installation in VSCode Insiders. Set environment variables like ORACLE_CONNECTION_STRING, TARGET_SCHEMA, CACHE_DIR, and optionally READ_ONLY_MODE and THICK_MODE. Start the server locally with uv run main.py. Once connected, AI assistants can call several MCP tools to interact with the database schema.

Key features of MCP Server - Oracle DB Context

  • Smart schema caching to minimize database queries
  • Targeted schema lookup for specific tables
  • Table search by name pattern matching
  • Foreign key relationship mapping between tables
  • Built specifically for Oracle databases
  • Read‑only mode enabled by default for security

Use cases of MCP Server - Oracle DB Context

  • AI assistant looks up schema for the EMPLOYEES table on demand
  • Developer searches for tables matching a pattern like “customer”
  • Analyst retrieves all foreign key relationships of the ORDERS table
  • Debugger gets source code of a PL/SQL stored procedure
  • Admin runs a read‑only SQL query safely through the AI assistant

よくある質問

1

What is the default security mode?

The server runs in read‑only mode by default (`READ_ONLY_MODE=1`), allowing only SELECT statements. Write operations (INSERT, UPDATE, DELETE) are blocked unless explicitly disabled by setting `READ_ONLY_MODE="0"`.

2

What are the runtime requirements?

Python 3.12 or higher and access to an Oracle database. For thick mode, Oracle Instant Client is required. Docker usage includes all dependencies in the container.

3

How do I provide database credentials?

Set the `ORACLE_CONNECTION_STRING` environment variable in the format `<db-username>/${input:db-password}@<host>:1521/<service-name>`. The password is prompted securely via VSCode’s `inputs` configuration.

4

What tools are available for AI assistants?

Tools include `get_table_schema`, `search_tables_schema`, `get_related_tables`, `run_sql_query`, `get_pl_sql_objects`, `get_object_source`, `get_table_constraints`, `get_table_indexes`, `rebuild_schema_cache`, and more.

5

Can I run SQL queries through this server?

Yes, the `run_sql_query` tool lets you execute SQL queries. In default read‑only mode only SELECT is allowed; set `READ_ONLY_MODE="0"` to permit write operations.

コメント

「データベース」の他のコンテンツ

ClickHouse MCP Server

ClickHouse

Connect ClickHouse to your AI assistants.

818

Postgres Mcp

crystaldba

Postgres MCP Pro provides configurable read/write access and performance analysis for you and your AI agents.

3.0K

nuzur

nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi

Fund Momentum MCP Server

schneidavie

Fund Momentum MCP Server — VC intelligence for AI assistants. 1000+ active VC funds, live investor signals, AI-powered startup matching.

Dbhub

bytebase

Zero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.

3.1K
広告掲載