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 या जो भी कोडिंग एजेंट आप इस्तेमाल करते हैं उसमें पेस्ट करें।