enmotech/yashandb-mcp repository overview

⁠Overview

YashanDB MCP Server acts as an open-source bridge, empowering AI agents to seamlessly interface with YashanDB environments via the Model Context Protocol (MCP). YashanDB is a robust, high-performance database engine compatible with Oracle syntax, designed to handle both transactional (OLTP) and analytical (OLAP) processing efficiently.

By integrating this server, AI assistants gain the capability to:

• Explore database catalogs and schemas
• Run Oracle-dialect SQL commands within a secure environment
• Retrieve and interpret query execution paths
• Assess system performance and health metrics

⁠Features

⁠✅ Implemented Capabilities

• 🗂️ Metadata Discovery: Introspect database objects including schemas, tables, views, and sequences to gather comprehensive structural details
• ⚡ Secure SQL Runtime: Execute Oracle-compatible SQL statements safely, backed by strict syntax validation
• 📊 Plan Analysis: Visualize and understand query optimization strategies using standard execution plan tools
• 🔍 Top SQL Identification: Pinpoint performance bottlenecks by locating the most time-consuming and resource-heavy queries

⁠🚧 Roadmap

• 🏥 Health Diagnostics: Automated checks for index integrity, connection pool usage, and overall system stability
• ⚙️ Index Optimization: AI-driven recommendations for creating or modifying indexes to boost query speed
• 📈 Workload Profiling: Deep-dive analysis of database traffic patterns for holistic optimization
• 🛡️ Advanced Administration: Integration with sophisticated features like Flashback technology for point-in-time recovery and table restoration

⁠Quick Start

⁠For End Users (Docker Image)

The easiest way to use YashanDB MCP Server is via the pre-built Docker image.

1. Pull the image:

   docker pull enmotech/yashandb-mcp
   

   Copy

2. Configure your MCP client:

   Add this to your mcp_config.json (or equivalent):

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

   Copy

Note: The database_name parameter is required for compatibility but ignored by the driver; it has no effect on the connection. You can simply use yasdb