메뉴
Discover schema, write SELECT-only SQLite queries, execute, and explain results (aligned with harness-example).
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
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.
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.
Discover schema, write SELECT-only SQLite queries, execute, and explain results (aligned with harness-example).
SOC 직업 분류 기준
| name | query-writing |
| description | Discover schema, write SELECT-only SQLite queries, execute, and explain results (aligned with harness-example). |
sql_list_tables if you do not yet know table names.sql_get_schema for each table you join or filter on.sql_execute_query with a single SELECT (add LIMIT for large scans).See the full skill in agentscope-examples/harness-example under
src/main/resources/workspace/skills/query-writing/SKILL.md for multi-table JOIN patterns.