Does this skill require a live database connection?

Yes, for the most accurate results, the skill connects to your local or remote MySQL/MariaDB instance to fetch the current table structures and column types.

Which databases are supported by this skill?

This skill is specifically designed for MySQL and MariaDB, as it queries the information_schema and uses DDL commands like SHOW CREATE TABLE to understand schema structures.

Can it handle complex SQL files with multiple joins?

Yes, it parses the SQL to identify referenced tables and attempts to match placeholders to the specific columns being filtered or inserted.

How does it determine which values to generate for parameters?

It uses pattern matching on column names (e.g., 'email', 'status', 'created_at') and cross-references them with SQL data types and ENUM values to produce realistic test data.

Does it support DDL files like CREATE TABLE?

The skill is designed to skip DDL-only files (CREATE, DROP, ALTER) and focuses on DML queries (SELECT, INSERT, UPDATE, DELETE) where parameter bindings are required.

SQL Parameter Generator

Name: SQL Parameter Generator
Author: koriym

bykoriym

•

数据库管理

Automatically generates realistic parameter bindings for SQL files by analyzing database schema and column types.

关于

The SQL Parameter Generator skill streamlines the process of performance testing by mapping SQL placeholders to their corresponding database types. It scans your SQL directories, identifies named or positional placeholders, and queries your live MySQL/MariaDB schema to understand the table structure. By matching column names and data types, it generates contextually relevant test values—such as IDs, email addresses, and timestamps—saving developers the manual effort of creating mock data. This skill is essential for users of the Koriym.SqlQuality suite who need to populate parameter files for query analysis and full-table scan detection.

主要功能

Intelligent value generation based on column names and enum values
Live database schema inspection for accurate column-to-type mapping
Automatic extraction of named and positional SQL placeholders
Support for MySQL and MariaDB information_schema analysis
Standardized PHP output generation for query performance profiling
4 GitHub stars

使用场景

Validating SQL placeholders against existing database table schemas
Generating test parameters for SQL performance analysis and query optimization
Automating the creation of mock data for database integration testing

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add koriym/koriym.sqlquality sql-params-generate

For use in Claude.ai and ChatGPT

Download Skill

GitHub

关于