Oracle
Get a list of all tables in the oracle database Args: None
What is Oracle?
Oracle is a Model Context Protocol (MCP) server that allows AI assistants like Claude, Cursor, and VS Code to get a list of all tables in the oracle database args: none
Get a list of all tables in the oracle database Args: None
This server falls under the Databases category on MCPgee, the world's largest MCP server directory with 33,000+ servers.
Features
- list_tables
- describe_table
- reqd_query
Use Cases
Maintainer
Works with
Installation
NPM
npx -y oracle-mcp-serverManual Installation
npx -y oracle-mcp-serverConfiguration
Configuration Details
claude_desktop_config.json
Performance
Response Metrics
Resource Usage
How to Set Up and Use Oracle
The Oracle MCP Server is a read-safe connector that gives AI agents structured access to Oracle Database schemas and data through 13 specialized tools covering table discovery, schema inspection, PL/SQL object retrieval, constraint analysis, and SQL query execution. It connects via the standard Oracle connection string format and defaults to read-only mode to prevent accidental data modification. Database administrators, developers, and data analysts use it to let AI assistants explore complex Oracle schemas and generate accurate queries without granting unrestricted database access.
Prerequisites
- Node.js 18+ (for npx) or Python 3.10+ with UV (for local installation)
- Oracle Database connection string with appropriate read permissions
- Optional: Oracle Instant Client libraries if using THICK_MODE for certain connection types
- An MCP-compatible client such as Claude Desktop or Cursor
Run via npx (quickest start)
The fastest way to start is with npx. Set your Oracle connection string as an environment variable and run the package directly.
ORACLE_CONNECTION_STRING="myuser/mypassword@localhost:1521/FREEPDB1" npx -y oracle-mcp-serverAdd to Claude Desktop config
Edit ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) or %APPDATA%/Claude/claude_desktop_config.json (Windows) to add the server permanently.
{
"mcpServers": {
"oracle": {
"command": "npx",
"args": ["-y", "oracle-mcp-server"],
"env": {
"ORACLE_CONNECTION_STRING": "myuser/mypassword@localhost:1521/FREEPDB1",
"TARGET_SCHEMA": "HR",
"READ_ONLY_MODE": "1"
}
}
}
}Install locally with UV (alternative)
For development or custom environments, clone the repository and install with UV for faster dependency resolution.
git clone https://github.com/danielmeppiel/oracle-mcp-server.git
cd oracle-mcp-server
uv venv
source .venv/bin/activate
uv pip install -e .
uv run main.pyConfigure Oracle Thick Mode (if needed)
Some Oracle Database versions or connection types require the thick client. Set THICK_MODE=1 and optionally point to your Oracle Instant Client installation.
ORACLE_CONNECTION_STRING="myuser/mypassword@localhost:1521/FREEPDB1" THICK_MODE=1 ORACLE_CLIENT_LIB_DIR=/opt/oracle/instantclient_21 npx -y oracle-mcp-serverVerify schema access
Once connected, ask your MCP client to list all tables. The server caches schema metadata for faster repeated queries; you can rebuild the cache with the rebuild_schema_cache tool.
Oracle Examples
Client configuration
Full JSON config for Claude Desktop. TARGET_SCHEMA restricts exploration to a single schema; READ_ONLY_MODE=1 prevents any INSERT/UPDATE/DELETE.
{
"mcpServers": {
"oracle": {
"command": "npx",
"args": ["-y", "oracle-mcp-server"],
"env": {
"ORACLE_CONNECTION_STRING": "myuser/mypassword@localhost:1521/FREEPDB1",
"TARGET_SCHEMA": "HR",
"READ_ONLY_MODE": "1",
"CACHE_DIR": ".cache"
}
}
}
}Prompts to try
These prompts exercise the 13 Oracle MCP tools from basic schema exploration to PL/SQL analysis.
- "Show me the schema for the EMPLOYEES table"
- "Find all tables that might be related to customers and show their schemas"
- "Which tables have columns related to customer_id?"
- "Show me all stored procedures that start with CUSTOMER_"
- "What constraints are defined on the ORDERS table?"
- "What Oracle database version are we running?"
- "Run a query to count orders grouped by status for the last 30 days"Troubleshooting Oracle
Connection fails with 'ORA-12541: TNS:no listener' or similar TNS errors
Verify the ORACLE_CONNECTION_STRING format: 'username/password@host:port/service_name'. Confirm the Oracle listener is running on the target host and that firewall rules allow port 1521.
DPI-1047: Cannot locate a 64-bit Oracle Client library
Set THICK_MODE=1 and install Oracle Instant Client from oracle.com. Set ORACLE_CLIENT_LIB_DIR to the directory containing libclntsh.so (Linux) or oci.dll (Windows). Alternatively keep THICK_MODE unset (thin mode) if your Oracle DB version supports it.
AI queries return wrong table names or stale schema information
The server caches schema metadata to speed up queries. Ask Claude to 'rebuild the schema cache' which triggers the rebuild_schema_cache tool, or delete the .cache directory and restart the server.
Frequently Asked Questions about Oracle
What is Oracle?
Oracle is a Model Context Protocol (MCP) server that get a list of all tables in the oracle database args: none It connects AI assistants to external tools and data sources through a standardized interface.
How do I install Oracle?
Install via npm with the command: npx -y oracle-mcp-server. Then add the server configuration to your AI client's JSON config file (e.g., claude_desktop_config.json or .cursor/mcp.json).
Which AI clients work with Oracle?
Oracle works with all major MCP-compatible AI clients including Claude Desktop, Claude Code, Cursor, VS Code (GitHub Copilot), Windsurf, and Cline.
Is Oracle free to use?
Yes, Oracle is open source and available under the MIT license. You can use it freely in both personal and commercial projects.
Oracle Alternatives — Similar Databases Servers
Looking for alternatives to Oracle? Here are other popular databases servers you can use with Claude, Cursor, and VS Code.
Excelize
★ 20.6kGo language library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
MCP Toolbox for Databases
★ 15.3kOpen source MCP server specializing in easy, fast, and secure tools for Databases.
DBHub
★ 2.8kA universal database gateway MCP server that enables AI assistants to connect to and query multiple databases (PostgreSQL, MySQL, MariaDB, SQL Server, SQLite) with support for schema exploration, SQL execution, and secure connections via SSH tunnels.
Tabularis
★ 2.1kA lightweight, cross-platform database client for developers. Supports MySQL, PostgreSQL and SQLite. Hackable with plugins. Built for speed, security, and aesthetics.
Postgres AI Guide
★ 1.7kMCP server and Claude plugin for Postgres skills and documentation. Helps AI coding tools generate better PostgreSQL code.
Anyquery
★ 1.7k🏎️ 🏠 ☁️ - Query more than 40 apps with one binary using SQL. It can also connect to your PostgreSQL, MySQL, or SQLite compatible database. Local-first and private by design.
Browse More Databases MCP Servers
Explore all databases servers available in the MCPgee directory. Each server includes setup guides for Claude, Cursor, and VS Code.
Set Up Oracle in Your Editor
Choose your AI client for step-by-step setup instructions.
Quick Config Preview
Add this to your claude_desktop_config.json or .cursor/mcp.json
Ready to use Oracle?
Browse our complete directory of 33,000+ MCP servers, read setup guides for your editor, and start building with the Model Context Protocol.