Using SQL

Operate InterSystems SQL within the InterSystems IRIS data platform.

Updated Feb 2, 2026

Search Tags:#database #data management #sql #querying #objectscript #intersystems

Ready to run

npx skills add https://github.com/sorodriguezz/skills-objectscript --skill using-sql

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: Using SQL
Source: https://github.com/sorodriguezz/skills-objectscript/tree/main/skills/using-sql
Command: npx skills add https://github.com/sorodriguezz/skills-objectscript --skill using-sql

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides comprehensive guidance and operational instructions for utilizing InterSystems SQL, enabling users to effectively manage and query data within the InterSystems IRIS data platform.

Core Features & Use Cases

SQL Syntax and Execution: Learn about InterSystems SQL syntax, including embedded and dynamic SQL, and various execution interfaces like the SQL Shell and Management Portal.
Data Management: Understand how to define tables, views, manage data (INSERT, UPDATE, DELETE), and utilize stored procedures.
Interoperability: Explore JDBC and ODBC drivers for seamless integration with other tools and applications.
Use Case: A developer needs to integrate data from an external relational database into their InterSystems IRIS application. They can use the SQL Gateway and the provided information on ODBC/JDBC to achieve this.

Quick Start

Use the Using SQL skill to learn how to embed InterSystems SQL code within ObjectScript.

Frequently Asked Questions about Using SQL

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I use SQL in InterSystems IRIS to manage relational data?▼

You can use InterSystems SQL to manage relational data by defining tables and views, executing INSERT, UPDATE, and DELETE operations, and utilizing stored procedures within the InterSystems IRIS data platform. The Skill provides operational guidance for these core data management tasks.

What is the difference between embedded and dynamic SQL in ObjectScript?▼

InterSystems SQL supports both embedded and dynamic SQL execution within ObjectScript. Embedded SQL is directly integrated into ObjectScript code, while dynamic SQL is parsed and executed at runtime, offering flexibility for varying query structures within the InterSystems IRIS environment.

Can I connect external applications to InterSystems IRIS using JDBC and ODBC?▼

Yes, InterSystems SQL provides JDBC and ODBC drivers for seamless interoperability. You can connect external applications and integrate data from external relational databases into your InterSystems IRIS application using the SQL Gateway and these provided drivers.

How do I execute InterSystems SQL queries through the Management Portal?▼

InterSystems SQL queries can be executed through the SQL Shell and the Management Portal. These execution interfaces allow database administrators and developers to directly run SQL syntax, test queries, and manage data within the InterSystems IRIS data platform.

Does InterSystems SQL support schema definitions and security configurations?▼

Yes, InterSystems SQL supports schema definitions and security configurations. It provides comprehensive operational instructions for defining database schemas, managing relational data structures, and securing your data within the InterSystems IRIS data platform environment.