O

OracleDB

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

309 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.

How to Install OracleDB

Install OracleDB MCP server with one click through FastMCP. Choose your preferred AI development tool below:

Claude Desktop

Click "Claude Desktop" in Quick Start

Cursor IDE

Click "Cursor IDE" in Quick Start

VS Code

Click "VS Code" in Quick Start

Alternatives to OracleDB

Looking for similar MCP servers? Browse other servers in the same categories on FastMCP, or check out the similar servers listed above.

Quick Start

View on GitHub

More for Database

View All →

Report Issue

Thank you! Your issue report has been submitted successfully.

Stay ahead of the MCP ecosystem

Get the top new MCP servers, trending tools, and dev tips delivered weekly. Free, no spam, unsubscribe anytime.

Join 2,847 developers. We send one email per week.