Railway PostgreSQL CRUD

Safely look up, insert, update, and delete entities in a Railway-hosted PostgreSQL database. No psql required — uses the project's own node_modules/pg.

This skill is project-agnostic. It discovers service names, connection strings, and schema structure at runtime from the linked Railway project and the local Prisma schema (or information_schema if Prisma is not used).

Safety rules

1. Staging is always the default. Never target production unless the user explicitly says "production".
2. Production requires confirmation. State the action and its effect, then ask the user before executing any INSERT, UPDATE, or DELETE against production.
3. Look up before mutating. Always run a SELECT first and show the user the affected rows before any write operation.
4. Verify after mutating. Run a follow-up SELECT after every write to confirm the expected outcome.
5. Protect system data in production. Identify seed/system tables by reading the seed files and never delete from them in production.