How do I install the Isimplequery Contract skill?

Run npx skillmds@latest add academiadocodigo/isimplequery-contract in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Isimplequery Contract safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Isimplequery Contract?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Isimplequery Contract free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Isimplequery Contract?

academiadocodigo (@academiadocodigo) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Isimplequery Contract by academiadocodigo

Name: Isimplequery Contract
Author: academiadocodigo

File contents

iSimpleQuery Interface Contract

Rules are in .claude/rules/isimplequery-contract.md — this skill provides the interface definition and usage reference.

Interface Definition (SimpleInterface.pas)

iSimpleQuery = interface
  ['{6DCCA942-736D-4C66-AC9B-94151F14853A}']
  function SQL: TStrings;
  function Params: TParams;
  function ExecSQL: iSimpleQuery;
  function DataSet: TDataSet;
  function Open(aSQL: String): iSimpleQuery; overload;
  function Open: iSimpleQuery; overload;
  function StartTransaction: iSimpleQuery;
  function Commit: iSimpleQuery;
  function Rollback: iSimpleQuery;
  function &EndTransaction: iSimpleQuery;
  function InTransaction: Boolean;
  function SQLType: TSQLType;
end;

Method-by-Method Reference

Method	Returns	Purpose
`SQL`	TStrings	Writable SQL text (DAO writes before Open/ExecSQL)
`Params`	TParams	Query parameters (DAO writes before Open/ExecSQL)
`ExecSQL`	Self	Executes INSERT/UPDATE/DELETE
`DataSet`	TDataSet	Query result after Open
`Open(aSQL)`	Self	Sets SQL and opens in one call
`Open`	Self	Opens with SQL already set
`StartTransaction`	Self	Begins transaction (check InTransaction first)
`Commit`	Self	Commits active transaction
`Rollback`	Self	Rolls back active transaction
`&EndTransaction`	Self	Delegates to Commit
`InTransaction`	Boolean	True if transaction is active
`SQLType`	TSQLType	Database type (Firebird, MySQL, SQLite, Oracle)

Constructor Pattern

constructor Create(aConnection: TXxxConnection; aSQLType: TSQLType = TSQLType.Firebird);
class function New(aConnection: TXxxConnection; aSQLType: TSQLType = TSQLType.Firebird): iSimpleQuery;

Existing Drivers

Driver	Connection Type	File
FireDAC	`TFDConnection`	`SimpleQueryFiredac.pas`
UniDAC	`TUniConnection`	`SimpleQueryUnidac.pas`
Zeos	`TZConnection`	`SimpleQueryZeos.pas`
RestDW	`TRESTDWClientSQL`	`SimpleQueryRestDW.pas`
Horse (REST)	HTTP URL string	`SimpleQueryHorse.pas`

How TSimpleDAO Uses iSimpleQuery

DAO writes SQL to query.SQL
DAO writes params to query.Params
For SELECT: calls query.Open then reads query.DataSet
For INSERT/UPDATE/DELETE: calls query.ExecSQL
Batch operations: query.StartTransaction → operations → query.Commit (or Rollback on error)

---name: isimplequery-contractdescription: The exact iSimpleQuery interface contract that all query drivers must implement. Reference for creating or reviewing drivers.---# iSimpleQuery Interface Contract> **Rules are in `.claude/rules/isimplequery-contract.md`** — this skill provides the interface definition and usage reference.## Interface Definition (SimpleInterface.pas)```pascaliSimpleQuery = interface ['{6DCCA942-736D-4C66-AC9B-94151F14853A}'] function SQL: TStrings; function Params: TParams; function ExecSQL: iSimpleQuery; function DataSet: TDataSet; function Open(aSQL: String): iSimpleQuery; overload; function Open: iSimpleQuery; overload; function StartTransaction: iSimpleQuery; function Commit: iSimpleQuery; function Rollback: iSimpleQuery; function &EndTransaction: iSimpleQuery; function InTransaction: Boolean; function SQLType: TSQLType;end;```## Method-by-Method Reference| Method | Returns | Purpose ||--------|---------|---------|| `SQL` | TStrings | Writable SQL text (DAO writes before Open/ExecSQL) || `Params` | TParams | Query parameters (DAO writes before Open/ExecSQL) || `ExecSQL` | Self | Executes INSERT/UPDATE/DELETE || `DataSet` | TDataSet | Query result after Open || `Open(aSQL)` | Self | Sets SQL and opens in one call || `Open` | Self | Opens with SQL already set || `StartTransaction` | Self | Begins transaction (check InTransaction first) || `Commit` | Self | Commits active transaction || `Rollback` | Self | Rolls back active transaction || `&EndTransaction` | Self | Delegates to Commit || `InTransaction` | Boolean | True if transaction is active || `SQLType` | TSQLType | Database type (Firebird, MySQL, SQLite, Oracle) |## Constructor Pattern```pascalconstructor Create(aConnection: TXxxConnection; aSQLType: TSQLType = TSQLType.Firebird);class function New(aConnection: TXxxConnection; aSQLType: TSQLType = TSQLType.Firebird): iSimpleQuery;```## Existing Drivers| Driver | Connection Type | File ||--------|----------------|------|| FireDAC | `TFDConnection` | `SimpleQueryFiredac.pas` || UniDAC | `TUniConnection` | `SimpleQueryUnidac.pas` || Zeos | `TZConnection` | `SimpleQueryZeos.pas` || RestDW | `TRESTDWClientSQL` | `SimpleQueryRestDW.pas` || Horse (REST) | HTTP URL string | `SimpleQueryHorse.pas` |## How TSimpleDAO Uses iSimpleQuery1. DAO writes SQL to `query.SQL`2. DAO writes params to `query.Params`3. For SELECT: calls `query.Open` then reads `query.DataSet`4. For INSERT/UPDATE/DELETE: calls `query.ExecSQL`5. Batch operations: `query.StartTransaction` → operations → `query.Commit` (or Rollback on error)

Frequently asked questions

Isimplequery Contract