Israeli Postgres Toolkit
Trusted83/100Best 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 83/100 (Trusted) · 45+ installs · 4 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.
skills-ilHow to use this skill
Not sure how? Read the guide- 1. Click "Download ZIP" to download the skill files.
- 2. Open Claude Desktop and go to Customize > Skills.
- 3. Click "+" and select "Upload a skill", then upload the ZIP file.
- 4. Start a new conversation. The skill will activate automatically when relevant.
Developers? Install via command line (CLI)
npx skills-il add skills-il/developer-tools@v1.2.0-israeli-postgres-toolkit --skill israeli-postgres-toolkit -a claude-codeWhen to Apply
- When setting up a new Supabase or PostgreSQL application in Israel
- When you need full-text search in Hebrew with accurate results
- When dealing with Asia/Jerusalem timezone bugs or DST transitions
- When building a system that handles NIS amounts including VAT and exchange rates
- When you need to store and validate Israeli ID numbers, phone numbers, or addresses
Try These Prompts
Set 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
Frequently Asked Questions
Changelog
Corrected the false claim that unaccent strips Hebrew nikud (now a regexp-based strip_nikud function), fixed an unsafely IMMUTABLE function, and corrected the ICU collation guidance.
Jun 21, 2026
Fixed an incorrect full-text-search gotcha (Hebrew uses the simple config), added unaccent coverage, worked examples, troubleshooting, and reference links.
May 14, 2026
Updated VAT calculation example to 18% (column default and explanatory text).
Apr 24, 2026
Related Skills
Author: skills-ilBest practices for programmatic video creation using HyperFrames, plain HTML compositions with GSAP animations rendered to MP4, with full Hebrew and RTL support. Covers composition authoring, data-* timing attributes, GSAP timeline contract, layout-before-animation methodology, visual identity gate, Hebrew fonts via Google Fonts auto-fetch (Heebo, Rubik, Assistant), RTL text with dir="rtl", Hebrew captions via Whisper, Hebrew voiceover via external TTS (Kokoro doesn't support Hebrew), audio-reactive visuals, scene transitions, and bidirectional text with <bdi>. Use when building HTML-based video content or Hebrew social/marketing videos without React. Do NOT use for Remotion or general React video work.
Author: skills-ilConvert between Hebrew (Jewish) calendar and Gregorian dates, look up Israeli holidays, format dual dates for Israeli documents, and calculate Israeli business days. Use when user asks about Hebrew dates, "luach ivri", Jewish calendar, Israeli holidays, "chagim", Shabbat times, or needs dual-date formatting for Israeli forms. Do NOT use for Islamic Hijri calendar or non-Israeli holiday calendars.
Author: skills-ilManage online selling across Israeli marketplaces (Zap, Yad2, Facebook Marketplace, and Instagram Shopping). Use when user asks about "sell on Zap", "sell on Yad2", "Facebook Marketplace Israel", "Instagram Shopping Israel", "online selling Israel", "product listing Hebrew", or "מכירה אונליין". Covers Hebrew product listing creation, competitor price monitoring (including against first-party retailers like KSP, which is not a third-party seller platform), inventory sync, review management, sales analytics, business-registration status (osek murshe vs patur), tax-invoice and Israel-Invoice (allocation-number) obligations, and consumer-protection rules (14-day cooling-off on remote sales). Do NOT use for international marketplaces (Amazon, eBay) or physical store operations.
Use at your own risk. Terms of Use · Security
Want to build your own skill? Try the Skill Creator · Submit a Skill