تخطَّ إلى المحتوى
TakoAPI
العودة إلى المهارات

sql-query-generator

بواسطة cerbug45

CLI Utilities
1.0kالتنزيلات وفق ما يذكره clawskills.sh
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

شغّل أمر واجهة سطر الأوامر، أو الصق النص في Claude Code أو Cursor أو Codex أو أي وكيل برمجة تستخدمه.

الروابط