rahgadda_oracledb_mcp_server

rahgadda_oracledb_mcp_server

0
databases

OracleDB MCP Server installs a Model Context Protocol Server to allow LLMs to interact with Oracle Databases, enabling SQL generation and results retrieval. It is configured to provide specific database tables and columns as context.

Overview

  • This project will install MCP - Model Context Protocol Server, that provides configured Oracle Database Table/Columns as context to LLM's.
  • Using this we can enable LLMs to interact with Oracle Database, generate SQL Statements and return results using LLM prompts.

Installation

  • Install package
  • Create .env in a folder with the minimum value of Oracle DB Connection String.
  • Test oracledb_mcp_server server using the specified command.

Configuration

  • List of available environment variables
    • DEBUG: Enable debug logging (optional default is False)
    • COMMENT_DB_CONNECTION_STRING: Oracle DB connection String for comments. (required)
    • DB_CONNECTION_STRING: Oracle DB connection String for execution of queries. (required)
    • TABLE_WHITE_LIST: White Listed table names in list format (required)
    • COLUMN_WHITE_LIST: White Listed table-column names in list format (required)
    • QUERY_LIMIT_SIZE: Default value is 10 records if not provided (optional default is 10)

Contributing

Contributions are welcome. Please feel free to submit a Pull Request.

License

This project is licensed under the terms of the MIT license.