{"id":"officeworkplace-mcp-oracledb-server","name":"mcp-oracledb-server","homepage":null,"repo_url":"https://github.com/officeWorkPlace/mcp-oracledb-server","category":"api-gateway","subcategories":[],"tags":["mcp","oracle","database-tools","spring-boot","jdbc","admin","vector-search","ai-operations"],"what_it_does":"An MCP (Model Context Protocol) server that connects to an Oracle database and exposes a large set of tools for database/schema/user/table management, analytics and performance diagnostics (e.g., AWR/ADDM/DBMS_STATS), and (optionally) Oracle 23c vector search and AI-assisted content/query operations. It also supports a REST mode for testing alongside the default stdio MCP transport.","use_cases":["AI-assisted Oracle database exploration (list schemas/tables, inspect metadata)","Admin workflows for creating users/schemas and managing privileges (grant/revoke, lock/unlock, profiles/password policies)","Executing controlled SQL/PLSQL operations and generating/explaining execution plans","Performance analysis and tuning support via Oracle features (AWR/ADDM/SQL tuning advisor)","Vector search operations on Oracle 23c (vector similarity/clustering/index management) when enabled"],"not_for":["Unattended or internet-exposed production deployments without network protections and strong credential management","Use as a general-purpose database proxy for arbitrary user input without strict allowlisting/validation","Environments requiring strict compliance evidence (SOC2/HIPAA/etc.) or documented formal security controls beyond configuration snippets"],"best_when":"You control the Oracle environment and credentials, and you want an agent-facing tool layer (MCP stdio, optionally REST for testing) to perform structured Oracle tasks and diagnostics.","avoid_when":"You cannot restrict tool capabilities (e.g., DDL/DML, PL/SQL execution) or you cannot enforce authentication/authorization and safe input handling; also avoid when documentation of MCP error semantics and operational guarantees is insufficient for your risk tolerance.","alternatives":["Oracle REST Data Services / APEX with custom APIs","Direct JDBC/REST custom backend with OpenAPI and your own tool wrappers","Existing MCP database connectors (MongoDB or other DB-specific MCP servers)","Airbyte/Fivetran-style ingestion tools for analytics use cases (where CDC/ETL is acceptable)"],"af_score":39.0,"security_score":45.0,"reliability_score":21.2,"package_type":"mcp_server","discovery_source":["github"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T20:02:47.360528+00:00","interface":{"has_rest_api":true,"has_graphql":false,"has_grpc":false,"has_mcp_server":true,"mcp_server_url":null,"has_sdk":false,"sdk_languages":[],"openapi_spec_url":null,"webhooks":false},"auth":{"methods":["MCP stdio transport (credentials passed via environment variables as shown in README)","REST mode (curl examples; README does not document auth scheme)"],"oauth":false,"scopes":false,"notes":"README shows Oracle username/password via environment variables for the MCP server, but does not document an agent-facing authentication/authorization model for the server itself. Tool execution likely uses the provided DB credentials; scope granularity for tool permissions is not described."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"No SaaS pricing is indicated; this appears to be a self-hosted open-source-style server requiring Oracle licensing and infrastructure."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":39.0,"security_score":45.0,"reliability_score":21.2,"mcp_server_quality":70.0,"documentation_accuracy":45.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":35.0,"rate_limit_clarity":10.0,"tls_enforcement":80.0,"auth_strength":45.0,"scope_granularity":20.0,"dependency_hygiene":45.0,"secret_handling":35.0,"security_notes":"README includes TLS/SSL configuration snippets (tcps/Oracle wallet/truststore) suggesting encryption is supported, but it does not document enforcement defaults or how the server authenticates agents/requests. Credentials are provided as environment variables in examples, which is better than hardcoding, but there is no documented secret redaction/logging policy. Tool surface area appears highly privileged (DDL/DML/PLSQL and administrative actions), so least-privilege and allowlisting are critical.","uptime_documented":0.0,"version_stability":40.0,"breaking_changes_history":20.0,"error_recovery":25.0,"idempotency_support":"false","idempotency_notes":"README lists many DDL/DML/PLSQL tools but does not document idempotency behavior or how retries should be performed safely.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["Tools include destructive/privileged operations (drop/delete/truncate/create/lock/unlock); agents need strict guardrails","REST endpoints shown for testing may not reflect MCP tool semantics or security controls","Database operations may be non-idempotent; retries could lead to duplicate objects or unintended data changes"]}}