O

OracleDB

Provides a bridge to Oracle Database, enabling dynamic table and column discovery, secure query exec...

139 views
1 installs
Updated Nov 21, 2025
Not audited
Provides a bridge to Oracle Database, enabling dynamic table and column discovery, secure query execution, and metadata retrieval through natural language interactions for data analysts and developers.
  1. Obtain Oracle Database Credentials

    • You will need the following from your Oracle Database administrator or team:
      • Database username
      • Database password
      • IP address or hostname of your Oracle instance
      • Port number (commonly 1521)
      • Service name of the DB
  2. Decide Tables and Columns to Allow

    • Make a list of table names you want the server to access (as a comma-separated list).
    • For each table, decide which columns you want to allow (as a comma-separated list in the format TABLE.COLUMN).
  3. Fill in the Connection Strings

    • Format your connection strings as:
      oracle+oracledb://USERNAME:PASSWORD@IP:PORT/?service_name=SERVICENAME
      
    • Replace USERNAME, PASSWORD, IP, PORT, SERVICENAME with your specific values.
  4. Prepare the Environment Configuration

    • You will be asked for the following ENV values in the FastMCP connection interface:
      • DB_CONNECTION_STRING: The main Oracle DB connection string.
      • COMMENT_DB_CONNECTION_STRING: Another Oracle DB connection string (can use the same as above if both operations allow same access).
      • TABLE_WHITE_LIST: Comma-separated list of allowed table names, for example: ACCOUNTS,CUS_ACC_RELATIONS,CUSTOMERS
      • COLUMN_WHITE_LIST: Comma-separated list of allowed fully-qualified columns, for example: ACCOUNTS.ACC_AAD_ID,CUS_ACC_RELATIONS.CAR_CUS_ID,CUS_ACC_RELATIONS.CAR_AAD_ID,CUSTOMERS.CUS_ID
      • (Optional) DEBUG: Set to True or False.
      • (Optional) QUERY_LIMIT_SIZE: Maximum number of records to return in a query (default is 10).
  5. Use the "Install Now" Button

    • When prompted, fill in all the above values in the FastMCP connection interface using the text fields provided after clicking the "Install Now" button.

Note: All credentials and whitelists are obtained and set manually; there is no "token" or "key" generated automatically from Oracle or the package. Contact your OracleDB admin for missing credentials.

Quick Start

View on GitHub

More for Database

View All →

Report Issue

Thank you! Your issue report has been submitted successfully.