sap-sqlscript

Validates SQLScript code for syntax, patterns, and best practices with auto-fix capability

Converts between standalone SQLScript procedures and AMDP class implementations

Analyzes SQLScript code for performance issues and suggests optimizations with auto-fix capability

Set up the SQLScript development environment by installing the SAP HANA SQLScript LSP VS Code extension, configuring workspace settings, and verifying HANA connection environment variables

Use this agent when the user asks to "create an AMDP class", "help with AMDP", "implement ABAP managed database procedure", "write AMDP method", "convert procedure to AMDP", or needs assistance with ABAP-SQLScript integration. Examples: <example> Context: User needs to create an AMDP class from scratch user: "I need to create an AMDP class for customer data processing" assistant: "I'll use the amdp-helper agent to guide you through creating the AMDP class. It will help with the class definition, interface implementation, method signatures, and SQLScript implementation." <commentary> Creating AMDP classes requires proper structure with IF_AMDP_MARKER_HDB interface. </commentary> </example> <example> Context: User wants to convert existing procedure to AMDP user: "How do I wrap this SQLScript procedure in an AMDP class?" assistant: "I'll use the amdp-helper agent to convert your SQLScript procedure to an AMDP. It will handle the type mappings, class structure, and ensure the SQLScript is compatible with AMDP restrictions." <commentary> Conversion requires understanding both ABAP and SQLScript patterns. </commentary> </example> <example> Context: User has AMDP errors user: "My AMDP is giving errors about parameter types" assistant: "Let me use the amdp-helper agent to diagnose the issue. AMDP has specific type mapping requirements between ABAP and SQLScript that need to be followed." <commentary> Type mapping issues are common AMDP problems. </commentary> </example>

Use this agent when the user asks to "create a SQLScript procedure", "generate HANA procedure", "write a stored procedure", "build a SQLScript function", "create table function", or needs to generate new SQLScript code from requirements. This agent asks clarifying questions before generating code. Examples: <example> Context: User wants to create a new procedure user: "Create a procedure that calculates monthly sales totals" assistant: "I'll help you create that procedure. Let me use the procedure-generator agent to ask a few clarifying questions about parameters, error handling preferences, and output format before generating production-ready code." <commentary> The agent will ask about input parameters, expected output, and error handling before generating. </commentary> </example> <example> Context: User needs a table function user: "I need a function that returns filtered employee data" assistant: "I'll use the procedure-generator agent to help design your table function. It will clarify the filter criteria, column requirements, and any performance constraints first." <commentary> Table functions have specific constraints; the agent clarifies requirements upfront. </commentary> </example> <example> Context: User wants AMDP implementation user: "Generate an AMDP class for order processing" assistant: "I'll use the procedure-generator agent for this. Since AMDP has specific requirements, it will first clarify the ABAP type mappings, method signatures, and integration patterns you need." <commentary> AMDP requires special consideration for ABAP integration. </commentary> </example>

Use this agent when the user asks to "analyze my SQLScript", "review HANA procedure", "check procedure performance", "find SQLScript issues", "audit SQLScript code", "review stored procedure", or needs performance analysis of SAP HANA database procedures. Examples: <example> Context: User has written a SQLScript procedure and wants to check for issues user: "Can you analyze this procedure for any problems?" assistant: "I'll use the sqlscript-analyzer agent to perform a comprehensive analysis of your procedure, checking for performance issues, error handling gaps, and best practice violations." <commentary> The user wants code review, which is the primary purpose of this agent. </commentary> </example> <example> Context: User is experiencing slow performance with a HANA procedure user: "My SQLScript procedure is running slowly, can you help?" assistant: "Let me use the sqlscript-analyzer agent to identify performance bottlenecks in your procedure. I'll check for cursor usage, imperative logic, engine mixing, and other common performance anti-patterns." <commentary> Performance analysis is a key capability of this agent. </commentary> </example> <example> Context: User wants to ensure their code follows SAP HANA best practices user: "Does this AMDP follow best practices?" assistant: "I'll analyze your AMDP using the sqlscript-analyzer agent. It will check for proper error handling, parameter patterns, and compliance with AMDP restrictions." <commentary> Best practices validation including AMDP-specific patterns. </commentary> </example>

This skill should be used when the user asks to "write a SQLScript procedure", "create HANA stored procedure", "implement AMDP method", "optimize SQLScript performance", "handle SQLScript exceptions", "debug HANA procedure", "create table function", or mentions SQLScript, SAP HANA procedures, AMDP, EXIT HANDLER, or code-to-data paradigm. Comprehensive SQLScript development guidance for SAP HANA database programming including syntax patterns, built-in functions, exception handling, performance optimization, cursor management, and ABAP Managed Database Procedure (AMDP) integration.

2 hooks across 2 events