Oracle DB Context

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

python

GitHub Stars

python

Language

6 months ago

First Indexed

2 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

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.

Built by

VeilStrat

AI signals for GTM teams