Israeli Postgres Toolkit
Trusted87/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 87/100 (Trusted) · 31+ 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.
skills-ilnpx skills-il add skills-il/developer-tools@v1.1.0-israeli-postgres-toolkit --skill israeli-postgres-toolkit -a claude-codeInstall on Claude.ai, Claude Desktop, ChatGPT, Manus, or other platforms
- 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.
When 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
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-ilGuide Israeli startup operations including company formation, Innovation Authority grants, investment agreements, R&D tax benefits, and employee stock options (Option 102). Use when user asks about starting a company in Israel, IIA grants, "Innovation Authority", SAFE agreements (Israeli), convertible notes, Option 102, employee stock options in Israel, R&D tax benefits, preferred enterprise, Yozma 2.0, Delaware flip, or Israeli startup legal/financial setup. Do NOT use for non-Israeli company formation or international tax advice. Always recommend consulting with Israeli lawyer and accountant for binding decisions.
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-ilCompare cloud hosting costs for Israeli startups and developers across AWS (il-central-1 Tel Aviv), Azure (Israel Central), GCP (me-west1 Tel Aviv), Oracle Cloud (il-jerusalem-1 Jerusalem), and Israeli providers like Kamatera. Use when the user needs to evaluate cloud pricing with Israel-specific considerations including data residency under Privacy Protection Law Amendment 13, latency from Tel Aviv, NIS billing options, startup credit programs (AWS Activate, Google for Startups, Microsoft Founders Hub, Israel Innovation Authority Telem program with subsidized Nvidia B200 GPUs), and FinOps cost optimization strategies. Do NOT use for comparing on-premise hosting, colocation services, or non-cloud SaaS pricing.
Use at your own risk. Terms of Use · Security
Want to build your own skill? Try the Skill Creator · Submit a Skill