Description
Write-query is an agent skill that turns a plain-language description of the data you need into an optimized SQL query for your database dialect. You describe what you want to know, and the skill first parses the request to pin down the metrics, the tables, the filters and the time range. It then writes the SQL following the plugin's best practices, which include using multi-step common table expressions and joins where a question needs them. The output is written for the dialect you use, so the syntax matches your warehouse rather than a generic version. The skill is aimed at analysts who know what they want to measure but do not want to spend time on syntax, and at anyone who needs a clean starting point for a complex query. You run it with /write-query followed by a description of the data. It is part of Anthropic's knowledge-work plugins, and it uses the data connector guide for the systems it reads from.…
Highlights
- Turns a plain-language data need into SQL
- Writes queries for your specific SQL dialect
- Uses multi-step CTEs and joins for complex questions
- Parses the request into metrics, tables, filters and time range
Ratings & Reviews
No ratings yet
Be the first to rate write-query.
People also visit
statistical-analysis
Apply statistical methods including descriptive stats, trend analysis
write-query FAQ
What does write-query produce?
A SQL query written for your dialect, based on the description of the data you need.
Which SQL dialects does it support?
It writes for the dialect you name, and the plugin's SQL guidance covers common warehouse platforms.
Who is it for?
Data analysts and anyone who needs a SQL query but wants to describe the question in plain words.
How do I use it?
Run /write-query followed by a description of the data you want.
How do I install it?
Run npx skills add https://github.com/anthropics/knowledge-work-plugins --skill write-query in your terminal.
Is it free?
Yes. The skill is listed as free on skills.sh.
What security audits has it passed?
skills.sh lists three audits: Gen Agent Trust Hub Pass, Socket Pass and Snyk Pass.
What are the best write-query alternatives?
Popular alternatives to write-query include sql-queries, query-writing and analyze. See all write-query alternatives