game-database
Installation
SKILL.md
Game Database Skill
Overview
This skill provides expertise for designing and implementing database schemas for multiplayer turn-based games. It covers PostgreSQL patterns, game state persistence, user management, and the hybrid approach of relational tables with JSONB for complex game state.
Database Selection
Why PostgreSQL for Games
- JSONB support: Store complex game state as JSON while keeping it queryable
- ACID transactions: Critical for game state consistency
- Row-level locking: Handle concurrent updates safely
- Railway integration: Easy deployment and management
- Mature ecosystem: Excellent Node.js support via pg or Prisma