Generate and execute SQL SELECT queries with schema inspection and validation.
npx skills add https://github.com/dotlab-hq/torque --skill query-writing-dotlab-hq
Please help me install this Agent Skill. Skill: query-writing Source: https://github.com/dotlab-hq/torque/tree/main/.agents/skills/query-writing Command: npx skills add https://github.com/dotlab-hq/torque --skill query-writing-dotlab-hq
This Skill removes the uncertainty and manual effort of composing, validating, and executing SQL queries by guiding schema inspection, join planning, and safe execution so users can reliably retrieve and aggregate data without risking destructive operations.
Use the query-writing skill to generate and execute a SELECT query that returns the top 5 customers by total invoice amount joining the Invoice and Customer tables.
High-intent search queries and answers about installing and using this skill.
Writing SQL queries for joining and aggregating data involves inspecting schemas to identify join keys, building multi-table JOINs, and using GROUP BY clauses for aggregation. This process ensures accurate data retrieval from relational databases.
The safest way to execute SQL queries for reporting is by applying safe defaults such as LIMIT 5 and strictly avoiding destructive DML statements. This approach lets you retrieve and aggregate data while preventing accidental modifications to the database.
To validate SQL JOIN conditions and handle errors, verify JOIN logic and GROUP BY correctness during construction, then implement error recovery for empty results, syntax issues, or timeouts to ensure robust query execution.
Yes, you can generate a revenue-by-country report by joining Invoice and Customer tables. You aggregate total invoice amounts, group by country, order by revenue, and limit the results to produce the final reporting output.
Yes, this query generation approach supports subqueries and complex filtering. It handles single-table SELECTs, multi-table JOINs, aggregations, and subqueries with GROUP BY and ORDER BY clauses for advanced data retrieval.
Zidane786List database tables, columns, data types, and foreign key relationships.
weirdgmeDesign and implement scalable platform engineering patterns for internal developer platforms.
KaiserWhoLearnsGenerate and optimize SQL queries for data retrieval and analysis.
tmoeishGenerate type-safe SQL query builders from annotated Go structs.
