oracle-mcp-sdm-with-guardrails
Verified Safeby mofiaboss
Overview
An Oracle Model Context Protocol (MCP) server providing AI agent access to an Oracle database with robust, production-grade query safety features.
Installation
python oracle_mcp_server.pyEnvironment Variables
- ORACLE_HOST
- ORACLE_PORT
- ORACLE_SERVICE_NAME
- ORACLE_USER
- ORACLE_PASSWORD
- JAVA_HOME
- JDBC_JAR_PATH
Security Notes
The server implements comprehensive defense-in-depth, including strict input validation, comment stripping, keyword blocking, query complexity scoring, result set limits, read-only enforcement, rate limiting, connection pooling, circuit breaker, and detailed audit logging. Credentials are securely handled via environment variables. Crucially, it relies on client-side authentication (StrongDM) and Python-side query validation for SQL injection prevention due to the architectural decision of not using Java PreparedStatements for dynamic queries. All critical vulnerabilities identified in a brutal security audit were fixed, earning it an 'Approved for Production Deployment' status.
Similar Servers
archestra
A platform for securely deploying, orchestrating, and managing Model Context Protocol (MCP) servers and their AI-powered tools within an enterprise environment.
lunar
The Lunar MCP Server acts as an HTTP proxy, designed to intercept, analyze, and manage API traffic within a Python environment, applying policies for caching, throttling, queueing, and collecting data for observability.
mcp
This repository provides a collection of Model Context Protocol (MCP) servers to enable AI agents to interact with and manage various Oracle Cloud Infrastructure (OCI) services, Oracle Database, and MySQL databases through natural language.
teradata-mcp-server
A comprehensive Model Context Protocol (MCP) server for Teradata, exposing a rich suite of database administration, data quality, security, SQL optimization, vector store, plotting, backup/restore, feature store, and LLM chat/RAG capabilities as MCP tools for client applications like AI agents.