Reviews SQL queries for correctness, performance and safety problems such as SELECT star, missing indexes, unbounded updates, implicit casts and injection risks. Use when the user asks to optimize a query, explain why a query is slow, or check SQL before it runs on production data.
中文简介正在准备中。当前显示原文说明。
实测评分 未实测
查看安装方法安装前可以查看交给 AI 代理的指令内容。
UPDATE or DELETE on real data.Safety first
UPDATE or DELETE without a WHERE clause. Ask for confirmation and suggest running a SELECT COUNT(*) with the same condition first.Correctness
NULL comparisons written with = instead of IS NULL.LEFT JOIN followed by a WHERE condition on the right table, which silently turns it into an inner join.GROUP BY that does not match the selected columns, and COUNT(column) used where COUNT(*) was meant.NOT IN with a subquery that can return NULL. Prefer NOT EXISTS.Performance
SELECT * on wide tables. List the columns that are used.WHERE (WHERE LOWER(email) = ...). Suggest an expression index or a different predicate.LIKE '%term') that cannot use an index.EXPLAIN output instead of guessing.OFFSET pagination on large tables. Suggest keyset pagination.ORDER BY without LIMIT on large results, and DISTINCT used to hide a bad join.EXPLAIN output was given, ask for it and say what to look for (sequential scans, row estimates far from actual rows).Input: DELETE FROM sessions WHERE created_at < now() - interval '30 days'
Review: valid, but deletes an unknown number of rows. Run SELECT COUNT(*) with the same condition first, delete
in batches if the count is large, and keep it inside a transaction until the result looks right.
If the schema is unknown, say which assumptions the review makes about indexes and types.
还没有评价。欢迎分享你的使用感受。
无需登录即可发表。欢迎分享使用感受、提问，或说明在哪些环境下无法运行。
还没有评论。来写第一条吧。
Runs a list of HTTP checks against a base URL from a JSON file and reports status codes, response time and body assertions. Use when the user asks whether an API is up, wants a smoke test after a deploy, or needs to verify that endpoints return what the docs promise.
中文简介正在准备中。当前显示原文说明。
Turns git log output into a grouped markdown changelog using conventional commit prefixes such as feat, fix and docs. Use when the user prepares a release, asks for release notes, or wants a summary of what changed between two tags.
中文简介正在准备中。当前显示原文说明。
Writes clear git commit messages in the conventional commits style from a diff or a description of the change. Use when the user asks for a commit message, wants to tidy up a message before pushing, or has staged changes and no wording yet.
中文简介正在准备中。当前显示原文说明。
Profiles a CSV file column by column, reporting inferred type, missing values, unique counts and min, max and mean for numeric columns. Use when the user hands over a CSV and asks what is in it, whether the data is clean, or what to check before analysis.
中文简介正在准备中。当前显示原文说明。
Checks a Dockerfile for common problems such as unpinned base images, running as root, ADD instead of COPY, secrets in ENV or ARG and apt-get without cleanup. Use when the user asks to review, harden or slim down a Dockerfile.
中文简介正在准备中。当前显示原文说明。
Compares a .env file with its .env.example template and reports missing keys, undocumented extra keys, empty values and example files that contain real looking secrets. Use when the user asks why an app fails on startup with missing configuration, or wants to check environment files before committing.
中文简介正在准备中。当前显示原文说明。