skills.rest
koriym
koriymCOMMUNITY
Explore all skills by this author →
Website𝕏@koriymGitHub

sql-params-generate

Generate PHP parameter bindings from SQL placeholders and live database schema.

3|2|Updated Dec 19, 2024
Search Tags:#automation#testing#php#schema#parameters#sql#placeholders
One-click install
npx skills add https://github.com/koriym/Koriym.SqlQuality --skill sql-params-generate
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql-params-generate
Source: https://github.com/koriym/Koriym.SqlQuality/tree/main/skills/sql-params-generate
Command: npx skills add https://github.com/koriym/Koriym.SqlQuality --skill sql-params-generate

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Generate parameter bindings for SQL files by analyzing live database schema and identifying SQL placeholders, reducing manual data preparation work.

Core Features & Use Cases

  • Schema-aware extraction of table structures to map placeholders to column types
  • Automatic generation of representative test values for common patterns (ids, dates, enums)
  • Output of a PHP parameters file at sql_dir/../params/sql_params.php for reuse in SQL testing workflows

Quick Start

Use this skill to generate sql_params.php by analyzing your database schema and SQL placeholders.

Frequently Asked Questions about sql-params-generate

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate SQL parameter bindings from a live database schema?▼

To generate SQL parameter bindings from a live database schema, this skill inspects table structures and maps SQL placeholders to column types, automatically producing representative test values for development and QA.

What is the best way to automate realistic test values for SQL queries?▼

Automating realistic test values for SQL queries is achieved by identifying common placeholder patterns like ids, dates, and enums, then applying schema-driven typing to generate matched parameters automatically.

How do I create a PHP parameters file for SQL testing workflows?▼

You create a PHP parameters file for SQL testing by analyzing schema and SQL placeholders, outputting the generated bindings directly to sql_dir/../params/sql_params.php for reuse in QA.

Can I use schema-aware extraction to map SQL placeholders to column types?▼

Yes, schema-aware extraction is used to map SQL placeholders to column types by inspecting live database tables and enforcing schema-driven typing for accurate parameter generation.

Does SQL parameter generation work with standard placeholder patterns in PHP?▼

Yes, SQL parameter generation works with standard placeholder patterns in PHP by identifying common patterns in your queries and mapping them to the extracted live schema column types.

Related Skills

Explore More Software Engineering Skills→
sjinkssjinks

security-review-owasp-sql-injection-prevention

Detect SQL injection risks in query construction and database execution paths.

Community
Advanced
eng-vmessiaheng-vmessiah
2

ai-regression-testing

Automate regression tests validating API response shapes and state integrity.

Community
Intermediate
paleoterrapaleoterra
2

sqlite-test-validator

Validate SQLite migrations and schemas with sqlite_validator.py CLI commands.

Community
Intermediate
alinaqialinaqi
705

database-schema

Enforce database schema adherence during AI-driven code generation.

Community
Advanced