Oracle DB MCP Server
This server does not currently have a deployable release on Glama. Follow the repository's setup instructions to install and configure it for your MCP client, including any required credentials and local dependencies.
Oracle DB MCP Server
A Model Context Protocol (MCP) server that lets AI assistants (e.g. GitHub Copilot) query the Richardson Oracle databases directly.
Prerequisites
VS Code
The pre-built
oracle-mcp.exebinary from the GitHub Releases page
Related MCP server: Database Lookup Protocol (DLP)
1. Install the exe
Go to the Releases page and download the latest
oracle-mcp.exerelease asset.Save it to
C:\development\tools\oracle-mcp.exe(create thetoolsfolder if needed). The configuration below expects this exact path.
2. Configure GitHub Copilot (VS Code)
Open VSCode and press
Ctrl+Shift+Pthen selectMCP:Open User Configuration.Paste the following config inside the json file and modify the credentials as needed.
{
"servers": {
"ri-oracle": {
"type": "stdio",
"command": "C:/development/tools/oracle-mcp.exe",
"args": [],
"env": {
"ORACLE_USER": "<your-pccs-username>", //eg. 'dshah'
"ORACLE_PASSWORD": "<your-pccs-password>", // if you can guess this, please submit a PR to have me change my password.
"ORACLE_CONNECT_STRING": "pccs.richardson.ca", //can modify to point to a different layer if needed
"ORACLE_USER_PIFS": "<your-pifs-username>",
"ORACLE_PASSWORD_PIFS": "<your-pifs-password>",
"ORACLE_CONNECT_STRING_PIFS": "pifs.richardson.ca" //can modify to point to a different layer if needed
}
}
}
}3. Start and verify
Click Start on the
ri-oracleserver. You should the status as running now.
Ask Copilot: "Give me 5 products from 240 table" - You know what to expect.
Feel free to reach out to Me if you have any issue.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
This server cannot be deployed
Maintenance
Related MCP Connectors
Query Postgres, MySQL, SQL Server, Oracle, BigQuery, ClickHouse and Redshift from your AI client.
Safe, read-only Postgres and MySQL access for AI agents. Audit log + column-level controls.
Work with your database from AI tools: ask, export, approved changes, and scheduled jobs.
Query 40 databases from Claude, ChatGPT, or Cursor — on any device. Read-only, encrypted, audited.
Related MCP Servers
- AlicenseAqualityDmaintenanceEnables GitHub Copilot and other LLMs to execute read-only SQL queries against Oracle databases with secure connection pooling and schema introspection capabilities.2110 npm5AGPL 3.0
- AlicenseNot gradedqualityDmaintenanceProvides AI assistants with read-only access to inspect database schemas, preview data, and run safe queries across PostgreSQL, MySQL, MongoDB, and SQL Server. It enables AI tools to understand database structures and relationships automatically to generate more accurate code.9 npm7MIT
- FlicenseCqualityDmaintenanceEnables AI assistants to analyze and query SQL Server databases, including schema discovery, health checks, and data retrieval.10-
- AlicenseNot gradedqualityDmaintenanceEnables AI assistants to safely query and explore SQL Server and PostgreSQL databases with read-only access, supporting schema discovery, relationship exploration, and query execution.3MIT