omcp
Verified Safeby fastomop
Overview
Provide a Model Context Protocol server for AI models to query and analyze healthcare data conforming to the OMOP Common Data Model.
Installation
uv run omcpEnvironment Variables
- DB_TYPE
- DB_PATH
- DB_READ_ONLY
- DB_USERNAME
- DB_PASSWORD
- DB_HOST
- DB_PORT
- DB_DATABASE
- DB_TOKEN
- DB_HTTP_PATH
- DB_CATALOG
- DB_SCHEMA
- CDM_SCHEMA
- VOCAB_SCHEMA
- MCP_TRANSPORT
- MCP_HOST
- MCP_PORT
- ENABLE_LOGGING
- LOG_FILE
- DEBUG
- ENABLE_LANGFUSE
- LANGFUSE_PUBLIC_KEY
- LANGFUSE_SECRET_KEY
- LANGFUSE_HOST
- LANGFUSE_TRACE_CONTEXT_FILE
Security Notes
The server directly executes user-provided SQL queries using Ibis, but this is mitigated by a comprehensive `SQLValidator`. The validator enforces read-only access (SELECT statements only), restricts queries to predefined OMOP tables, disallows explicitly excluded tables and columns, and by default blocks sensitive 'source_value' and 'source_concept_id' columns. No hardcoded secrets; environment variables are used for sensitive configurations. Running on `0.0.0.0` for SSE transport might expose the server to the local network; proper firewall configuration is recommended.
Similar Servers
mcp
Facilitates interaction and management of Oracle Cloud Infrastructure (OCI) and MySQL resources through a suite of Model Context Protocol (MCP) servers, including pricing, database operations, AI/ML features, logging, networking, compute, identity, and object storage.
mcp-openapi-server
Exposes OpenAPI endpoints as Model Context Protocol (MCP) tools, enabling Large Language Models (LLMs) to discover and interact with REST APIs through a standardized protocol.
tmcp
Build Model Context Protocol (MCP) servers for AI agents, providing schema-agnostic tools, resources, and prompts, with optional OAuth 2.1 authentication and distributed session management.
awesome-oceanbase-mcp
The project provides a collection of Model Context Protocol (MCP) servers to enable AI assistants to directly interact with OceanBase databases and its ecosystem components for operations, management, and monitoring.