MCP Oracle Server
Click 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., "@MCP Oracle Server show me the top 5 customers by total purchase amount"
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.
mcp-server-oracle
Model Context Protocol server to access oracle
Demos
https://github.com/user-attachments/assets/dc4e377b-4efb-43e6-85fa-93ed852fe21f
Related MCP server: Oracle MCP Server
Quickstart
To try this in Claude Desktop app, add this to your claude config files:
{
"mcpServers": {
"mcp-server-oracle": {
"command": "uvx",
"args": [
"mcp-server-oracle"
],
"env": {
"ORACLE_CONNECTION_STRING": "username/password@hostname:password/service_name"
}
}
}
}Prerequisites
UV (pacakge manager)
Python 3.12+
Claude Desktop
Installation
Claude Desktop Configuration
Add the server configuration to your Claude Desktop config file:
MacOS: ~/Library/Application\ Support/Claude/claude_desktop_config.json
Windows: %APPDATA%/Claude/claude_desktop_config.json
Contributing
Fork the repository from mcp-server-oracle
Create your feature branch
Commit your changes
Push to the branch
Open a Pull Request
License
This project is licensed under the MIT License - see the LICENSE file for details.
Available Tools
3 toolsdescribe_tableB
Get a description of a table in the oracle database"
Args:
table_name (string): The name of the table to describe
Inputs: table_name (required). Returns: result
list_tablesB
Get a list of all tables in the oracle database
Args:
None
Inputs: no named parameters. Returns: result
reqd_queryB
Execute SELECT queries to read data from the oracle database
Args:
query (string): The SELECT query to execute
Inputs: query (required). Returns: result
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 3 tools
Each tool has a clearly distinct purpose: describe_table provides metadata about a specific table, list_tables enumerates all tables, and reqd_query executes SELECT queries to read data. There is no overlap in functionality, and an agent can easily distinguish between them based on their descriptions.
Two tools follow a consistent verb_noun pattern (describe_table, list_tables), but the third tool (reqd_query) deviates with an unconventional name that is less readable and mixes styles. This inconsistency reduces predictability, though the overall set remains understandable.
With only 3 tools, the server feels thin for an Oracle database interface, as it lacks essential operations like INSERT, UPDATE, DELETE, or transaction management. While the tools cover basic read and metadata functions, the count is borderline low for the apparent scope of database interaction.
The tool surface is significantly incomplete for an Oracle database server. It only supports describing tables, listing tables, and executing SELECT queries, missing critical CRUD operations (create, update, delete), schema modifications, and other database management tasks. This will cause agent failures when trying to perform common database workflows.
Maintenance
Related MCP Connectors
Claude, connected to your own Oracle EPM. Each person as themselves, every call checked and logged.
Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
MCP server unifying ERPs, CRMs, APIs and knowledge base for Claude, ChatGPT and Gemini.
Hosted PostgreSQL MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Related MCP Servers
- AlicenseNot gradedqualityDmaintenanceA Model Context Protocol Server that enables LLMs to interact with Oracle Database by providing database tables/columns as context, allowing users to generate SQL statements and retrieve results using natural language prompts.39 PyPI35Apache 2.0
- AlicenseNot gradedqualityNot gradedmaintenanceA Model Context Protocol server that provides contextual Oracle database schema information, enabling AI assistants to understand and work with large databases containing thousands of tables.2MIT
- AlicenseAqualityCmaintenanceExecute SQL queries, browse schemas, and analyze Oracle Database performance through an AI-compatible Model Context Protocol server.84MIT
- FlicenseNot gradedqualityDmaintenanceA Model Context Protocol server for managing Oracle Cloud Infrastructure services, enabling LLMs to interact with compute instances, storage, identity, and databases through natural language.2-