What is Sqids?

Sqids (pronounced "squids") is an open-source library that lets you generate short unique identifiers from numbers. These IDs are URL-safe, can encode several numbers, and do not contain common profanity words. Read more .

This is what they look like:

https://example.com/Lqj8a0

ClickHouse

ClickHouse provides built-in SQL functions for generating Sqids with default parameters. This functionality is available since ClickHouse v23.12 .

Quick encode & decode example:

SELECT sqidEncode(1, 2, 3);   -- "86Rf07"
SELECT sqidDecode('86Rf07');  -- [1,2,3]

Use Cases

The main use of Sqids is purely visual. If you'd like to use IDs instead of numbers in your project, Sqids could be a good choice.

Good For

  • Encoding primary keys If you're using a relational database
  • Saving database lookups By encoding multiple objects
  • Temporary login tokens Profanity-free and URL-safe

Not Good For

  • Sensitive data This is not an encryption library
  • User IDs Can reveal user count if anyone finds out the encoding alphabet

Features

  • ๐Ÿ†” Generate short IDs from non-negative numbers
  • โœ… Easy encoding & decoding
  • ๐Ÿซฃ Auto-generated IDs do not contain common profanity
  • ๐ŸŽฒ Support for custom IDs through shuffled alphabet
  • ๐Ÿฅณ 44 integrations (70% using new design)
  • ๐Ÿ“Œ Every version produces the same IDs
  • ๐Ÿป Small library with a permissive license

Example / Playground