sql-query-generator
cerbug45 作
CLI Utilities概要
Generate secure SQL queries with validation, pagination helpers, risk analysis, and audit-focused safeguards.
説明
このスキルでできること
Converts natural language descriptions into SQL queries across six database systems: PostgreSQL, MySQL, SQLite, SQL Server, Oracle, and MariaDB. All queries use parameterized inputs by default, with built-in injection detection, input validation, rate limiting, and audit logging.
It enforces parameterized queries and injection detection at generation time, catching security issues before they reach a database.
使いどころ
- Translating a business question into a JOIN query without writing SQL manually
- Generating paginated report queries for admin dashboards
- Building parameterized search queries for user-facing web forms
- Auditing database access logs for suspicious query patterns
- Creating data migration scripts with validated INSERT and UPDATE statements
ワークフロー例
User asks: Show all customers who spent over $500 in Q1 2024
- 1
Parse natural language to identify required tables, filter conditions, and aggregation logic
- 2
Generate a parameterized SQL query using JOIN and SUM with placeholders for the date range and spending threshold
- 3
Run injection pattern detection on any dynamic identifiers
- 4
Append index recommendations and a LIMIT clause for large datasets
- 5
Return the formatted query, parameter list, expected result structure, and a language-specific execution example
A complete parameterized SQL query with documented parameters, performance notes, and a psycopg2 or mysql-connector code snippet for immediate use
インストール
clawhub install cerbug45/sql-query-generatorCLIコマンドを実行するか、Claude Code、Cursor、Codexなどお使いのコーディングエージェントにプロンプトを貼り付けてください。