Using InterSystems SQL Search
CommunitySearch unstructured text with SQL.
Authorsorodriguezz
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill addresses the challenge of efficiently searching through large volumes of unstructured text data stored within InterSystems IRIS databases, enabling users to find specific information quickly and accurately.
Core Features & Use Cases
- SQL-based Text Search: Leverages SQL queries with specialized syntax to search text content.
- Advanced Search Capabilities: Supports word, phrase, fuzzy, and regular expression matching.
- Index Optimization: Utilizes various index types (Minimal, Basic, Semantic, Analytic) for performance.
- Use Case: A financial analyst needs to quickly find all reports mentioning "market volatility" within a specific date range across thousands of text documents stored in InterSystems IRIS.
Quick Start
Use the Using InterSystems SQL Search skill to find all records in the Aviation.TestSQLSrch table where the Narrative property contains the phrase "flight plan" and the word "instruct".
Dependency Matrix
Required Modules
None requiredComponents
references
💻 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: Using InterSystems SQL Search Download link: https://github.com/sorodriguezz/skills-objectscript/archive/main.zip#using-intersystems-sql-search 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 223,000+ vetted skills library on demand.