Oracle Database (xe) Mcp Connector With Self Healing Retries
Overview The QualiGenAI Oracle Bridge is a resilient Model Context Protocol (MCP) server that connects AI agents to Oracle Databases (XE/PDB). It is specifically engineered to handle the common stability issues found in containerized database environments.
Key Features
🔄 Self-Healing Connection Logic: The server includes an automated retry mechanism (configurable via RETRY_LIMIT) that allows it to stay active while waiting for Oracle Docker containers or remote services to become healthy.
🧠 Intelligent SQL Error Feedback: When an AI agent generates an invalid query (e.g., ORA-00942), the server appends a context-aware "TIP" to the error message, guiding the agent to use list_oracle_tables to self-correct.
🏗️ Enterprise-Grade Architecture: Built with TypeScript for full type safety, featuring a clean separation between source (src) and compiled (dist) code for reliable production deployments.
Available Tools
execute_query: Securely runs SQL commands and returns structured JSON results.
list_oracle_tables: Discovers schema metadata, including table names and structures.
Server Config
{
"mcpServers": {
"qualigenai-oracle": {
"command": "node",
"args": [
"--no-warnings",
"./dist/index.js"
],
"env": {
"DB_USER": "YOUR_USER",
"DB_PASSWORD": "YOUR_PASSWORD",
"DB_CONNECTION_STRING": "localhost:1521/FREEPDB1",
"ENABLE_SELF_HEALING": "true",
"RETRY_LIMIT": "5"
}
}
}
}