A
securityA
licenseA
qualityAllows AI assistants to list tables, read data, and execute SQL queries through a controlled interface, making database exploration and analysis safer and more structured.
Last updated -
880
MIT License
Supports configuration via environment variables stored in .env files, allowing secure storage of Oracle database connection credentials.
Supports integration with Claude Desktop on macOS through specific configuration file paths.
Runs as a Node.js application, with configuration for launching the server via Node.js runtime.
Provides parameter conversion from PostgreSQL-style ($1) to Oracle-style (:1) for compatibility with PostgreSQL query formats.
Oracle MCP Server
A Model Context Protocol (MCP) server that provides flexible access to Oracle databases for AI assistants like Claude. Supports querying across multiple schemas and comprehensive database introspection.
Features
Execute SQL queries with parameter binding
List tables across multiple schemas or filter by specific schema
Describe table structures with multi-schema support
View indexes and constraints across schemas
Multiple Oracle authentication methods
Automatic parameter conversion (PostgreSQL style to Oracle)
SQL injection prevention via bind variables
Audit logging for security monitoring
Installation
npm install
Configuration
Environment Variables
Create a .env file with your Oracle connection details. Choose one of these methods:
Method 1: Easy Connect String
ORACLE_CONNECTION_STRING=hostname:1521/service_name
ORACLE_USER=your_username
ORACLE_PASSWORD=your_password
Method 2: TNS Name
ORACLE_TNS_NAME=ORCL
ORACLE_USER=your_username
ORACLE_PASSWORD=your_password
Method 3: Individual Components
ORACLE_HOST=localhost
ORACLE_PORT=1521
ORACLE_SERVICE_NAME=ORCL # or ORACLE_SID=ORCL
ORACLE_USER=your_username
ORACLE_PASSWORD=your_password
Optional settings:
ORACLE_DEFAULT_SCHEMA=HR # Default schema if different from user
Usage with Claude Desktop
Add to your Claude Desktop configuration file:
macOS: ~/Library/Application Support/Claude/claude_desktop_config.json
Windows: %APPDATA%\Claude\claude_desktop_config.json
{
"mcpServers": {
"oracle": {
"command": "node",
"args": ["/path/to/oracle-mcp/src/index.js"],
"env": {
"ORACLE_CONNECTION_STRING": "hostname:1521/service_name",
"ORACLE_USER": "your_username",
"ORACLE_PASSWORD": "your_password"
}
}
}
}
Alternatively, use npx if you publish the package:
{
"mcpServers": {
"oracle": {
"command": "npx",
"args": ["-y", "oracle-mcp-server"],
"env": {
"ORACLE_CONNECTION_STRING": "hostname:1521/service_name",
"ORACLE_USER": "your_username",
"ORACLE_PASSWORD": "your_password"
}
}
}
}
Usage with Claude Code
For Claude Code, add to ~/.claude.json:
{
"mcpServers": {
"oracle": {
"type": "stdio",
"command": "node",
"args": ["/path/to/oracle-mcp/src/index.js"],
"env": {
"ORACLE_CONNECTION_STRING": "hostname:1521/service_name",
"ORACLE_USER": "your_username",
"ORACLE_PASSWORD": "your_password"
}
}
}
}
After updating the configuration, restart Claude Desktop or Claude Code.
Available Tools
execute_query - Execute any SQL query
Supports parameter binding
Auto-converts PostgreSQL-style parameters ($1) to Oracle (:1)
Returns rows, rowCount, and metadata
list_tables - List database tables
Filter by specific schema or show all accessible schemas
Filter by pattern (with % wildcards)
Shows schema name, table name, row count, and last analyzed date
describe_table - Get table structure
Column names, types, sizes
Nullable constraints
Default values
Works across all accessible schemas or filter by specific schema
get_table_indexes - View table indexes
Index types and uniqueness
Indexed columns
Status information
Shows schema name for each index
get_table_constraints - View table constraints
Primary keys, foreign keys
Unique and check constraints
Referenced tables
Shows schema name for each constraint
list_schemas - List all accessible schemas
Security
All queries use bind variables to prevent SQL injection
Connections are created per-query (no persistent pools)
Comprehensive audit logging with timestamps and duration
Environment variables keep credentials secure
Supports both read-only and read-write operations
Requirements
Node.js 18+
Oracle Database (any version)
Network access to Oracle database
License
MIT
hybrid server
The server is able to function both locally and remotely, depending on the configuration or use case.
Provides flexible access to Oracle databases for AI assistants like Claude, supporting SQL queries across multiple schemas with comprehensive database introspection capabilities.
- Features
- Installation
- Configuration
- Usage with Claude Desktop
- Usage with Claude Code
- Available Tools
- Security
- Requirements
- License
Related Resources
Related MCP Servers
- AsecurityFlicenseAqualityProvides tools for AI assistants to explore and interact with MariaDB databases, allowing them to list databases, view tables, inspect schema definitions, and query data.Last updated -42
- -securityFlicense-qualityProvides Claude Desktop with secure access to multiple database connections, allowing users to query MySQL, PostgreSQL, SQLite, and SQL Server databases directly through natural language.Last updated -
- -securityAlicense-qualityProvides Claude with direct access to databases including SQLite, SQL Server, PostgreSQL, and MySQL, enabling execution of SQL queries and table management through natural language.Last updated -5531MIT License