कंटेंट पर जाएँ
TakoAPI
स्किल्स पर वापस

sql-query-generator

cerbug45 द्वारा

CLI Utilities
1.0kclawskills.sh द्वारा बताए गए डाउनलोड
0व्यूज़
0 लाइकइस स्किल को लाइक करने के लिए साइन इन करें
—अभी तक कोई रेटिंग नहीं
आपकी रेटिंग

संक्षिप्त

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. 1

    Parse natural language to identify required tables, filter conditions, and aggregation logic

  2. 2

    Generate a parameterized SQL query using JOIN and SUM with placeholders for the date range and spending threshold

  3. 3

    Run injection pattern detection on any dynamic identifiers

  4. 4

    Append index recommendations and a LIMIT clause for large datasets

  5. 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-generator

CLI कमांड चलाएँ, या प्रॉम्प्ट को Claude Code, Cursor, Codex या जो भी कोडिंग एजेंट आप इस्तेमाल करते हैं उसमें पेस्ट करें।

लिंक