sql-code-review SKILL.md skillA
sql-code-review from marielynneblock/arcanum-artifex is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.
mdr add marielynneblock/arcanum-artifex/sql-code-review@git:20260710.0115f49Pins git:20260710.0115f49 in mdr.lock. Pin the fingerprint instead.
- Audit grade
- A, 17 of 17 checks passed
- Kind
- SKILL.md skill
- Repository
- marielynneblock/arcanum-artifex
- Path
skills/development/sql/sql-code-review/SKILL.md- Versions recorded
- 4
- Latest version
- git:20260710.0115f49, committed Jul 10, 2026
- First version recorded
- May 10, 2026
- Size
- 8,971 bytes
- Repository stars
- 4
- License
- none declared
Universal SQL code review assistant that performs comprehensive security, maintainability, and code quality analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Focuses on SQL injection prevention, access control, code standards, and anti-pattern detection. Complements SQL optimisation prompt for complete development coverage.
Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.
What the file says
# SQL Code Review
Perform a thorough SQL code review of ${selection} (or entire project if no selection) focusing on security, performance, maintainability, and database best practices.
## 🔒 Security Analysis
### SQL Injection Prevention
```sql
-- ❌ CRITICAL: SQL Injection vulnerability
query = "SELECT * FROM users WHERE id = " + userInput;
query = f"DELETE FROM orders WHERE user_id = {user_id}";
-- ✅ SECURE: Parameterized queries
-- PostgreSQL/MySQL
PREPARE stmt FROM 'SELECT * FROM users WHERE id = ?';
EXECUTE stmt USING @user_id;
-- SQL Server
EXEC sp_executesql N'SELECT * FROM users WHERE id = @id', N'@id INT', @id = @user_id;
```
### Access Control & Permissions
- **Principle of Least Privilege**: Grant minimum required permissions
- **Role-Based Access**: Use database roles instead of direct user permissions
- **Schema Security**: Proper schema ownership and access controls
- **Function/Procedure Security**: Review DEFINER vs INVOKER rights
### Data Protection
- **Sensitive Data Exposure**: Avoid SELECT * on tables with sensitive columns
- **Audit Logging**: Ensure sensitive operations are logged
- **Data Masking**: Use views or functions to mask sensitive data
…Read the whole file at its exact version.
How to install
mdr add marielynneblock/arcanum-artifex/sql-code-review@sha256:5695fd8ceba21a2cThe line at the top of this page pins the label git:20260710.0115f49, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.
[](https://markdownregistry.com/a/art_2dwyfaeckrxbhh2e)
6 badge image fetches in 30 days. What the badge shows.
Versions
The registry has recorded 4 versions of this file, between May 10, 2026 and Jul 10, 2026, about one every 20 days.
| version | committed | commit | size | audit | |
|---|---|---|---|---|---|
| git:20260710.0115f49 latest | 2026-07-10 | 0115f49 | 8,971 B | A | view · diff |
| git:20260710.ffb3400 | 2026-07-10 | ffb3400 | 8,971 B | A | view · diff |
| git:20260515.b861afb | 2026-05-15 | b861afb | 8,971 B | A | view · diff |
| git:20260510.f26bcec | 2026-05-10 | f26bcec | 8,925 B | A | view |
Audit of the latest version
- pass: Frontmatter block present
- pass: Frontmatter declares a name
- pass: Frontmatter declares a description
- pass: Size between 200 bytes and 200 KB (8971 bytes)
- pass: No zero-width or bidi control characters
- pass: No instruction hidden inside an HTML comment
- pass: No link to an exfiltration or paste host
- pass: No credential-shaped string
- pass: No instruction to send local credentials anywhere
- pass: No text hidden with inline styles
- pass: No prompt-injection phrasing
- pass: No curl or wget piped into a shell
- pass: No recursive delete of root, home or parent
- pass: No instruction to read or print local credentials
- pass: No base64 blob over 200 characters
- pass: No link to a raw IP address
- pass: No script tag
Source
marielynneblock/arcanum-artifex · 4 stars · license none declared · pushed 2026-09-19 · branch main
API
GET https://markdownregistry.com/api/v1/artifacts/art_2dwyfaeckrxbhh2e GET https://markdownregistry.com/api/v1/resolve?ref=marielynneblock/arcanum-artifex/sql-code-review GET https://markdownregistry.com/api/v1/blob/5695fd8ceba21a2c0c7179a17ceebaac6e762cb855cafecf6fa68fcb7c0fd832
Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.
Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.
More from marielynneblock/arcanum-artifex
Every file in marielynneblock/arcanum-artifex