Getting it into your agent
One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.
npx agentmods add rules/secondlifes/delphi-expert/firebird-patternsgit clone --depth 1 https://github.com/SecondLifes/delphi-expertWrote this? Show the measurements
A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.
[](https://agentmods.dev/rules/secondlifes/delphi-expert/firebird-patterns)<a href="https://agentmods.dev/rules/secondlifes/delphi-expert/firebird-patterns"><img src="https://agentmods.dev/badge/rules/secondlifes/delphi-expert/firebird-patterns.svg" alt="Measured on agentmods" height="20"></a>What it costs to keep this loaded
Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5 | $0.00000 | $0.01053 |
| Opus 5 | $0.00000 | $0.00526 |
| Sonnet 5 | $0.00000 | $0.00211 |
| Haiku 4.5 | $0.00000 | $0.00105 |
Grade A, and why
firebird-patterns scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured today.
A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.
Nothing flagged
None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.
How it starts
The opening of the file, as written. The whole thing — 135 lines — stays where its author put it; the contents beside it link to each section on GitHub.
Firebird Database — Rules
Use these rules when developing with Firebird database via FireDAC.
Connection Required
{ SEMPRE configurar: }
FConnection.DriverName := 'FB';
FConnection.Params.Values['CharacterSet'] := 'UTF8';
FConnection.Params.Values['SQLDialect'] := '3'; { NUNCA Dialect 1 }
Generators and Auto-Increment
| Approach | Version | Example |
|---|---|---|
GEN_ID(generator, 1) |
All | Classic with BI trigger |
NEXT VALUE FOR seq |
FB 3+ | Standard SQL Syntax |
IDENTITY |
FB 3+ | GENERATED BY DEFAULT AS IDENTITY |
RETURNING id |
All | Returns ID after INSERT |
RETURNING — Critical Rule
//❌ ExecSQL loses the returned value!
LQuery.SQL.Text := 'INSERT INTO ... RETURNING id';
LQuery.ExecSQL;
//✅ Open to receive RETURNING
LQuery.SQL.Text := 'INSERT INTO ... RETURNING id';
LQuery.Open;
LId := LQuery.Fields[0].AsInteger;
Stored Procedures
| Type | SUSPEND | Delphi Call |
|---|---|---|
| Selectable (returns data) | Yes | SELECT * FROM SP_NOME(...) + Open |
| Executable (action) | No | EXECUTE PROCEDURE SP_NOME(...) + ExecSQL |
Transactions
{ Transação explícita para operações compostas }
FConnection.StartTransaction;
try
FRepoA.Insert(LObjA);
FRepoB.Insert(LObjB);
FConnection.Commit;
except
FConnection.Rollback;
raise;
end;
| Isolation | FireDAC | Usage |
|---|---|---|
| Read Committed | xiReadCommitted |
✅ CRUD Standard |
| Snapshot | xiSnapshot |
Consistent reporting |
| Serializable | xiSerializable |
Exclusive Lock (Rare) |
Firebird Error Handling
except
on E: EFDDBEngineException do
begin
case E.Kind of
ekRecordLocked:
raise EConflictException.Create('Registro bloqueado');
ekUKViolated:
raise EDuplicateException.Create('Registro duplicado: ' + E.Message);
ekFKViolated:
raise EDependencyException.Create('Violação de FK: ' + E.Message);
else
raise;
end;
end;
end;
What this file has done since we first saw it
Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.
- today First seen · 135 lines · 0 tokens per session scan A f61f489e2198
firebird-patterns is a cursor rule published in the GitHub repository SecondLifes/delphi-expert (3 stars, last pushed 2d ago), licensed MIT. It costs nothing until one of its globs matches a file; then it loads 1,053 tokens. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-03.
Other cursor rules, from other repositories
prefer-assertions-over-defensive-checks
Prefer assertions over defensive checks when data is guaranteed to be valid.
as-contract-cast-smell
// ❌ WRONG — bypasses the family ContractSerializer seam const contract = JSON.parse(raw) as Contract; const contract = JSON.parse(raw) as Contract .
no-backward-compatibility
Do not add backward-compatibility shims or migration scaffolding.
aws-rds-best-practices
AWS RDS PostgreSQL best practices - database configuration, connection management, authentication, backup, and performance optimization standards.
database
Database rules — apply when working with database schemas, queries, migrations, or ORM models.
database
Cursor rule "database" from ItamarZand88/awesome-agent-conventions, covering database best practices, prisma setup, prisma models, prisma queries and supabase setup.