QualigenAI Oracle Bridge (MCP)
OfficialClick on "Deploy Server".
Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state.
In the chat, type
@followed by the MCP server name and your instructions, e.g., "@QualigenAI Oracle Bridge (MCP) show all tables in the HR schema"
That's it! The server will respond to your query, and you can continue using it as needed.
Here is a step-by-step guide with screenshots.
QualigenAI Oracle Bridge (MCP) 🚀
An advanced Model Context Protocol (MCP) server that enables Claude Desktop to act as an autonomous Oracle Database Administrator and Data Analyst.
Unlike standard SQL tools, this bridge allows for Agentic workflows, where the AI explores the schema, self-corrects SQL errors, and handles complex joins through natural language.
đź§ Agentic Intelligence Features
Autonomous Schema Discovery: Claude identifies tables and relationships without manual mapping.
Self-Healing Queries: Automatically interprets Oracle
ORA-errors and rewrites SQL to fix issues.Complex Data Handling: Native support for
CLOBdata types and multi-tableJOINoperations.Automatic Commits: Built-in
autoCommitfor persistent DDL (CREATE/DROP) and DML (INSERT/UPDATE) operations.
Related MCP server: oracle-sqlplus-mcp
🛠️ Setup Instructions
1. Prerequisites
Node.js (v18+)
Docker (for Oracle XE)
Claude Desktop
2. Database Setup
Run the Oracle XE container using the following command:
docker run -d --name qualigenai-db -p 1521:1521 -e ORACLE_PASSWORD='YOURPASSWORD' gvenzl/oracle-xe
3. Environment Configuration
Create a .env file in the root directory:
Code snippet
DB_USER=system
DB_PASSWORD=<YOUR_PASSWORD>
DB_CONNECTION_STRING=localhost:1521/FREEPDB1
4. Build the Bridge
Run these commands to install dependencies and compile the TypeScript code:
Bash
npm install
npm run build
🖥️ Claude Integration
Add this configuration to your claude_desktop_config.json (located at %APPDATA%\Claude\claude_desktop_config.json on Windows):
JSON
{
"mcpServers": {
"qualigenai-oracle": {
"command": "node",
"args": ["C:/ABS/path/to/your/project/dist/index.js"],
"env": {
"DB_USER": "system",
"DB_PASSWORD": "<YOUR_PASSWORD>",
"DB_CONNECTION_STRING": "localhost:1521/FREEPDB1"
}
}
}
}
Disclaimer: This project is an independent open-source tool and is not affiliated with, sponsored by, or endorsed by Oracle Corporation. "Oracle" is a registered trademark of Oracle Corporation.Available Tools
2 toolsexecute_queryC
Execute any SQL command.
Inputs: sql (required).
list_oracle_tablesB
Lists all tables in the Oracle database.
Inputs: no named parameters.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 2 tools
The two tools have clearly distinct purposes: one lists database tables, the other executes arbitrary SQL commands. Although execute_query could technically be used to list tables, the descriptions and intended use cases are unambiguous.
Both tool names follow a consistent verb_noun pattern using snake_case: 'list_oracle_tables' and 'execute_query'. This makes the toolset predictable and easy to navigate.
With only two tools, the server feels slightly thin, but the scope is narrow—a database bridge. The pair of listing tables and executing queries covers the core needs, and each tool serves a distinct role, so the count is reasonable.
The execute_query tool accepts any SQL command, enabling full CRUD, DDL, and metadata operations. list_oracle_tables provides a convenient starting point for exploration. Together, they cover the domain without dead ends.
Maintenance
Related MCP Connectors
MCP server unifying ERPs, CRMs, APIs and knowledge base for Claude, ChatGPT and Gemini.
Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Hosted Amazon Seller and Vendor MCP server for Claude, ChatGPT, Cursor, Codex, Gemini, Copilot.
Related MCP Servers
- AlicenseBqualityDmaintenanceA Model Context Protocol server that enables Claude to access and interact with Oracle databases through natural language queries.32MIT
- AlicenseAqualityDmaintenanceAn MCP server that connects to Oracle databases using sqlplus, enabling SQL queries, schema exploration, and DDL/DML execution through natural language.8MIT
- AlicenseAqualityDmaintenanceA database-agnostic MCP server that enables natural language queries to your database through Claude or Copilot, automatically writing and executing SQL.810 npmMIT
- AlicenseAqualityDmaintenanceMCP server for Oracle Database enabling AI assistants to explore schemas, run queries, write data, and monitor sessions via natural language. Features read-only mode by default and uses Oracle Thin mode for zero-install connectivity.10152 npm2MIT