sql-queries-not-asts

sql-queries-not-asts is a cursor rule for Codex from prisma/prisma-next. It costs 445 tokens per session, scanned A, a copy of sql-queries-not-asts, Apache-2.0.

A naming rule for calling executable SQL units queries, while reserving AST for the internal tree structures used to build them.

In plain words
What is it for?
It guides names for SQL-building functions, variables, parameters, and collections passed to database drivers.
Why use it?
It keeps names focused on what callers construct and run instead of exposing an implementation detail.

Cursor rule for Codex

Install

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.

agentmods
npx agentmods add rules/prisma/prisma-next/sql-queries-not-asts
Clone the repo
git clone --depth 1 https://github.com/prisma/prisma-next

Made for: Codex.

Wrote 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.

agentmods badge for sql-queries-not-asts

README.md
[![agentmods](https://agentmods.dev/badge/rules/prisma/prisma-next/sql-queries-not-asts.svg)](https://agentmods.dev/rules/prisma/prisma-next/sql-queries-not-asts)
Your own site
<a href="https://agentmods.dev/rules/prisma/prisma-next/sql-queries-not-asts"><img src="https://agentmods.dev/badge/rules/prisma/prisma-next/sql-queries-not-asts.svg" alt="Measured on agentmods" height="20"></a>
Per session 445 This file is loaded in full into every session.
When invoked 445 The same file — it is already loaded in full.
Security scan A 0 findings. Scan, not verified.
Origin 100% copy Near-identical to another mod in the catalogue.
Token cost

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.

ModelPer sessionOnce invoked
Fable 5 $0.00445 $0.00445
Opus 5 $0.00222 $0.00222
Sonnet 5 $0.00089 $0.00089
Haiku 4.5 $0.00044 $0.00044

Measured yesterday against content hash 321f29374e51, method: parsed. Prices are Anthropic first-party input rates as of 2026-08-30, from the pricing page.

Security

Grade A, and why

sql-queries-not-asts 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 yesterday.

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.

Origin

This is a copy

100% identical to sql-queries-not-asts — 0 lines differ, which has more behind it and is treated as the original. This page carries a canonical link to it rather than competing with it.

.agents/rules/sql-queries-not-asts.mdc · 28 lines

What it actually says

In the SQL query surface, the things you build and lower are queries, not "asts"

When you build a node (or a list of nodes) that will be handed to adapter.lower() / family.lowerAst() and executed against the driver, that deliverable is a query. Name methods, functions, variables, and parameters accordingly:

  • bootstrapControlTableQueries(), bootstrapSignMarkerQueries()not *Asts.
  • buildControlTableBootstrapQueries(), buildSignMarkerBootstrapQueries()not *Asts.
  • Local variables: const queries = …, for (const query of queries), schemaQuery, tableQueriesnot asts / ast / schemaAst / tableAsts.

"AST" is the structural noun for the tree shape (DdlNode, AnyQueryAst, the abstract-syntax-tree machinery, a *Visitor). It is not the name for the unit a caller constructs and executes. A function that returns readonly DdlNode[] for the runner to lower is returning queries, even though each element is a node.

Why

  • The codebase's ubiquitous language calls the executed unit a query. Calling collections of them "asts" leaks an implementation noun into surfaces that are about what gets run.
  • This is a repeat correction. Defaulting to *Asts for builder/return names has been flagged more than once in review; pick the right noun at authoring time.

Quick check before staging

git diff --cached -- '*.ts' | rg '^\+' | rg -i '\bbootstrap\w*Asts\b|\bbuild\w*Asts\b|\b\w+Asts\b\s*\(|\bschemaAst\b|\btableAsts\b'

Output should be empty. Structural names (DdlNode, AnyQueryAst, DdlVisitor, accept) are fine and expected.

Changes

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.

  1. yesterday First seen · 28 lines · 445 tokens per session scan A 321f29374e51

Subscribe to this mod's changes

sql-queries-not-asts is a cursor rule published in the GitHub repository prisma/prisma-next (419 stars, last pushed 10d ago), licensed Apache-2.0. It adds 445 tokens to every session, about $0.0022 per session on Opus 5. A static security scan graded it A with 0 findings. It is 100% identical to sql-queries-not-asts, differing in 0 lines, and is treated as a copy.