mcp -oracle

This MCP server provides access to Oracle data via the Model Context Protocol using a Python-based server run through the UV package manager. The server is started with the uvx command and an environment variable ORACLE_CONNECTION_STRING must be supplied to connect to your Oracle database. Once running, Claude Desktop (or your configured client) can send MCP requests to the server-name mcp-server-oracle to query models or perform Oracle-backed tasks as defined by the server implementation. The rapid configuration shown in the quickstart demonstrates how to wire the server into Claude Desktop so you can interact with Oracle data through the MCP interface and leverage the server's capabilities for querying, analysis, or transformation of data.

Prerequisites:

• Python 3.12+ installed on your system
• UV (package manager) available and functional
• Claude Desktop if you plan to integrate with Claude (optional for testing)

Installation steps:

1. Install Python 3.12+ from the official Python site or your OS package manager.
2. Install UV (the package manager used in the quickstart) according to its documentation. This may involve commands such as:
   • pipx install uvx (or the recommended installation method for uv)
3. Install the MCP server package (if applicable) or ensure the mcp-server-oracle package is available in your environment.
4. Confirm the server can be started with the provided configuration:
   • Use uvx to register or run the MCP server as shown in the quickstart configuration.
5. Prepare Oracle access by setting the connection string in the environment variable ORACLE_CONNECTION_STRING as shown in the example. Ensure the Oracle database is reachable from your host.
6. If using Claude Desktop, add the server configuration to claude_desktop_config.json (MacOS path or Windows path as described in the quickstart).

Example sequence (summary):

• Ensure Python 3.12+ is installed.
• Install UV/uvx following its installation guide.
• Configure the MCP server in your environment with the uvx command and env var for Oracle.
• Test the connection and MCP requests from your client (e.g., Claude Desktop).

Tips and notes:

• Ensure the ORACLE_CONNECTION_STRING is correctly formatted and has network access to the Oracle database.
• If you encounter connection failures, verify firewall rules, Oracle listener configuration, and that the service_name matches the database instance you intend to access.
• When using Claude Desktop, place the JSON config in the correct claude_desktop_config.json file location for your OS as shown in the quickstart.
• This MCP server uses Python 3.12; ensure your runtime environment matches the expected Python version to avoid compatibility issues.
• If you need to support multiple Oracle databases, consider duplicating the server configuration with distinct environment variables and connection strings.