Map Delphi classes to a relational database using TMS Aurelius ORM attributes. Use when the user asks to create entity classes, add Aurelius mapping to existing classes, fix or review mapping attributes, explain how a class is mapped, or work with associations, inheritance, automapping, nullable fields, blobs, or…
Save, load, update, delete, merge, and navigate entity objects using TMS Aurelius ORM (TObjectManager). Use when the user asks how to persist or retrieve data with Aurelius, manage object lifetime, work with associations or collections at runtime, handle transactions, use cached updates, or control concurrency. Does…
Pragmatic clean code standards for Delphi — concise, direct, no over-engineering. Use when writing new code or establishing conventions, not for auditing already-written code (see code-review) or restructuring existing code without changing behavior (see refactoring).
Delphi code review checklist — quality, security, performance, SOLID, memory. Use when auditing or reviewing already-written code (e.g. a diff or PR) against these criteria, not when writing new code (see clean-code) or restructuring existing code (see refactoring).
Consuming HTTP/REST APIs from Delphi — THTTPClient (System.Net.HttpClient), TNetHTTPClient, and the TRESTClient stack (REST.Client), with JSON handling, timeouts, authentication, async patterns and error handling. Use whenever Delphi code CALLS an external API — the server-side counterpart skills (horse-framework…
Implementation of the 23 GoF (Gang of Four) patterns in Object Pascal / Delphi with interfaces, TInterfacedObject and SOLID principles. Covers Creational, Structural and Behavioral patterns.
Use when building a DelphiMVCFramework service with lambda/anonymous-method routes instead of controller classes — Minimal API. Triggers on "minimal API", "MapGet", "MapPost", "MapMethods", "route group", "endpoint filter", "HTTP filter", "TMVCRouteGroup", "AsWeb", "lambda routes", "no controller", "Prefix"…
Use when writing or fixing tests for a DelphiMVCFramework API — integration tests that drive real HTTP against an in-process server, or unit tests around controllers. Covers the DUnitX + in-process IMVCServer + IMVCRESTClient stack, CRUD/auth/authorization test patterns, database fixtures and the console runner.…
Skill "dmvcframework-ui" from SecondLifes/delphi-expert, covering dmvcframework — ui layer (bootstrap 5.3 + style.css), when in doubt about an api — verify it, never guess, 1. what baselayout.html gives you, 2. the navbar — adding an entry and 3. theme (dark / light).
Use when building a server-side web application with DelphiMVCFramework — HTML pages and HTMX fragments rendered by TemplatePro. Covers view engine setup, template inheritance and blocks, ViewData and its ownership rules, fragments, custom filters, cookie/JWT login, static files, and the HTMX request/response helpers…
Use when writing any server-side feature with DelphiMVCFramework (DMVC) — controllers, routes, REST endpoints, entities, middleware, validation, dependency injection, JWT, SSE, or the server bootstrap. The core skill; the Minimal API, web-app, UI, security and testing skills build on it. Triggers on "DMVCFramework"…
Use when writing Delphi / FreePascal / C++Builder code that reads, writes, manipulates, or exports Excel (.xlsx / .xls) files, generates PDF or HTML from Excel, or produces data-driven reports with FlexCel Studio for VCL and FireMonkey (TMS FlexCel). Triggers include Excel/xlsx from Delphi, TXlsFile, TFlexCelReport…
Use when you need accurate htmx syntax or behavior — attributes, triggers, swap modifiers, events, request/response headers, the JS API, extensions, or a worked example. Indexes every page of the official htmx.org documentation with a description, so the right page can be fetched and read instead of recalled from…