guanxuc/query-writing
agentscope-examples/harness-examples/harness-example-remote/src/main/resources/workspace/skills/query-writing/SKILL.md
Discover schema, write SELECT-only SQLite queries, execute, and explain results (aligned with harness-example).
documentation
Updated May 18, 2026
$ install --global
skillsauthnpx skillsauth add guanxuc/agentscope-java query-writingInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: May 9, 2026, 4:42 AM127.6s1 file scanned
SKILL.md
- name:
- query-writing
- description:
- Discover schema, write SELECT-only SQLite queries, execute, and explain results (aligned with harness-example).
Query writing (remote-store)
- Call
sql_list_tablesif you do not yet know table names. - Call
sql_get_schemafor each table you join or filter on. - Run
sql_execute_querywith a singleSELECT(addLIMITfor large scans). - Summarise results in plain language.
See the full skill in agentscope-examples/harness-example under
src/main/resources/workspace/skills/query-writing/SKILL.md for multi-table JOIN patterns.
Related Skills
guanxuc/skill-creator
tools
VerifiedTrustedCommunity
Guide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that extends Claude's capabilities with specialized knowledge, workflows, or tool integrations.
SKILL.mdUpdated May 20, 2026
guanxuc/schema-exploration
data-ai
VerifiedTrustedCommunity
Lists tables, describes columns and data types, identifies foreign key relationships, and maps entity relationships in the database. Use when the user asks about database structure, table layout, column types, what tables exist, foreign keys, or how entities relate to each other.
SKILL.mdUpdated May 20, 2026
guanxuc/query-writing
documentation
VerifiedTrustedCommunity
Writes and executes SQL queries ranging from simple single-table SELECTs to complex multi-table JOINs, aggregations, window functions, and subqueries. Use when the user asks to query the database, retrieve data, filter records, rank results, or generate reports.
SKILL.mdUpdated May 20, 2026
guanxuc/query-writing
documentation
VerifiedTrustedCommunity
Discover schema, write SELECT-only SQLite queries, execute, and explain results (aligned with harness-example).
SKILL.mdUpdated May 20, 2026