execute_queryLABSCO SUMMARY
A safe, read-only Oracle client for an assistant, scoped to querying rather than writing.
The three tools follow the shape of exploring a database — list the tables, describe the one you want, then query it — and the server only permits SELECT, so an agent can answer questions from Oracle without any path to modifying the data.
What it is
A Node server that exposes an Oracle database over MCP with three read-oriented tools, restricted to SELECT queries so the database cannot be changed by accident.
What you get
- execute_query runs a SELECT query against Oracle
- describe_table returns a table's structure
- list_tables lists the tables available to the connected user
Requirements
Node and access to an Oracle database, with the connection details — user, password, host, port, and database — supplied as environment values. Install it from its own repository; the server runs over stdio.
Setup effort
Build from source — git clone https://github.com/YrsonHTM/mcp-oracle-server.git
USE CASES
01
Exploring an Oracle schema
list_tables shows the accessible tables and describe_table reveals a table's columns, so a query targets real structure.
02
Answering a question from the database
execute_query runs a SELECT and returns the rows, restricted to reads by design.
3 tools
Listed in project docs. Your client may show a different list.
describe_tablelist_tablesBEFORE YOU INSTALL
What to know first
Tools you get
3 tools named in the project's documentation. Only SELECT queries are allowed, so nothing can modify the database.
Requires
- node on PATH
- Node.js >= 18
- Access to an Oracle database
- ORACLE_HOST, ORACLE_PORT, ORACLE_DATABASE, ORACLE_USER and ORACLE_PASSWORD in your environment — server.js builds its connection from all five
Where it runs
The documented client runs the server on your machine.
INSTALLATION
Connect your client
You clone this one yourself.
Server setup
TERMINAL
git clone https://github.com/YrsonHTM/mcp-oracle-server.git
cd mcp-oracle-server
npm install
npm startMCP Clients
Cursor
CURSOR · JSON
{
"mcpServers": {
"oracle-db": {
"command": "node",
"args": [
"<YOUR_PATH_TO_MCP_ORACLE_SERVER>/server.js"
],
"env": {
"ORACLE_HOST": "<YOUR_ORACLE_HOST>",
"ORACLE_PORT": "<YOUR_ORACLE_PORT>",
"ORACLE_DATABASE": "<YOUR_ORACLE_DATABASE>",
"ORACLE_USER": "<YOUR_ORACLE_USER>",
"ORACLE_PASSWORD": "<YOUR_ORACLE_PASSWORD>"
}
}
}
}
