SAPSkills
SAP HANA

SAP HANA Skills for AI Coding Assistants

SAP HANA is SAP's in-memory, column-oriented database and application platform. It powers the data layer of SAP S/4HANA and serves as the primary database for cloud-native applications built on SAP BTP through SAP HANA Cloud. Beyond traditional relational database capabilities, HANA provides advanced analytics, spatial processing, graph engines, and an embedded machine learning library.

Developers interact with SAP HANA through several layers: SQL and SQLScript for database programming, HDI (HANA Deployment Infrastructure) containers for schema management, the hana-cli tool for administration and inspection, and the Python hana-ml library for in-database machine learning. SAP Data Intelligence Cloud adds pipeline-based data processing and orchestration on top of HANA. AI coding assistants without SAP HANA knowledge struggle with the platform's SQLScript dialect, HDI container lifecycle, and the specific APIs for PAL/APL machine learning algorithms.

The three skills in this category cover the HANA development surface. The sap-hana-cli skill covers CLI workflows, output formats, HDI container management, SQL query execution, metadata-to-CDS conversion, and cloud operations. The sap-hana-ml skill covers the Python hana-ml library for PAL/APL algorithms, HANA DataFrame operations, AutoML, classification, regression, clustering, and time series. The sap-hana-cloud-data-intelligence skill covers Data Intelligence pipelines, operators, ML scenarios, and Data Transformation Language.

Together these skills give your assistant context for HANA database development, CLI operations, and ML-related workflows.

Quick Install

npx skills add secondsky/sap-skills --skill sap-datasphere --skill sap-hana-cli --skill sap-hana-cloud-data-intelligence --skill sap-hana-ml --skill sap-sqlscript --skill sap-btp-master-data-integration

3 Skills in SAP HANA

Frequently Asked Questions

What is SAP HANA?

SAP HANA is SAP's in-memory, column-oriented database and application platform. It provides high-performance data processing, advanced analytics, and embedded machine learning, and powers the data layer of SAP S/4HANA and SAP BTP cloud applications.

Can AI coding assistants write SQLScript for SAP HANA?

Yes. The sap-hana-cli skill provides reference data for HANA database development and CLI operations. For SQLScript procedures specifically, the sap-sqlscript skill in the Data & Analytics category provides comprehensive coverage of procedures, functions, and AMDP.

What is the hana-cli?

hana-cli is an open-source command-line tool for SAP HANA development and administration. It helps inspect database objects, manage HDI containers, execute SQL, and convert metadata to formats such as CDS, EDMX, or OpenAPI.

How do I install SAP HANA skills?

Run `npx skills add secondsky/sap-skills --skill sap-hana-cli` or install all skills with `npx skills add secondsky/sap-skills`.

Explore Related Categories