VynOps
v0.1.0 · Open Source · MIT License

VynHana — AI-Powered SAP HANA Operations Platform

Enterprise-grade SAP HANA operations with AI-assisted triage, performance analytics, replication monitoring, and incident workflows your team can trust.

Built on Next.js · SAP HANA client · AI Copilot · Incident Intelligence

Tenant visibility
AI root cause analysis
HSR monitoring
Backup confidence
Incident management
Secure operations
Performance analytics
Memory monitoring
Query analysis
On-call workflows

Features

Purpose-built for SAP HANA operations

Tenant-Level Performance Visibility

Monitor every SAP HANA tenant with live health scores, query pressure, memory saturation, and service state in one dashboard.

  • Health score per tenant database based on latency, memory pressure, and alert severity
  • Statement throughput and slow query trends with outlier detection
  • Thread/resource pressure visibility across indexserver and nameserver services
  • Top expensive statements with execution frequency and impact score
  • Cross-tenant leaderboard for operational risk hotspots

AI Root Cause Analysis for HANA Events

AI correlates system metrics, query behavior, service logs, and incident history to surface likely root causes quickly.

  • Natural language query support for operational triage
  • Root-cause ranking with confidence scoring
  • Correlates query spikes with memory fragmentation and replication lag
  • Suggests mitigation steps with risk labels
  • Preserves incident context for future recurrence analysis

Replication & HSR Monitoring

Track primary/secondary health, sync states, and transport lag for HANA System Replication with proactive alerts.

  • Primary-secondary status and role mismatch detection
  • Sync mode and replication lag monitoring
  • Redo shipping anomaly alerts with threshold policies
  • Automatic incident creation on failover risk patterns
  • Historical replication stability reporting

Backup Confidence & Recovery Readiness

Validate backup jobs, retention posture, and recovery risk before outages force emergency decisions.

  • Backup success/failure timelines across all tenants
  • Retention policy drift detection
  • RPO breach warnings with escalation hooks
  • Storage growth trends for backup repositories
  • Recovery readiness score by environment

Incident, On-Call, and SLA Workflow

Treat SAP HANA issues with full incident lifecycle, ownership, and service-level accountability.

  • Incident state machine and timeline history
  • On-call routing and escalation tiers
  • SLA deadlines with breach risk monitoring
  • Audit trail for acknowledged and resolved events
  • Post-incident action tracking

Secure Operations with Guardrails

Role-aware access, explicit approvals, and clear auditability for all operational actions.

  • Role-based permissions by environment and tenant
  • Approval gates for high-risk operational actions
  • Immutable operational action logs
  • Security posture checks for monitoring connectors
  • Configurable compliance evidence export

Installation

Quick Start

From zero to first tenant visibility in under 20 minutes.

01

Clone and configure

git clone https://github.com/vynops/VynHana cd vynhana cp .env.local.example .env.local # Required: # VYNHANA_SECRET=<openssl rand -base64 32> # GROQ_API_KEY=<from console.groq.com> # HANA_HOST=<hana-host> # HANA_PORT=30015 # HANA_USER=<monitoring-user> # HANA_PASSWORD=<password>
02

Install and start

npm install npm run dev # Dashboard: http://localhost:3070
03

Register your first tenant

curl -X POST http://localhost:3070/api/tenants \ -H 'Content-Type: application/json' \ -d '{ "name": "prod-tenant-1", "host": "hana-prod.internal", "port": 30015, "database": "PRD" }'

Environment Variables

Full reference for .env.local.

VariableDescriptionRequired
VYNHANA_SECRETSession and API signing secretrequired
GROQ_API_KEYAI analysis key for Copilot and RCArequired
HANA_HOSTDefault SAP HANA hostrequired
HANA_PORTDefault SAP HANA SQL port (e.g. 30015)required
HANA_USERMonitoring user with least privilegerequired
HANA_PASSWORDMonitoring user passwordrequired
SLACK_WEBHOOK_URLSlack notifications for incidentsoptional
PAGERDUTY_ROUTING_KEYPagerDuty routing key for critical incidentsoptional
PORTHTTP port (default: 3070)optional

Ready to modernize SAP HANA operations?

Start self-hosted and scale from one tenant to your full enterprise landscape.