home / mcp / oracle db context mcp server

Oracle DB Context MCP Server

Provides contextual Oracle database schema information to AI assistants with targeted lookups, search, and relationship mapping.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "danielmeppiel-oracle-mcp-server": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "ORACLE_CONNECTION_STRING",
        "-e",
        "TARGET_SCHEMA",
        "-e",
        "CACHE_DIR",
        "-e",
        "THICK_MODE",
        "dmeppiel/oracle-mcp-server"
      ],
      "env": {
        "CACHE_DIR": ".cache",
        "READ_ONLY_MODE": "1",
        "ORACLE_CONNECTION_STRING": "<db-username>/${input:db-password}@<host>:1521/<service-name>"
      }
    }
  }
}

Available tools

get_table_schema

Retrieve detailed schema information for a specific table, including columns, data types, nullability, and relationships.

get_tables_schema

Fetch schemas for multiple tables in a single request for efficiency.

search_tables_schema

Find tables by name pattern and retrieve their schemas.

rebuild_schema_cache

Force a rebuild of the local schema cache; this is resource-intensive.

get_database_vendor_info

Obtain information about the connected Oracle database version and vendor details.

search_columns

Search for tables containing columns that match a specific term.

get_pl_sql_objects

Get information about PL/SQL objects such as procedures, functions, and packages.

get_object_source

Retrieve source code for a PL/SQL object.

get_table_constraints

Retrieve constraints such as primary keys and foreign keys for a table.

get_table_indexes

List all indexes defined on a table.

get_dependent_objects

Find objects that depend on a specified database object.

get_user_defined_types

Fetch information about user-defined types in the schema.

get_related_tables

Show tables related to a specified table via foreign keys.

run_sql_query

Execute a SQL query and return results in a formatted table.