Best practices for PostgreSQL in Israeli apps, covering Supabase patterns, Hebrew text indexing with ICU collation, shekel/NIS currency handling, Israeli date formats, and Asia/Jerusalem timezone gotchas.
Trust score 92/100 (Verified) · 18+ installs · 3 GitHub contributors · MIT license
Israeli developers working with PostgreSQL face unique challenges: Hebrew text indexing with proper collation, shekel/NIS currency handling, Asia/Jerusalem timezone with DST transitions, and Hebrew calendar integration. Without locale-specific knowledge, databases suffer from poor Hebrew search performance and data integrity issues.
npx skills-il add skills-il/developer-tools@v1.0.2-israeli-postgres-toolkit --skill israeli-postgres-toolkit -a claude-codeSet up full-text Hebrew search with ICU collation and pg_trgm for my Supabase app
Create a customers table with Israeli ID validation, phone formatting, and 7-digit postal code
Build an invoicing system with 18% VAT calculation, NIS amounts, and Bank of Israel exchange rates
Audit and improve my database performance, including Hebrew text indexes and fiscal year partitioning
Updated VAT calculation example to 18% (column default and explanatory text).
Apr 24, 2026
Build and manage shipping integrations with Israeli carriers, including Israel Post, Cheetah, HFD, and Mahir Li, plus locker pickup services (BOX2GO, Shlager, Done). Use when user asks about "shipping Israel", "Cheetah delivery", "meshloach", "shipping label", "HFD", "locker pickup Israel", or setting up carrier integrations for an e-commerce store. Covers carrier selection, Israeli address formatting, label generation, cross-carrier tracking system setup, and customer delivery notifications. Do NOT use for looking up a specific package tracking status (direct users to mypost.israelpost.co.il or hfd.co.il). Do NOT use for international shipping outside Israel or customs/import.
Manage media assets through Cloudinary's REST API -- upload, transform, optimize, and deliver images and videos. Use when user asks about image upload, media optimization, image transformations, responsive images, video management, CDN delivery, or mentions Cloudinary specifically. Covers Upload API, Admin API, URL-based transformations, AI-powered effects (gen_remove, gen_replace, background removal), and delivery optimization. Israeli-founded (2012) with R&D in Petach Tikva; global HQ in Santa Clara, California. Do NOT use for non-Cloudinary media hosting or local image processing without cloud upload.
Best practices for programmatic video creation in React with Remotion, including full Hebrew RTL support. Covers animations, compositions, sequencing, transitions, TikTok-style captions with word highlighting, AI voiceover, 3D, charts, Hebrew Google Fonts, and bidirectional text animations. Use when working with Remotion code or creating Hebrew social media videos and marketing content. Do NOT use for non-Remotion video editing or general React development.
Want to build your own skill? Try the Skill Creator · Submit a Skill