tdyar/iris-sql
OfficialWrite robust IRIS SQL with confidence.
Authorintersystems-community
Version1.0.0
Installs0
System Documentation
What problem does it solve?
IRIS SQL deviates from ANSI SQL in ways that commonly cause bugs and performance issues. This guide consolidates IRIS-specific rules, pitfalls, and best practices into a concise reference to help developers write correct, efficient SQL against IRIS.
Core Features & Use Cases
- Comprehensive IRIS SQL quirks reference: table naming, NULL semantics, SQLCODE semantics, IN clause limits, DDL constraints, and date handling.
- Practical usage patterns: chunk large IN lists, use %MATCHES and %STARTSWITH for reliable matching, and safe upsert strategies.
- Real-world scenarios: migrations, data queries, and performance tuning.
Quick Start
Ask your AI to apply IRIS SQL patterns from this guide to your current query task.
Dependency Matrix
Required Modules
None requiredComponents
Standard package💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: tdyar/iris-sql Download link: https://github.com/intersystems-community/iris-dev/archive/main.zip#tdyar-iris-sql Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.