Oracle-compatible • MCP ready

AI-native bridge to YashanDB

A Model Context Protocol (MCP) server that lets AI assistants explore schemas, run Oracle-style SQL, analyze plans, and check database health across your YashanDB estates.

Fast start

Docker

Run via Docker for isolation. Works with Claude Desktop, Cursor, and any MCP-compatible client.

SQL dialect

Oracle / YashanDB

Core tools

9 live

Health checks

v1 ready

What you can do

Schema discovery, safe SQL execution, plan insights, workload tuning, and health diagnostics.

Metadata

Catalog introspection

List schemas, objects, and details including columns, constraints, and indexes—perfect for quick data mapping.

Runtime

Secure SQL

Run Oracle-compatible statements with strict syntax validation to keep operations predictable and safe.

Explain

Execution plans

Visualize query strategies and costs to spot inefficiencies before they hit production workloads.

Performance

Top SQL

Identify the most expensive queries by time, CPU, IO, or buffer usage to guide tuning priorities.

Index AI

Index recommendations

Analyze ad-hoc queries or recent workloads to generate index suggestions that boost query speed.

Health

Diagnostics v1

Check index integrity, connection pool usage, and overall stability for faster incident triage.

Quick start

For end users: pull the Docker image and point your MCP client to it.

Step 1

Pull the image

docker pull enmotech/yashandb-mcp

Step 2

Configure your MCP client

Add this to your MCP client config (e.g., mcp_config.json):

"yashandb-mcp": {
  "command": "docker",
  "args": [
    "run",
    "-i",
    "--rm",
    "-e", "DATABASE_URI",
    "enmotech/yashandb-mcp"
  ],
  "env": {
    "DATABASE_URI": "yashandb://username:password@host:port/database_name"
  }
}

Note: the database_name is required for compatibility but ignored by the driver; you can simply use yasdb.

Playground

Try the hosted demo MCP server instantly—no Docker or local setup required.

Remote demo

Use this in your MCP client

Add the following to your MCP client configuration:

"yashandb-mcp-remote": {
  "url": "https://yashandb-mcp.kamusis.me/sse"
}

The demo server is long-running and ready for quick tests.

Why YashanDB

Oracle-compatible, HTAP-ready, and built for enterprise scale with high availability.

Compatibility

Oracle syntax first

Full Oracle SQL support ensures your existing skills and tooling work as-is.

Scale

HTAP architecture

Handles OLTP and OLAP together so you ship fewer moving parts.

Reliability

Resilience built-in

Clustering, replication, and enterprise-grade security keep data safe.