Israeli Postgres Toolkit
Trusted81/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 81/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-ilBuild and configure Make.com scenarios for Israeli business processes, including Morning (formerly Green Invoice) sync, iCount accounting, Monday.com board automation, Priority ERP data exports, WhatsApp Business messaging, and payment gateways (Cardcom, Tranzila, Grow, Bit). Covers Make.com AI Agents, the Make.com MCP server for exposing scenarios as agent tools, Israel 2026 Invoice Reform, community modules for Israeli apps, Hebrew data transformations, Data Store for VAT period tracking, and Shabbat-aware scheduling. Do NOT use for n8n workflows (use n8n-hebrew-workflows) or Zapier Zaps (use zapier-israeli-integrations).
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-ilBenchmark and compare LLMs on Hebrew reasoning, comprehension, sentiment, translation, and Israeli cultural knowledge. Wraps the HuggingFace Open Hebrew LLM Leaderboard tasks (HeQ, HebrewSentiment, Hebrew Winograd, translation) plus DictaLM 3.0 benchmark tasks (Summarization, Nikud, Israeli Trivia) into a reproducible evaluation harness. Runs evals against Claude, GPT, Gemini, AI21 Jamba, DictaLM, Llama, and local HuggingFace models. Produces comparison scorecards in JSON and markdown. Use when choosing an LLM for a Hebrew product, answering procurement questions about Hebrew performance, validating a fine-tuned Hebrew model, or tracking Hebrew regressions after a model upgrade. Do NOT use for Arabic NLP, ASR benchmarking, or general English benchmarks.
Use at your own risk. Terms of Use · Security
Want to build your own skill? Try the Skill Creator · Submit a Skill