Does this skill support ABAP Managed Database Procedures (AMDP)?

Yes, it includes specific implementation guidance for AMDP, including class definitions, interface requirements, and parameter handling for ABAP integration.

Does it handle complex error scenarios?

Yes, it provides robust patterns for exception handling using EXIT HANDLER, custom CONDITION declarations, and SIGNAL/RESIGNAL for user-defined error codes.

What is the primary benefit of using this skill for SAP HANA?

It helps developers implement the 'code-to-data' paradigm efficiently, ensuring logic is pushed to the database layer for maximum performance while following SAP's standardized SQLScript patterns.

Can it help me optimize slow-running HANA queries?

Absolutely. The skill provides best practices for reducing engine mixing, utilizing UNION ALL, avoiding dynamic SQL, and prioritizing declarative logic over imperative loops.

Which SAP HANA version is this skill verified for?

The skill is verified for SAP HANA 2.0 SPS07, covering the latest syntax improvements and performance features.

SAP SQLScript Development

Name: SAP SQLScript Development
Author: secondsky

bysecondsky

•

Database Management

Streamlines SAP HANA database programming with expert SQLScript syntax patterns, performance optimization, and AMDP integration.

The SAP SQLScript skill is a specialized extension for Claude Code designed for developers working within the SAP HANA ecosystem. It provides immediate access to production-ready patterns for stored procedures, user-defined functions, and ABAP Managed Database Procedures (AMDP). By emphasizing the 'code-to-data' paradigm, the skill helps developers minimize data transfer overhead and maximize parallel processing within the HANA database. From complex exception handling with SIGNAL/RESIGNAL to optimizing table variables and window functions, this skill ensures that database logic is performant, maintainable, and aligned with SAP best practices.

Key Features

012 GitHub stars

02Advanced exception handling patterns using EXIT HANDLER and SIGNAL

03Comprehensive SQLScript syntax patterns and built-in function references

04Performance optimization strategies for the code-to-data paradigm

05Support for table variables, complex types, and window functions

06Expert guidance for ABAP Managed Database Procedures (AMDP) integration

Use Cases

01Refactoring imperative SQL logic into declarative, parallelizable code

02Implementing database logic within ABAP environments using AMDP

03Building high-performance stored procedures and UDFs for SAP HANA

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add secondsky/sap-skills sap-sqlscript

For use in Claude.ai and ChatGPT

Download Skill