oracle_describe_table
Obtener estructura y columnas de una tabla Oracle
LABSCO SUMMARY
Read, write and transaction each get their own tool, so the blast radius is chosen at call time rather than parsed out of the SQL.
oracle_query is the SELECT path and oracle_execute is where INSERT, UPDATE, DELETE and CREATE live, which means a client can be handed the read path without the write path; oracle_transaction sits above them with rollbackOnError for changes that must land together or not at all. Everything is driven by SQL the caller supplies — oracle_list_tables and oracle_describe_table exist so that SQL can be written against the real schema. The configuration is the tell for what this targets: a client library directory and an old-cryptography switch are settings you need for an existing installation, not a new one.
What it is
An Oracle Database server exposing 7 tools: a SELECT path, a write path, a transaction path, table listing and description, a connection health check and a configuration readout.
What you get
- Reads with the output shaped at call time: oracle_query runs a SELECT with maxRows capping the result, formatAsTable rendering it and showMetadata adding column information.
- Writes kept on a separate tool: oracle_execute runs INSERT, UPDATE, DELETE, CREATE and comparable statements, with autoCommit deciding whether the change lands immediately and showDetails reporting what it touched.
- Grouped changes: oracle_transaction takes a list of commands and runs them as a single transaction, with rollbackOnError deciding whether a failure undoes the whole set.
- Schema discovery before writing SQL: oracle_list_tables lists tables for an owner, and oracle_describe_table returns a table's structure and columns.
- The state of the connection itself: oracle_health_check reports whether the database connection is healthy, and oracle_info returns the database's configuration.
Requirements
A reachable Oracle instance and an account on it — ORACLE_HOST, ORACLE_PORT, ORACLE_SERVICE_NAME, ORACLE_USERNAME and ORACLE_PASSWORD — plus ORACLE_CLIENT_LIB_DIR for the Oracle client library location and ORACLE_OLD_CRYPTO for a server that needs the older cryptography.
Setup effort
One command plus credentials — npx @grec0/mcp-oracle-db, then supply credentials
USE CASES
01
Answering a question about production data without changing it
Find the tables, read their columns, then run the SELECT with a row cap so an open-ended query cannot flood the context.
02
Applying a change set that must not land partially applied
Send the statements as a single transaction with rollback on failure, and keep single ad-hoc statements on the separate write call.
03
Checking the connection before blaming the query
Confirm the database is answering and read back the configuration the server is actually connected with.
7 tools
Counted once with only startup setup. Other versions, modes or optional credentials may expose a different list.
oracle_execute
Ejecutar comando SQL en Oracle Database (INSERT, UPDATE, DELETE, CREATE, etc.)
oracle_health_check
Verificar el estado de salud de la conexión Oracle DB
oracle_info
Obtener información de configuración de Oracle Database
oracle_list_tables
Listar tablas en Oracle Database
oracle_query
Ejecutar consulta SQL SELECT en Oracle Database
oracle_transaction
Ejecutar múltiples comandos SQL en una transacción
BEFORE YOU INSTALL
What to know first
Tools you get
7 tools when we connected. oracle_execute runs INSERT, UPDATE, DELETE, DROP and more with no read-only mode or confirmation; only the privileges of the ORACLE_USERNAME account limit it.
Requires
- npx on PATH
- Node.js >=18.0.0
Where it runs
The documented client runs the server on your machine.
CONTEXT COST
Light Standing cost
Rated by the size of the 7 tool definitions that ride along on every turn, not by how many there are
INSTALLATION
Connect your client
Server setup
TERMINAL
npx @grec0/mcp-oracle-dbMCP Clients
Claude Desktop — npx
Windows %APPDATA%\Claude\claude_desktop_config.json · macOS ~/Library/Application Support/Claude/claude_desktop_config.json · Linux ~/.config/claude/claude_desktop_config.json
CLAUDE DESKTOP — NPX · JSON
{
"mcpServers": {
"oracle-db": {
"command": "npx",
"args": [
"@grec0/mcp-oracle-db"
],
"env": {
"ORACLE_HOST": "<YOUR_ORACLE_HOST>",
"ORACLE_PORT": "1521",
"ORACLE_SERVICE_NAME": "<YOUR_ORACLE_SERVICE_NAME>",
"ORACLE_USERNAME": "<YOUR_ORACLE_USERNAME>",
"ORACLE_PASSWORD": "<YOUR_ORACLE_PASSWORD>"
}
}
}
}Only for Oracle 9g and older, which need Thick mode: also set ORACLE_OLD_CRYPTO to true and ORACLE_CLIENT_LIB_DIR to the folder where you extracted Oracle Instant Client 19.26.
