% npx @modelcontextprotocol/create-server oracle-server
(node:2763) ExperimentalWarning: CommonJS module /opt/homebrew/lib/node_modules/npm/node_modules/debug/src/node.js is loading ES Module /opt/homebrew/lib/node_modules/npm/node_modules/supports-color/index.js using require().
Support for loading ES Module in require() is an experimental feature and might change at any time
(Use `node --trace-warnings ...` to show where the warning was created)
? What is the name of your MCP server? oracle
? What is the description of your server? My first Oracle MCP Server
? Would you like to install this server for Claude.app? No
✔ MCP server created successfully!
Next steps:
cd oracle-server
npm install
npm run build # or: npm run watch
npm link # optional, to make available globally
%
| #!/usr/bin/env node | |
| /* | |
| * Example MCP server for Oracle Database | |
| * | |
| * REST Enabled SQL of Oracle REST Data Services must be enabled. | |
| * This server submit SELECT statement to Oracle Database via HTTP/REST. | |
| * | |
| * Oracle MCP server is based on PostgreSQL example: | |
| * https://github.com/modelcontextprotocol/servers/blob/main/src/postgres/index.ts | |
| * | |
| * claude_desktop_config.json | |
| * ----- | |
| * 1st arg: MCP server's index.js | |
| * 2nd arg: Endpoont for REST enabled SQL of Oracle Database. | |
| * 3rd arg: database user/schema to connect (REST enabled). | |
| * 4th arg: password for 3rd arg database user/schema | |
| * ----- | |
| { | |
| "mcpServers": { | |
| "oracle": { | |
| "command": "node", | |
| "args": [ | |
| "/Users/ynakakoshi/Documents/oracle-server/build/index.js", | |
| "https://[HOSTNAME]/ords/[REST alias]/_/sql", | |
| "schema_name", | |
| "password" | |
| ] | |
| } | |
| } | |
| } | |
| */ | |
| import { Server } from "@modelcontextprotocol/sdk/server/index.js"; | |
| import { StdioServerTransport } from "@modelcontextprotocol/sdk/server/stdio.js"; | |
| import { | |
| CallToolRequestSchema, | |
| ListResourcesRequestSchema, | |
| ListToolsRequestSchema, | |
| ReadResourceRequestSchema, | |
| } from "@modelcontextprotocol/sdk/types.js"; | |
| interface TableItem { | |
| table_name: string; | |
| } | |
| const fetchDataWithBasicAuth = async ( | |
| url:string, | |
| data:string, | |
| username:string, | |
| password:string | |
| ) => { | |
| // Encode the credentials for Basic Authentication in Base64. | |
| const credentials = btoa(`${username}:${password}`); | |
| try { | |
| const response = await fetch(url, { | |
| method: 'POST', | |
| headers: { | |
| 'Authorization': `Basic ${credentials}`, | |
| 'Content-Type': 'application/sql', | |
| 'Accept': 'application/json' | |
| }, | |
| body: data | |
| }); | |
| // Throw Error on response is not ok. | |
| if (!response.ok) { | |
| throw new Error(`HTTP error! status: ${response.status}`); | |
| } | |
| // Parse JSON response. | |
| const jsonData = await response.json(); | |
| return jsonData; | |
| } catch (error) { | |
| console.error('request error:', error); | |
| throw error; | |
| } | |
| }; | |
| const server = new Server( | |
| { | |
| name: "oracle-server", | |
| version: "0.1.0", | |
| }, | |
| { | |
| capabilities: { | |
| resources: {}, | |
| tools: {}, | |
| }, | |
| }, | |
| ); | |
| const args = process.argv.slice(2); | |
| if (args.length === 0) { | |
| console.error("Please provide a database URL as a command-line argument"); | |
| process.exit(1); | |
| } | |
| const databaseUrl = args[0]; | |
| const username = args[1]; | |
| const password = args[2]; | |
| const resourceBaseUrl = new URL(databaseUrl); | |
| resourceBaseUrl.protocol = 'https:'; | |
| resourceBaseUrl.username = ''; | |
| resourceBaseUrl.password = ''; | |
| server.setRequestHandler(ListResourcesRequestSchema, async () => { | |
| let result; | |
| try { | |
| result = await fetchDataWithBasicAuth(databaseUrl, | |
| "SELECT table_name FROM user_tables", | |
| username, | |
| password | |
| ); | |
| // console.error('ListResourcesRequestSchema', result); | |
| const tables = result.items[0].resultSet.items; | |
| // console.error('Tables', tables); | |
| return { | |
| resources: tables.map((item:TableItem) => ({ | |
| uri: `oracle:///${item.table_name}/${username}`, | |
| mimeType: "application/json", | |
| name: `"${item.table_name}" schema "${username}"`, | |
| })), | |
| }; | |
| } catch (error) { | |
| return { | |
| content: { | |
| mimeType: "text/plain", | |
| text: 'Error List: ' + JSON.stringify(result, null, 2) | |
| } | |
| } | |
| throw error; | |
| } | |
| }); | |
| server.setRequestHandler(ReadResourceRequestSchema, async (request) => { | |
| const url = new URL(request.params.uri); | |
| const pathComponents = url.pathname.split("/"); | |
| const schema = pathComponents.pop(); | |
| const tableName = pathComponents.pop(); | |
| let result; | |
| try { | |
| result = await fetchDataWithBasicAuth(databaseUrl, | |
| `SELECT column_name, data_type FROM user_tab_columns where table_name = '${tableName}'`, | |
| username, | |
| password | |
| ); | |
| // console.error('ReadResourceRequestSchema', result); | |
| const textResult = JSON.stringify(result.items[0].resultSet.items, null, 2); | |
| // console.error('Columns', textResult); | |
| return { | |
| contents: [ | |
| { | |
| uri: tableName, | |
| mimeType: "application/json", | |
| text: textResult, | |
| }, | |
| ], | |
| }; | |
| } catch (error) { | |
| return { | |
| content: { | |
| mimeType: "text/plain", | |
| text: 'Error Read: ' + JSON.stringify(result, null, 2) | |
| } | |
| } | |
| throw error; | |
| } | |
| }); | |
| server.setRequestHandler(ListToolsRequestSchema, async () => { | |
| return { | |
| tools: [ | |
| { | |
| name: "query", | |
| description: "Run a read-only SQL query", | |
| inputSchema: { | |
| type: "object", | |
| properties: { | |
| sql: { type: "string" }, | |
| }, | |
| }, | |
| }, | |
| ], | |
| }; | |
| }); | |
| server.setRequestHandler(CallToolRequestSchema, async (request) => { | |
| if (request.params.name === "query") { | |
| const sql = request.params.arguments?.sql as string; | |
| let result; | |
| try { | |
| result = await fetchDataWithBasicAuth(databaseUrl, | |
| sql, | |
| username, | |
| password | |
| ); | |
| // console.error('ReadResourceRequestSchema', result); | |
| const textResult = JSON.stringify(result.items[0].resultSet.items, null, 2); | |
| // console.error('SQL Result', textResult); | |
| return { | |
| content: [{ type: "text", text: `${textResult}` }], | |
| isError: false, | |
| }; | |
| } catch (error) { | |
| return { | |
| content: { | |
| mimeType: "text/plain", | |
| text: 'Error Call: ' + JSON.stringify(result, null, 2) | |
| } | |
| }; | |
| throw error; | |
| } | |
| } | |
| throw new Error(`Unknown tool: ${request.params.name}`); | |
| }); | |
| async function runServer() { | |
| const transport = new StdioServerTransport(); | |
| await server.connect(transport); | |
| } | |
| runServer().catch(console.error); |
% npm install
(node:2127) ExperimentalWarning: CommonJS module /opt/homebrew/lib/node_modules/npm/node_modules/debug/src/node.js is loading ES Module /opt/homebrew/lib/node_modules/npm/node_modules/supports-color/index.js using require().
Support for loading ES Module in require() is an experimental feature and might change at any time
(Use `node --trace-warnings ...` to show where the warning was created)
> oracle-server@0.1.0 prepare
> npm run build
> oracle-server@0.1.0 build
> tsc && node -e "require('fs').chmodSync('build/index.js', '755')"
added 17 packages, and audited 18 packages in 1s
1 package is looking for funding
run `npm fund` for details
found 0 vulnerabilities
% npm run build
> oracle-server@0.1.0 build
> tsc && node -e "require('fs').chmodSync('build/index.js', '755')"
% npm link
(node:2373) ExperimentalWarning: CommonJS module /opt/homebrew/lib/node_modules/npm/node_modules/debug/src/node.js is loading ES Module /opt/homebrew/lib/node_modules/npm/node_modules/supports-color/index.js using require().
Support for loading ES Module in require() is an experimental feature and might change at any time
(Use `node --trace-warnings ...` to show where the warning was created)
added 1 package, and audited 3 packages in 673ms
found 0 vulnerabilities
%
{
"mcpServers": {
"oracle": {
"command": "node",
"args": [
"/Users/username/Documents/oracle-server/build/index.js",
"https://********-apexdev.adb.us-ashburn-1.oraclecloudapps.com/ords/mcp/_/sql",
"スキーマ名",
"パスワード"
]
}
}
}
