skills.rest
Hmbown
HmbownCOMMUNITY
Explore all skills by this author →
Website𝕏@goodhuntGitHub

query-writing

Generate and execute SQL queries for data retrieval and analysis.

50|4|Updated Feb 16, 2026
Search Tags:#database#analysis#aggregation#sql#query#data retrieval#join
One-click install
npx skills add https://github.com/Hmbown/rlmagents --skill query-writing-hmbown
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: query-writing
Source: https://github.com/Hmbown/rlmagents/tree/main/examples/text-to-sql-agent/skills/query-writing
Command: npx skills add https://github.com/Hmbown/rlmagents --skill query-writing-hmbown

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill enables users to interact with databases by writing and executing SQL queries, making data retrieval and analysis accessible without direct database management expertise.

Core Features & Use Cases

  • SQL Query Generation: Assists in writing SQL queries, from simple single-table lookups to complex multi-table JOINs and aggregations.
  • Schema Awareness: Can retrieve and display database schemas to inform query writing.
  • Query Execution: Executes generated SQL queries against a database and returns the results.
  • Use Case: A marketing analyst needs to find the top 5 countries by revenue. They can use this skill to generate and run a SQL query that joins customer and invoice tables, aggregates revenue by country, and limits the output.

Quick Start

Use the query-writing skill to write and execute a SQL query that selects the top 5 countries by total revenue.

Frequently Asked Questions about query-writing

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I write and execute SQL queries for database analysis without direct database expertise?▼

This Skill generates and executes SQL queries against a database for data retrieval and analysis, abstracting direct database interaction so you do not need database management expertise to retrieve complex data.

Can I use SQL to join multiple tables and aggregate data for a specific report?▼

Yes, SQL supports complex multi-table JOINs and aggregations. You can generate queries that join customer and invoice tables, aggregate revenue by country, and limit output to find top countries by total revenue.

How do I retrieve and display a database schema to inform my query writing?▼

Schema awareness retrieves and displays database schemas to inform query writing. By exploring the database structure first, you can generate accurate SQL queries tailored to your specific tables and columns.

What is the best way to generate a SQL query for aggregating revenue by country?▼

The best way to aggregate revenue by country is to generate a SQL query that joins customer and invoice tables, groups the results by country, calculates the total revenue, and limits the output to the top 5 entries.

Do I need to know direct database management to run data retrieval queries?▼

No, you do not need direct database management expertise to run data retrieval queries. This approach abstracts direct database interaction, making data retrieval and analysis accessible by generating and executing SQL queries for you.

Related Skills

Explore More Data & Analytics Skills→
opensage-agentopensage-agent
113

neo4j-query

Execute arbitrary Cypher queries against Neo4j graph databases to retrieve structured JSON records.

Official
Intermediate
CellCogCellCog
6

data-cog

Analyze messy datasets to produce insights, charts, and data-driven reports.

Official
Advanced
WynterJonesWynterJones
5

data-analyst

Analyze datasets to produce statistical summaries and data-driven reports.

Community
Intermediate
spandiosspandios

sql-queries

Generate SQL queries from natural language across BigQuery, PostgreSQL, and MySQL.

Community
Intermediate