postgres-nanoid
Installation
SKILL.md
PostgreSQL Nanoid Identifiers
This skill provides guidance for implementing nanoid-based identifiers in PostgreSQL, with a focus on Supabase integration.
Philosophy: Use nanoid for public-facing identifiers (URLs, APIs, exports). Use UUID for internal references to auth.users. Prefixes provide context and prevent ID collisions across entities.
Quick Reference
| Use Case | ID Type | Example |
|---|---|---|
| Public API/URLs | nanoid with prefix | usr_V1StGXR8_Z5jdHi |
| Primary key (user tables) | UUID | auth.users.id as PK+FK |
| Primary key (other tables) | UUID or nanoid | Context-dependent |
| Join tables | UUID FK | Reference auth.users directly |