Programming · Building & coding
sql-sp-generation
/sql-sp-generation
Guidelines for generating SQL statements and stored procedures Triggers on: **/*.sql
For whom
- Author
- pingqLIN ↗
- Repository
- skill-0 ↗
- Licence
- MIT
- Last repository change
- 18.07.2026
Assessment and security
90/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content25 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
- Files in this package
- 1
- Scripts
- 0
- HTML comments
- 0
- URLs in SKILL.md
- 0
Deprecation
No signals detected. Repository changed on 18.07.2026, without references to retired models or APIs.
Licence
MIT, open: use and modify while retaining author attribution.
What it does and when to use it
Guidelines for generating SQL statements and stored procedures Triggers on: **/*.sql
Original author description
Guidelines for generating SQL statements and stored procedures Triggers on: **/*.sql
How it works
- Database schema generation
- Database schema design
- SQL Coding Style
- SQL Query Structure
- Stored Procedure Naming Conventions
- Parameter Handling
- Stored Procedure Structure
- SQL Security Best Practices
- Transaction Management
Original SKILL.md headings · 70 lines, 468 words
SKILL.md preview
--- name: sql-sp-generation description: Guidelines for generating SQL statements and stored procedures Triggers on: **/*.sql triggers: "**/*.sql" globs: "**/*.sql" --- # SQL Development ## Database schema generation - all table names should be in singular form - all column names should be in singular form - all tables should have a primary key column named `id` - all tables should have a column named `created_at` to store the creation timestamp - all tables should have a column named `updated_at` to store the last update timestamp ## Database schema design - all tables should have a primary key constraint - all foreign key constraints should have a name - all foreign key constraints should be defined inline - all foreign key constraints should have `ON DELETE CASCADE` option - all foreign key constraints should have `ON UPDATE CASCADE` option - all foreign key constraints should reference the primary key of the parent table ## SQL Coding Style - use uppercase for SQL keywords (SELECT, FROM, WHERE) - use consistent indentation for nested queries and conditions - include comments to explain complex logic - break long queries into multiple lines for readability - organize clauses consistently (SELECT, FROM, JOIN, WHERE, GROUP BY, HAVING, ORDER BY) ## SQL Query Structure - use explicit column names in SELECT statements instead of SELECT * - qualify column names with table name or alias when using multiple tables - limit the use of subqueries when joins can be used instead - include LIMIT/TOP clauses to restrict result sets - use appropriate indexing for frequently queried columns - avoid using functions on indexed columns in WHERE clauses ## Stored Procedure Naming Conventions - prefix stored procedure names with 'usp_' - use PascalCase for stored procedure names - use descriptive names that indicate purpose (e.g., usp_GetCustomerOrders) - include plural noun when returning multiple records (e.g., usp_GetProducts) - include singular noun when returning single record (e.g., usp_GetProduct) ## Parameter Handling - prefix parameters with '@' - use camelCase for parameter names - provide default values for optional parameters - validate parameter values before use - document parameters with comments - arrange parameters consistently (required first, optional later) ## Stored Procedure Structure - include header comment block with description, parameters, and return values - return standardized error codes/messages - return result sets with consistent column order - use OUTPUT parameters for returning status information - prefix temporary tables with 'tmp_' ## SQL Security Best Practices - parameterize all queries to prevent SQL injection - use prepared statements when executing dynamic SQL - avoid embedding credentials in SQL scripts - implement proper error handling without exposing system details - avoid using dynamic SQL within stored procedures ## Transaction Management - explicitly begin and commit transactions - use appropriate isolation levels based on requirements - avoid long-running transactions that lock tables - use batch processing for large data operations - include SET NOCOUNT ON for stored procedures that modify data
Versions
The database has no other skills named sql-sp-generation.
Database snapshot: 13.11.2026 · package version b202f8a5004f (SHA-256 digest of the entire package)
Downloads in the last 30 days: 0 · ranking
Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.
Similar skills
- 100generating-stored-procedures
Execute use when you need to work with stored procedure generation. This skill provides stored procedure code generation with comprehensive guidance and automation. Trigger with phrases like "generate stored procedures", "create database functions", or "write SQL procedures". - 100generating-stored-procedures
Use when you need to generate, validate, or deploy stored procedures for PostgreSQL, MySQL, or SQL Server. Creates database functions, triggers, and procedures with proper error handling and transaction management. Trigger with phrases like "generate stored procedure", "create… - 95sql-server
SQL Server and Azure SQL Database with T-SQL, indexes, stored procedures, and performance optimization patterns. USE WHEN: user mentions "SQL Server", "T-SQL", "MSSQL", "Azure SQL", "SQL Server indexes", "stored procedures", "SQL Server performance" DO NOT USE FOR: PostgreSQL -… - 96s03-06-sql-scripts
生成建表脚本、初始化数据与可回滚的迁移脚本。当用户要求'生成建库脚本/迁移 SQL/初始化数据'时使用。产出 .sql 文件与迁移说明。 - 100sql-guide
SQL language guardrails, patterns, and best practices for AI-assisted development. Use when working with SQL files (.sql), database migrations, or when the user mentions SQL/databases. Provides query optimization patterns, indexing guidelines, transaction management, and… - 95sql-formatter
This skill should be used when the user asks to format SQL code, polish SQL queries, improve SQL readability, or work with .sql files. Use when queries mention SQL formatting, code beautification, Oracle SQL, or database query polishing.