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 83/100 (Trusted) · 15+ 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 --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
Build Telegram bots with grammY, Telegraf, or python-telegram-bot. Covers Bot API v9.5 webhooks vs polling, inline keyboards, commands, middleware patterns, payments API, Mini Apps, and Hebrew message handling with RTL support. Use when building a Telegram bot, setting up webhooks, handling Hebrew messages in a bot, or integrating Telegram payments. Do NOT use for WhatsApp bots (use israeli-whatsapp-business), voice bots (use hebrew-voice-bot-builder), or general chatbot design patterns (use hebrew-chatbot-builder).
Guide 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, 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.
Build and optimize n8n 2.0 automation workflows with Israeli API integrations including Morning (formerly Green Invoice), israeli-bank-scrapers, data.gov.il, SMS gateways, and payment processors (Cardcom, Tranzila, Grow by Meshulam). Covers AI Agent nodes, MCP integration, Israel Invoice Reform 2026, Bit payments, Hebrew data handling, Shabbat-aware scheduling, and self-hosting on Israeli cloud. Do NOT use for general n8n tutorials without Israeli context.
Want to build your own skill? Try the Skill Creator · Submit a Skill