Help us improve
Share bugs, ideas, or general feedback.
From sapcli-abap-tools
Executes ABAP SQL (OpenSQL) SELECT queries against a connected SAP system via sapcli datapreview osql. Supports row limits, JSON output, and suppression of headings.
npx claudepluginhub jfilak/sapcli-claude-plugin --plugin sapcli-abap-toolsHow this skill is triggered — by the user, by Claude, or both
Slash command
/sapcli-abap-tools:abap-sql-queryThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
I run ABAP SQL (OpenSQL) SELECT queries against a connected SAP system and
Assists with ABAP code for SAP systems: internal tables, structures, ABAP SQL, OOP, RAP, CDS views, EML statements, ABAP Cloud, strings, dynamic programming, RTTI/RTTC, field symbols, data references, exceptions, unit testing.
Guides writing modern ABAP SQL queries and ABAP Managed Database Procedures (AMDP) including inline declarations, window functions, CTEs, aggregates, GROUP BY, HAVING, PRIVILEGED ACCESS, and CDS table functions.
Fetches and displays ABAP system information (SID, client, user details) via sapcli. Useful for troubleshooting and confirming connection details.
Share bugs, ideas, or general feedback.
I run ABAP SQL (OpenSQL) SELECT queries against a connected SAP system and
display the results. I use the sapcli datapreview osql command under the hood.
Use me when you need to query SAP database tables directly — for example to inspect table contents, check configuration entries, or retrieve data for analysis or debugging.
sapcli datapreview osql "SELECT * FROM <TABLE>"
Use --rows to cap the number of result rows (default is determined by the
system):
sapcli datapreview osql --rows 20 "SELECT MANDT, CARRID, CONNID FROM SPFLI"
Results can be displayed in human-readable form (default) or as JSON:
# Human-readable table (default)
sapcli datapreview osql "SELECT * FROM T000"
# JSON output — useful for scripting or piping to jq
sapcli datapreview osql -o json "SELECT * FROM T000"
Use -n / --noheadings to omit column headers from the output:
sapcli datapreview osql -n "SELECT MANDT FROM T000"
Use --noaging to skip the data aging check:
sapcli datapreview osql --noaging "SELECT * FROM SFLIGHT UP TO 5 ROWS"
statement argument must be valid ABAP SQL syntax without a trailing period.datapreview osql.