oracle-sqlplus-mcp
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., "@oracle-sqlplus-mcp Describe the EMPLOYEES table"
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.
oracle-sqlplus-mcp
An MCP (Model Context Protocol) server for Oracle Database using sqlplus as the connection backend. No Oracle Instant Client Node.js bindings required — just a working sqlplus binary.
Prerequisites
sqlplus must be installed and available in
PATH(comes with Oracle Instant Client or full Oracle client)Node.js 18+
Related MCP server: sqlserver-mcp-colossal
Installation
npm install -g oracle-sqlplus-mcp
# or run directly with npx (no install needed):
npx oracle-sqlplus-mcpConnection String Format
username/password@host:port/servicenameExamples:
scott/tiger@localhost:1521/ORCL
myuser/mypass@192.168.1.10:1521/XEPDB1
admin/secret@db.example.com:1521/PRODClaude Desktop Configuration
Add to your claude_desktop_config.json:
{
"mcpServers": {
"oracle": {
"command": "npx",
"args": ["-y", "oracle-sqlplus-mcp"],
"env": {
"ORACLE_CONNECTION": "username/password@host:port/servicename"
}
}
}
}Optional Environment Variables
Variable | Default | Description |
| (required) | Full connection string |
|
| Path to sqlplus binary if not in PATH |
|
| Query timeout in milliseconds |
Custom sqlplus path example
{
"mcpServers": {
"oracle": {
"command": "npx",
"args": ["-y", "oracle-sqlplus-mcp"],
"env": {
"ORACLE_CONNECTION": "scott/tiger@192.168.1.10:1521/ORCL",
"SQLPLUS_PATH": "C:\\oracle\\instantclient_21_9\\sqlplus.exe",
"QUERY_TIMEOUT_MS": "60000"
}
}
}
}Available Tools
Tool | Description |
| Test connectivity and return Oracle version |
| List all schemas with table counts |
| List tables, optionally filtered by schema or name pattern |
| Show columns, data types, nullable, primary keys |
| Fetch sample rows from a table |
| Run any SELECT query |
| Run DDL/DML (INSERT, UPDATE, DELETE, CREATE, etc.) |
| List stored procedures, functions, packages |
Example Prompts
"Test the Oracle connection"
"List all schemas in the database"
"Show me tables in the SCOTT schema"
"Describe the EMPLOYEES table"
"Get 5 sample rows from HR.EMPLOYEES"
"Run this query: SELECT * FROM departments WHERE department_id < 50"
"List all stored procedures in the HR schema"
Troubleshooting
sqlplus: command not found
Set SQLPLUS_PATH to the full path of your sqlplus binary.
ORA-12541: TNS:no listener
Check host, port, and that Oracle listener is running.
ORA-01017: invalid username/password
Verify credentials. Connection string format: user/pass@host:port/service.
SP2-0306: Invalid option
Ensure sqlplus version supports -S silent mode (all modern versions do).
Available Tools
8 toolsdescribe_tableA
Describe the columns, data types and constraints of a table.
Inputs: table_name (required).
execute_ddlA
Execute a DDL or DML statement (CREATE, INSERT, UPDATE, DELETE, ALTER, DROP). Use with caution — changes are committed immediately.
Inputs: statement (required).
execute_queryA
Execute a SQL SELECT query against the Oracle database and return the results. Use standard Oracle SQL syntax. Do NOT include a trailing semicolon — it is added automatically.
Inputs: query (required).
get_table_sampleA
Fetch a sample of rows from a table (default: 10 rows).
Inputs: table_name (required), limit.
list_proceduresA
List stored procedures and functions for a given schema.
Inputs: schema.
list_schemasA
List all schemas (users/owners) in the database that have at least one table.
Inputs: no named parameters.
list_tablesB
List all tables accessible to the current user, optionally filtered by schema/owner.
Inputs: schema, search.
test_connectionA
Test the Oracle connection and return server version info.
Inputs: no named parameters.
Tool Schema Changelog
Recent tool additions, removals, and schema changes observed during successful MCP inspections.
Loading tool schema changelog…
TDQS
Scored across 8 tools
Every tool has a clearly distinct purpose: describing tables, executing DDL, running queries, sampling rows, listing procedures, schemas, tables, and testing connections. No overlapping functionality.
All tool names follow a consistent verb_noun pattern with underscores (e.g., describe_table, list_tables), making them easy to parse and predict.
Eight tools is an appropriate number for a database interaction server, covering essential operations without being overwhelming or too sparse.
The toolset covers core database operations (querying, DDL/DML, listing objects, describing, sampling) but lacks capabilities like viewing procedure source code or managing users, which are minor gaps.
Related MCP Connectors
Text-to-SQL MCP server: read-only queries on PostgreSQL, MySQL and SQL Server with your real schema
Hosted SQL Server MCP server for Claude, ChatGPT and Cursor, with each action switched per account.
Draxlr's remote MCP server connects AI assistants to your SQL databases and dashboards. Explore schemas, run read-only queries, manage saved queries and dashboards, and export results, all with row-level security so each user sees only their own data.
Related MCP Servers
- AlicenseBqualityDmaintenanceMCP server for accessing Oracle databases, enabling schema exploration, query execution, and performance analysis.12MIT
- AlicenseNot gradedqualityDmaintenanceA comprehensive MCP server for SQL Server database operations, enabling CRUD operations, schema exploration, and stored procedure execution through natural language.11 npmMIT
- AlicenseNot gradedqualityDmaintenanceMCP server to connect to Oracle databases and run SQL queries (up to 150 rows) via a single 'query' tool.16 npmMIT
- AlicenseAqualityDmaintenanceMCP server for Oracle Database enabling AI assistants to explore schemas, run queries, write data, and monitor sessions via natural language. Features read-only mode by default and uses Oracle Thin mode for zero-install connectivity.10161 npm2MIT