SAP HANA FAQs

Question 1

What specific database operations can AI assistants perform?

Accepted Answer

AI assistants can utilize three primary MCP tools: `sap_hana_get_tables` to list available tables, `sap_hana_get_columns` to retrieve column metadata for specific tables, and `sap_hana_run_query` to execute SQL SELECT statements against the database.

Question 2

How can I deploy the SAP HANA MCP Server?

Accepted Answer

The server offers flexible deployment options. You can run it locally using Python, or deploy it easily with Docker, allowing for containerized hosting and simplified management.

Question 3

Can I access column metadata for tables directly?

Accepted Answer

Yes, beyond the `sap_hana_get_columns` tool, the server provides an MCP resource at `sap_hana://tables/{schema}/{table}` which returns column metadata for a specified schema and table in CSV format.

Question 4

What is the SAP HANA MCP Server?

Accepted Answer

The SAP HANA MCP Server is a Model Context Protocol (MCP) server designed to expose SAP HANA database capabilities, such as listing tables, columns, and running queries, as tools that AI assistants can directly use and interact with.

Question 5

How do I configure the server to connect to my SAP HANA instance?

Accepted Answer

Configuration is handled via environment variables. You'll need to set `HANA_HOST`, `HANA_PORT`, `HANA_USER`, and `HANA_PASSWORD` in a `.env` file to provide your SAP HANA connection details.

SAP HANA

SAP HANA

Key Features

Use Cases

Key Features

Use Cases