Hanaperformancemcp — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Hanaperformancemcp (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
>
[!NOTE] This is a read-only mirror. Original repo and development: git.epod.dev/erhan/HANAPerformanceMCP
An MCP server that gives AI assistants direct access to SAP HANA performance data — query plans, execution stats, memory usage.
Built on the Model Context Protocol with hdbcli.
| Tool | What it does |
|---|---|
analyze_query | Captures compile-time and runtime query plans, flags bottlenecks |
download_planviz | Exports query plan data as JSON for offline review |
get_expensive_statements | Top resource-heavy queries from M_EXPENSIVE_STATEMENTS |
get_plan_cache | Cached execution plans from M_SQL_PLAN_CACHE |
get_table_statistics | Table and column-level stats for a schema/table |
get_memory_stats | Host and per-service memory usage |
get_active_sessions | Active connections and running statements |
MONITORING role (or at minimum, SELECT on SYS.M_* views)Clone the repo and install dependencies with uv:
git clone https://git.epod.dev/erhan/HANAPerformanceMCP.git
cd HANAPerformanceMCP
uv syncCopy the example env file and fill in your HANA connection details:
cp .env.example .envHANA_HOST=your-hana-host
HANA_PORT=30015
HANA_USER=DBADMIN
HANA_PASSWORD=your-password
HANA_ENCRYPT=true
HANA_SSLVALIDATECERTIFICATE=false
# Optional — set this to connect to a tenant database instead of the system DB
HANA_DATABASE_NAME=CCQStart the server directly:
uv run hana-performance-mcpOr configure it in your MCP client. Example for Claude Desktop (claude_desktop_config.json):
{
"mcpServers": {
"hana-performance": {
"command": "uv",
"args": [
"--directory", "/path/to/HANAPerformanceMCP",
"run", "hana-performance-mcp"
],
"env": {
"HANA_HOST": "your-hana-host",
"HANA_PORT": "30015",
"HANA_USER": "DBADMIN",
"HANA_PASSWORD": "your-password",
"HANA_ENCRYPT": "true",
"HANA_SSLVALIDATECERTIFICATE": "false",
"HANA_DATABASE_NAME": "your-tenant-db"
}
}
}
}For Claude Code, add the same config under mcpServers in .claude/settings.json.
The server connects to HANA through a thread-safe connection pool (3 connections by default). Each tool runs read-only queries against system views.
analyze_query runs EXPLAIN PLAN for the compile-time plan, then optionally executes the query and pulls runtime stats from M_EXPENSIVE_STATEMENTS. It checks for full table scans, inefficient joins, memory hotspots, engine mismatches, and cost outliers.
Only SELECT/WITH statements are allowed. Row limits are enforced (max 10,000).
MIT
~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.