rpg-sql-generator

Generate PostgreSQL migration scripts for RPG game database features.

Updated Feb 15, 2025
One-click install
npx skills add https://github.com/Ciabatos/sybath --skill rpg-sql-generator
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: rpg-sql-generator
Source: https://github.com/Ciabatos/sybath/tree/main/db/backup/ai/old%20create%20sql
Command: npx skills add https://github.com/Ciabatos/sybath --skill rpg-sql-generator

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the creation of production-ready PostgreSQL migration scripts for adding new features, tables, functions, or API endpoints to the RPG game database.

Core Features & Use Cases

  • Database Schema Management: Generates .sql files for database migrations.
  • Consistency Enforcement: Ensures new scripts adhere to existing naming conventions, schema structure, and API patterns.
  • Live Schema Verification: Always reads the live schema via MCP before writing any SQL to ensure accuracy.
  • Use Case: When asked to add a new 'crafting' system to the RPG, this Skill will generate the necessary SQL to create new tables for recipes, ingredients, and crafting stations, along with the associated API functions.

Quick Start

Use the rpg-sql-generator skill to add a new table for player inventory items.

Frequently Asked Questions about rpg-sql-generator

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

FAQPage Schema
How do I generate PostgreSQL migration scripts for new RPG game features?

To generate PostgreSQL migration scripts for RPG game features, use this Skill to automate the creation of tables, functions, and API endpoints. It reads the live database schema first to ensure the generated SQL scripts are production-ready and consistent with existing patterns.

Can I automatically create database tables and API endpoints for a crafting system?

Yes, you can automatically create database tables and API endpoints for a crafting system. The Skill generates the necessary SQL to create tables for recipes, ingredients, and crafting stations, along with the associated API functions for the new game mechanics.

How does live schema verification work before writing SQL migration scripts?

Live schema verification works by reading the live database schema via MCP tools before writing any SQL. This mechanism ensures accuracy and enforces consistency with existing naming conventions, schema structure, and API patterns before generating migration scripts.

What's the best way to ensure new database migrations match my existing RPG schema?

The best way to ensure new database migrations match your existing RPG schema is to use a generation tool that reads the live database structure first. This approach enforces consistency with existing naming conventions and API patterns automatically during SQL script generation.

Do I need an existing PostgreSQL database to use this SQL code generation tool?

Yes, you need an existing PostgreSQL database environment. The Skill requires live schema verification via MCP tools before generating migration scripts, meaning it must connect to and read your current database structure to ensure accurate and consistent SQL code generation.

Why does my generated SQL migration script not match the existing database schema?

Generated SQL migration scripts may not match the existing schema if the live database structure is not read before code generation. This Skill prevents such issues by always verifying the live schema via MCP tools first, ensuring table and function creation adheres to current API patterns.