skills.rest
Ciabatos
CiabatosCOMMUNITY
Explore all skills by this author →
GitHub

rpg-sql-conventions

Enforce SQL naming conventions and templates for RPG game databases.

Updated Feb 15, 2025
Search Tags:#templates#database#postgresql#sql#conventions#rpg
One-click install
npx skills add https://github.com/Ciabatos/sybath --skill rpg-sql-conventions
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: rpg-sql-conventions
Source: https://github.com/Ciabatos/sybath/tree/main/.opencode/skills/sql-file-conventions
Command: npx skills add https://github.com/Ciabatos/sybath --skill rpg-sql-conventions

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill ensures all SQL code written for the RPG project adheres to a strict, consistent set of naming conventions, table structures, and function templates, preventing common errors and improving maintainability.

Core Features & Use Cases

  • Standardized Naming: Enforces consistent naming for schemas, tables, columns, and functions.
  • Code Templates: Provides pre-defined templates for creating tables, GET API functions, and ACTION API functions.
  • Use Case: When a new feature requires database interaction, consult this Skill to ensure the SQL code follows the established patterns for schemas, tables, and stored procedures, making it easy for any developer to understand and integrate.

Quick Start

Use the rpg-sql-conventions skill to generate a new table template for the 'player_inventory' schema.

Frequently Asked Questions about rpg-sql-conventions

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

FAQPage Schema
How do I standardize SQL naming conventions for a game database?▼

To standardize SQL naming conventions for a game database, apply strict rules for schemas, tables, columns, keys, and variables. This ensures structural consistency across all SQL development and prevents common errors.

What is the best way to structure PostgreSQL CREATE TABLE templates for RPG development?▼

The best way to structure PostgreSQL CREATE TABLE templates for RPG development is to use pre-defined structural guidelines. These templates enforce consistent formatting for maintainability and developer collaboration.

How do I generate automatic GET API functions for a player inventory schema?▼

To generate automatic GET API functions for a player inventory schema, use provided SQL templates designed for player-context retrieval. These templates ensure standard function patterns and consistent database interactions.

Can I use SQL templates to enforce consistency for ACTION API functions in a game database?▼

You can use SQL templates to enforce consistency for ACTION API functions in a game database. These templates define specific formatting and structural guidelines for stored procedures, making features easier to integrate.

Do I need specific SQL style rules to maintain consistency across multiple developers?▼

You need specific SQL style rules to maintain consistency across multiple developers. Enforcing standardized patterns for tables and functions prevents misalignment and improves overall project maintainability.

Related Skills

Explore More Software Engineering Skills→
pdovhomiljapdovhomilja

Backend Models

Define database schemas with naming conventions, constraints, and relationships.

Community
Basic
phenobarbitalphenobarbital
13

database-schema-validator

Validate SQL schema files for snake_case tables, id primary keys, and no DROP TABLE statements.

Community
Intermediate
CiabatosCiabatos

rpg-game-design

Decompose RPG feature requests into database components and design patterns.

Community
Advanced
vieriusorinvieriusorin

db-migrate

Create and execute PostgreSQL schema migrations with Drizzle ORM.

Community
Intermediate