MCP Server - Oracle DB Context
@danielmeppiel
About MCP Server - Oracle DB Context
MCP Server for working with large Oracle databases
Basic information
Config
Add this server to your MCP-compatible client using the configuration below.
{
"mcpServers": {
"db-context": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"ORACLE_CONNECTION_STRING",
"-e",
"TARGET_SCHEMA",
"-e",
"CACHE_DIR",
"dmeppiel/mcp-db-context"
],
"env": {
"ORACLE_CONNECTION_STRING": "user/pass@localhost:1521/mydb",
"TARGET_SCHEMA": "",
"CACHE_DIR": ".cache"
}
}
}
}Tools
No tools detected
We auto-extract tools from the README. The maintainer can list them under a ## Tools heading to populate this section.
Overview
What is MCP Server - Oracle DB Context?
A Model Context Protocol (MCP) server that provides contextual database schema information for large Oracle databases. It enables AI assistants such as GitHub Copilot, Claude, and ChatGPT to understand and work with databases containing thousands of tables by intelligently caching and serving schema data.
How to use MCP Server - Oracle DB Context?
Install and configure it via Docker (recommended) or UV local installation in VSCode Insiders. Set environment variables like ORACLE_CONNECTION_STRING, TARGET_SCHEMA, CACHE_DIR, and optionally READ_ONLY_MODE and THICK_MODE. Start the server locally with uv run main.py. Once connected, AI assistants can call several MCP tools to interact with the database schema.
Key features of MCP Server - Oracle DB Context
- Smart schema caching to minimize database queries
- Targeted schema lookup for specific tables
- Table search by name pattern matching
- Foreign key relationship mapping between tables
- Built specifically for Oracle databases
- Read‑only mode enabled by default for security
Use cases of MCP Server - Oracle DB Context
- AI assistant looks up schema for the EMPLOYEES table on demand
- Developer searches for tables matching a pattern like “customer”
- Analyst retrieves all foreign key relationships of the ORDERS table
- Debugger gets source code of a PL/SQL stored procedure
- Admin runs a read‑only SQL query safely through the AI assistant
FAQ from MCP Server - Oracle DB Context
What is the default security mode?
The server runs in read‑only mode by default (READ_ONLY_MODE=1), allowing only SELECT statements. Write operations (INSERT, UPDATE, DELETE) are blocked unless explicitly disabled by setting READ_ONLY_MODE="0".
What are the runtime requirements?
Python 3.12 or higher and access to an Oracle database. For thick mode, Oracle Instant Client is required. Docker usage includes all dependencies in the container.
How do I provide database credentials?
Set the ORACLE_CONNECTION_STRING environment variable in the format <db-username>/${input:db-password}@<host>:1521/<service-name>. The password is prompted securely via VSCode’s inputs configuration.
What tools are available for AI assistants?
Tools include get_table_schema, search_tables_schema, get_related_tables, run_sql_query, get_pl_sql_objects, get_object_source, get_table_constraints, get_table_indexes, rebuild_schema_cache, and more.
Can I run SQL queries through this server?
Yes, the run_sql_query tool lets you execute SQL queries. In default read‑only mode only SELECT is allowed; set READ_ONLY_MODE="0" to permit write operations.
More Databases MCP servers
Multi Database MCP Server
FreePeakA powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.
Redis
modelcontextprotocolModel Context Protocol Servers
PostgreSQL
modelcontextprotocolModel Context Protocol Servers
mcp_mysql_server
wenb1n-devModel Context Protocol (MCP) server that supports secure interaction with MySQL databases and has anomaly analysis capabilities.更加牛逼！更加好用！不仅止于mysql的增删改查功能； 还包含了数据库异常分析能力；且便于开发者们进行个性化的工具扩展
Dbhub
bytebaseZero-dependency, token-efficient database MCP server for Postgres, MySQL, SQL Server, MariaDB, SQLite.
Comments