sql-query-generator

What This Skill Does

The sql-query-generator skill is a robust, security-first utility designed to bridge the gap between natural language intent and syntactically correct, performant SQL. It serves as a specialized engine for developers and data analysts, converting conversational queries like 'Show me the top 5 customers by order volume this month' into structured, secure SQL code. Beyond simple generation, it enforces best practices such as parameterization to prevent SQL injection, query optimization recommendations, and support for complex operations including window functions, CTEs, and aggregation logic across multiple SQL dialects like PostgreSQL, MySQL, and SQLite.

Installation

You can integrate this skill into your workflow using the OpenClaw ecosystem. Run the following command in your terminal: clawhub install openclaw/skills/skills/cerbug45/sql-query-generator. Once installed, ensure you have the appropriate database drivers for your specific environment, such as psycopg2-binary for PostgreSQL or mysql-connector-python for MySQL, as these are handled as optional dependencies to keep the core footprint lightweight.

Use Cases

This skill is perfect for scenarios requiring rapid data retrieval, automated report generation, and debugging. Use it to prototype complex schema interactions, generate optimized queries for dashboard backends, or assist in data migrations where SQL syntax must be strictly maintained. It is particularly effective for teams seeking to standardize their SQL coding patterns while reducing the overhead of manual query construction.

Example Prompts

1. "Generate a SQL query for PostgreSQL that joins the orders and users tables, selecting the customer name and total order amount for all orders placed in the last 30 days, grouped by user."
2. "Write a secure, parameterized SQL update statement to change the email address for user ID 502, including a safety check to ensure the record exists first."
3. "Analyze the following table schema and generate a query using a common table expression to identify orphaned records in the products table that have no associated orders."

Tips & Limitations

Always provide clear context regarding your table schemas, as the skill is most accurate when it understands your foreign key relationships. While this tool produces high-quality SQL, it is a generative assistant; always review generated code in a staging environment before executing it against production databases. The skill currently supports standard ANSI SQL and major RDBMS dialects, but may require manual adjustment for highly specific vendor-proprietary procedural SQL extensions.