SQLgateway-migration-Caché-IRISSQLgateway importing from Caché to IRIS | Robert Cemper | | 0.0 (0) | 07 Jul, 2026 | 3 | |
SQLgateway-migration-ORACLE-IRISShow a working connection to ORACLE | Robert Cemper | | 0.0 (0) | 06 Jul, 2026 | 15 | |
InterSystems Ideas Waiting to be ImplementedAI extensibility Prompt keyword for Class and Method implementation. Also Prompt macro generator.To accelerate capability of growing code generation. This proposal suggests new extensibility facilities and hooks that can be democratized to community and / or fulfilled by commercial partners.
To add Training metadata to Refine a Large Language Model for code, a
"Prompt Input" is associated with an expected "Code Output", as part of a class definition.
This provide structured keywords to describe:
* The expected output
* And / Or Chain-of-thought to generate the correct output
| /// The following Prompt describes the full implementation of the class
Class alwo.Calculator [Abstract, Prompt = "Provides methods to Add, Subtract, Multiply and divide given numbers." ]
{
/// The following Prompt describes the full implementation of the method
ClassMethod Add(arg1 As %Float, arg2 As %Float) As %Float [ Prompt ="Add numeric arguments and return result." ]
{
return arg1 + arg2
}
ClassMethod Subtract(arg1 as %Float, arg2 As %Float)
{
&Prompt("Subtract numeric arguments and return result")
)
}
|
The Prompt macro generates code based on the context of the method it is within.
Once resolved, it automatically comments out the processed macro.
| ClassMethod Subtract(arg1 as %Float, arg2 As %Float)
{
//&Prompt("Subtract arguments and return the result")
return arg1 - arg2
//&Prompt("Model alwogen-objectscript-7.1.3")
) |
The generator leveraged at compilation time could be configured in a similar way to how source control is configured for a namespace.
Configuration could lock / exclude packages from being processed in this way.
A "\prompt" compilation flag could be used to control the default environment behavior and editor compilation behavior. For example to force reprocessing of previously resolved prompts due to a newer more capable version of code Large Language Model, then a "\prompt=2" could be applied.
Different models or third-party services could be applied depending the language of the given method.
When redacting source code by "deployment", the existing "deploy" facility could be extended to also ensure removal of "Prompt" metadata from code. Vote |
SQLgateway-migration-ibmDB2-IRISshow migration with SQL gateway from IBM DB2 | Robert Cemper | | 0.0 (0) | 05 Jul, 2026 | 10 | |
SQLgateway-migration-MSsql-IRISShow connection to MSsqlServer from SQLgateway with JDBC | Robert Cemper | | 0.0 (0) | 05 Jul, 2026 | 14 | |
SQLgateway-migration-mysql-IRISstraight IRIS with JDBC driver as only external part | Robert Cemper | | 5.0 (1) | 03 Jul, 2026 | 22 | |
pxw-lib-sqlA replacement of SQLQuery that helps simplfy complex queries | P Paul Waterman | | 4.0 (1) | 06 Jun, 2026 | 256 | 13 |
sqljsonadaptorMakes %JSON.Adaptor methods accessible via SQL. | D David Hockenbroch | | 5.0 (1) | 11 May, 2026 | 67 | 6 |
DictionaryManagementDictionary management, enabling the quick lookup function of code and value pairs | B Brown Lucas | | 5.0 (1) | 21 Feb, 2026 | 104 | |
iris-searchtable-configSearchtable Config is a web tool for service configuration and XPath extraction, enabling users to manage XML XPath configurations for different services, with XML formatting, node selection, and XPath extraction capabilities. | d david Brown | | 4.5 (1) | 14 Feb, 2026 | 80 | |
iris-graphql-demoExample of using GraphQL with InterSystems IRIS with Graphene, S | A Alberto Fuentes | | 5.0 (1) | 10 Feb, 2026 | 295 | |
M-N-external-JSONExport M:N Relationship with JSON using SQL | Robert Cemper | | 5.0 (1) | 25 Jan, 2026 | 295 | 1 |
foreign-tablesexample for using Foreign Tables with CSV | Robert Cemper | | 5.0 (1) | 25 Jan, 2026 | 225 | |
iris-pgwirePostgreSQL wire protocol server for InterSystems IRIS - Connect any PostgreSQL client to IRIS | Thomas Dyar | | 0.0 (0) | 26 Dec, 2025 | 57 | |
iris-airflow-providerApache Airflow provider for InterSystems IRIS. | Muhammad Waseem | | 0.0 (0) | 10 Dec, 2025 | 191 | |
sqlancer-irisAutomated SQL Testing for InterSystems IRIS Using Differential O | Dmitry Maslennikov | | 0.0 (0) | 04 Dec, 2025 | 154 | |
demo-dbs-irisThis project provides a Docker container running an InterSystems IRIS database. The database includes multiple namespaces, each featuring demo datasets designed for exploring various scenarios, including data analysis, application prototyping, and testing. | A Andreas Schneider | | 5.0 (1) | 23 Nov, 2025 | 576 | |
iris-cdc-sampleSample how to do CDC using IRIS, Postgresql, Kafka, Collumnar DB and BAM | Yuri Marx | | 5.0 (1) | 18 Nov, 2025 | 131 | |
TablePluseTablePluse is an integrated tool designed to help developers and teams explore and understand SQL database tables, relationships, and schema structures. It provides a clear, visual way to analyze databases and lays the foundation for future features like UI screen planning and application mapping. | Ashok Kumar Thangavel | | 5.0 (1) | 28 Oct, 2025 | 93 | |
customer-support-agent-demoAI-powered customer support agent built with Python smolagents and InterSystems IRIS — SQL, RAG, and live interoperability | A Alberto Fuentes | | 4.5 (1) | 29 Aug, 2025 | 214 | |
iris-message-searchQuery messages for multiple services based on conditions | s sara aplin | | 4.5 (1) | 25 Jul, 2025 | 129 | 1 |
jupyter-for-moneyMy first Jupyter notebook | O Oliver Wilms | | 5.0 (1) | 04 May, 2025 | 189 | |
Jupyter Server Proxy for VS CodeVS Code extension to provide a local Jupyter server acting as a proxy for IRIS servers defined in Server Manager | John Murray | | 5.0 (1) | 02 Jan, 2025 | 509 | |
iris-presto-sampleSample for iris-presto package (using IRIS and PrestoDB ) | Yuri Marx | | 5.0 (1) | 17 Nov, 2024 | 345 | |
IRIS-Log-MonitorMonitor and display some information,Can be viewed more convenie | s sara aplin | | 3.0 (1) | 22 Sep, 2024 | 209 | 2 |
DataAIhttp://DataAI.link - Where Data Meets Intelligence! | I Irina Yaroshevskaya | | 0.0 (0) | 03 Aug, 2024 | 127 | |
iris-VectorLabThe application demonstrates the functionality of Vector Search. | Muhammad Waseem | | 5.0 (1) | 15 May, 2024 | 427 | 19 |
Hackupc24_interText-to-video application based on user photos. | J Jonathan Rodríguez Barja | | 0.0 (0) | 05 May, 2024 | 255 | |
iris-fhirsqlbuilder-dbt-integratedmlDemonstration of building predictive models trained on FHIR data | Thomas Dyar | | 0.0 (0) | 29 Mar, 2024 | 274 | |
SQLToolsVS Code database management for InterSystems IRIS | L Laurel James (GJS) | | 0.0 (0) | 12 Mar, 2024 | 544 | |
presto-irisPresto InterSystems IRIS Connector | Dmitry Maslennikov | | 5.0 (1) | 01 Feb, 2024 | 478 | |