A Model Context Protocol server that enables Claude to access and interact with Oracle databases through natural language queries.
Model Context Protocol server to access oracle
https://github.com/user-attachments/assets/dc4e377b-4efb-43e6-85fa-93ed852fe21f
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"
}
}
}
}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
This project is licensed under the MIT License - see the LICENSE file for details.
[
{
"description": "Get a list of all tables in the oracle databaseArgs: None",
"name": "list_tables",
"parameters": {
"additionalProperties": false,
"properties": {},
"required": null,
"type": "object"
}
},
{
"description": "Get a description of a table in the oracle databaseArgs: table_name (string): The name of the table to describe",
"name": "describe_table",
"parameters": {
"additionalProperties": false,
"properties": {
"table_name": {
"title": "Table Name",
"type": "string"
}
},
"required": [
"table_name"
],
"type": "object"
}
},
{
"description": "Execute SELECT queries to read data from the oracle databaseArgs: query (string): The SELECT query to execute",
"name": "reqd_query",
"parameters": {
"additionalProperties": false,
"properties": {
"query": {
"title": "Query",
"type": "string"
}
},
"required": [
"query"
],
"type": "object"
}
}
]