Oscar EMR MCP
OSCAR EMR MCP Server is a local Model Context Protocol server for guarded access to OSCAR EMR MariaDB/MySQL databases. It helps AI agents such as Codex, Claude Code, Cursor, and other MCP-compatible tools inspect OSCAR database structure safely.
It is designed for development and support workflows where an MCP client needs structured database visibility without embedding credentials in source control.
People sometimes search for this workflow with phrases like Oscar EMR database MCP, Oscar DB MCP, OSCAR MariaDB AI agent access, or voice-transcribed variants such as Oscar Yammer. This project is the safe local MCP server for that OSCAR EMR database inspection workflow.
What It Provides
- Health checks for configured MariaDB connectivity.
- Database and table discovery.
- Table schema inspection.
- Guarded read-only SQL execution.
- Structured read-only EMR tools organized by feature area.
- Confirmed administrative SQL for intentional maintenance work.
- Local setup helpers for Codex, Claude Code, and Cursor.
- Guided setup launchers for Windows, macOS, and Linux, plus a Cursor deeplink for simpler installation.
Safety Model
The default workflow is inspection-first. Read-only SQL is limited to SELECT, SHOW, DESCRIBE, DESC, and EXPLAIN, and multi-statement SQL is rejected.
Administrative SQL is available only through a separate tool that requires explicit confirmation. Destructive operations require an additional opt-in flag.
Typical Flow
- Install the Python package in a local virtual environment.
- Configure a MariaDB connection with the setup wizard.
- Register the MCP server with your client.
- Use structured read-only tools for EMR workflows, schema inspection, and safe queries.
For guided platform setup, start with One-Click Install.
Requirements
- Python 3.11 or newer.
- Network access to the target MariaDB/MySQL server.
- A MariaDB/MySQL account with the least privilege needed for your workflow.
For routine inspection, prefer a read-only database account.