How does this skill handle Supabase integration?

It provides specific patterns for linking auth.users (UUID) to profile tables while exposing a Nanoid public_id for external interactions, ensuring RLS remains simple.

Can I migrate existing UUID tables to use this Nanoid strategy?

Yes, the skill includes a specific Migration Pattern for adding public_id columns to existing tables and backfilling them with generated Nanoids.

Does using Nanoids affect PostgreSQL performance?

The performance impact is minimal; Nanoid generation is extremely fast (approx. 110,000 per second), and B-tree index performance is comparable to standard UUIDs.

Why use Nanoids instead of UUIDs for public identifiers?

Nanoids are shorter, URL-safe, and support custom prefixes, making them more user-friendly for APIs and browser URLs while maintaining high collision resistance.

What is the benefit of using ID prefixes?

Prefixes like 'usr_' or 'org_' provide immediate context for developers and prevent accidental ID collisions or logic errors when working across different database entities.

PostgreSQL Nanoid Identifiers

Name: PostgreSQL Nanoid Identifiers
Author: azlekov

byazlekov

0•

数据库管理

Implements a hybrid ID strategy using Nanoids for public-facing identifiers and UUIDs for internal PostgreSQL references.

This skill provides a comprehensive framework for implementing secure and user-friendly identifier strategies in PostgreSQL and Supabase environments. It advocates for a hybrid approach that leverages standard UUIDs for internal primary keys and auth.users references while using prefixed Nanoids for public APIs, URLs, and data exports. By offering production-ready SQL templates, TypeScript type definitions, and standardized prefix conventions (like usr_ or org_), it helps developers build consistent, readable, and secure database schemas that prevent internal ID leakage.

主要功能

01Standardized prefix conventions for common entities like Users, Organizations, and Orders

02Best practices for Row Level Security (RLS) and API response mapping

03Hybrid ID architecture combining UUID internal keys with Nanoid public keys

04TypeScript type definitions for type-safe, prefixed identifiers

05Production-grade SQL patterns for table creation and migrations

060 GitHub stars

使用场景

01Implementing secure ID strategies in Supabase projects to obfuscate internal UUIDs

02Creating human-readable and URL-safe identifiers for public-facing SaaS APIs

03Standardizing database schema patterns across multi-tenant applications

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add azlekov/my-claude-code postgres-nanoid

For use in Claude.ai and ChatGPT

Download Skill