Database

Provides read-only access to Oracle data via MCP, enabling Copilot and other LLMs to run safe SQL queries and inspect schema.

typescript

GitHub Stars

typescript

Language

7 months ago

First Indexed

3 months ago

Catalog Refreshed

Documentation & install

Readme and setup notes from the catalogue, plus a client-ready config you can copy for your MCP host.

Installation

Add the following to your MCP client configuration file.

Configuration

View docs

{
  "mcpServers": {
    "tannerpace-mcp-oracle-database": {
      "command": "mcp-database-server",
      "args": [],
      "env": {
        "ORACLE_USER": "your_readonly_user",
        "ORACLE_PASSWORD": "your_password",
        "ORACLE_POOL_MAX": "10",
        "ORACLE_POOL_MIN": "2",
        "QUERY_TIMEOUT_MS": "30000",
        "MAX_ROWS_PER_QUERY": "1000",
        "ORACLE_CONNECTION_STRING": "localhost:1521/XEPDB1"
      }
    }
  }
}

You can safely run read-only SQL queries against an Oracle database from GitHub Copilot or other large language models by using this MCP server. It provides a dedicated, secure, read-only channel, with schema introspection, query auditing, and strict row limits to keep resource usage under control.

How to use

Configure your MCP client to connect to the local stdio MCP server exposed by the Oracle database MCP server. You will set up a process that the client can spawn and communicate with over standard input and output. The server reads from a read-only Oracle user and logs all queries for auditing. To perform queries, you will invoke the provided tools from your MCP client, such as requesting the database schema or executing read-only SELECT statements.

How to install

Prerequisites: you need Node.js version 18 or higher. You also need access to an Oracle Database with a read-only user that allows read access to the necessary schemas.

Install the MCP Oracle Database server globally using npm.

Available tools

query_database

Executes a read-only SQL SELECT statement against the Oracle database and returns the result set, honoring configured row limits and timeouts.

get_database_schema

Fetches schema information, such as tables and columns, to help you explore the database structure before composing queries.

Built by

VeilStrat

AI signals for GTM teams