📦
tool-discovery
87Choose the Right AI Tool for Every Task
Choosing between many skills and agents can delay technical work. This skill maps each task to focused tools using concise catalogs and selection rules.
Productivity View
Skills sql-patterns
📦
sql-patterns
Content revision r1 Low Risk ⚙️ External commands
Apply Practical SQL Query Patterns
SQL teams often need reliable examples for common query patterns and performance decisions. This skill provides concise references for CTEs, window functions, joins, pagination, and indexes.
Supports: Claude Codex Code(CC)
Install with my Agent
Copy this request to your Agent. It includes the canonical Skill page and manifest.
Agent request
Review the Skillstore skill "sql-patterns" from https://skillstore.io/skills/0xdarkmatter-sql-patterns.md and its manifest at https://skillstore.io/api/skills/0xdarkmatter-sql-patterns/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.Your Agent should still show its plan and request any confirmation required by the security policy.
Agent-readable resources
Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.
Test it
Using "sql-patterns". I need the latest order per user without duplicate rows.
Expected outcome:
A response explains row-number deduplication, partitioning by user, sorting by update time, and filtering to the first row.
Using "sql-patterns". My product list uses high offset pagination and is slow.
Expected outcome:
A response compares offset pagination with keyset pagination and recommends a stable sort column for large result sets.
Using "sql-patterns". Which index helps filters on status and created date?
Expected outcome:
A response discusses selectivity, equality filters, range filters, and composite index column order.
Security Audit
Low Riskv6 • 7/6/2026 Open versioned report
All static command-execution and reconnaissance alerts were false positives from Markdown SQL examples, inline SQL function names, and database indexing terminology. I found no prompt-injection text, data-exfiltration intent, or real shell execution. The only semantic issue is overbroad Write permission in SKILL.md for a read-only SQL reference skill.
3
Files scanned
733
Lines analyzed
0
Review items
0
False positives ignored
Confirmed security concerns (1)
Low
Unnecessary Write Tool Permission
SKILL.md declares allowed-tools: Read Write, but the skill content only provides SQL reference material and asks users to load Markdown references. This grants file write capability without a demonstrated need.
The frontmatter explicitly includes Write, while the reviewed SKILL.md content is read-only reference documentation with no editing workflow.
Risk Factors
⚙️ External commands (23)
SKILL.md:13-20 SKILL.md:20-24 SKILL.md:24-36 SKILL.md:36-42 SKILL.md:42-43 SKILL.md:43-44 SKILL.md:44-45 SKILL.md:45-46 SKILL.md:46-47 SKILL.md:47-48 SKILL.md:48-50 SKILL.md:50-57 SKILL.md:57-63 SKILL.md:63-64 SKILL.md:64-65 SKILL.md:65-66 SKILL.md:66-70 SKILL.md:70-76 SKILL.md:76-91 SKILL.md:91-92 SKILL.md:92 SKILL.md:93 SKILL.md:99-100
Audited by: codex View Audit History →
Share & cite this report
Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.
Copy report link
https://skillstore.io/skills/0xdarkmatter-sql-patterns/audits/6?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_reportMarkdown badge
[](https://skillstore.io/skills/0xdarkmatter-sql-patterns?utm_source=security_passport_badge)HTML badge
<a href="https://skillstore.io/skills/0xdarkmatter-sql-patterns?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/0xdarkmatter-sql-patterns/security.svg" alt="Skillstore security assessment" loading="lazy"></a>Embed card
<iframe src="https://skillstore.io/embed/skills/0xdarkmatter-sql-patterns.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>Academic citations (APA · BibTeX · CFF)
APA citation
0xDarkMatter. (2026). sql-patterns security audit report (audit version 6) [Author version unspecified]. Skillstore. https://skillstore.io/skills/0xdarkmatter-sql-patterns/audits/6BibTeX citation
@techreport{0xdarkmatter-0xdarkmatter-sql-patterns-2026,
author = {0xDarkMatter},
title = {sql-patterns security audit report (audit version 6)},
institution = {Skillstore},
year = {2026},
number = {6},
url = {https://skillstore.io/skills/0xdarkmatter-sql-patterns/audits/6},
note = {Author version unspecified}
}CITATION.cff
cff-version: 1.2.0
message: "If you use this Skill, cite its author and this versioned security audit report."
title: "sql-patterns security audit report (audit version 6)"
version: "unspecified"
type: report
authors:
- name: "0xDarkMatter"
date-released: "2026-07-06"
url: "https://skillstore.io/skills/0xdarkmatter-sql-patterns/audits/6"
identifiers:
- type: other
value: "skillstore:0xdarkmatter-sql-patterns:audit:6"
description: "Skillstore immutable audit report identifier"
Skillstore Score
Why this score Evidence Confidence: High 41
Architecture
85
Maintainability
87
Content
72
Community
83
Spec Compliance
What You Can Build
Design analytical queries
Build rankings, running totals, session detection, and deduplication with window function examples.
Review application SQL
Compare joins, pagination choices, and anti-pattern fixes during code review.
Plan index changes
Choose index types and column order before proposing database migrations.
Try These Prompts
Find a basic pattern
Use the sql-patterns skill to show a simple CTE pattern for filtering active users. Explain when to use it.
Compare query choices
Use the sql-patterns skill to compare offset pagination and keyset pagination for a product list.
Improve an analytical query
Use the sql-patterns skill to suggest window function patterns for ranking, running totals, and deduplication in a sales report.
Plan indexing strategy
Use the sql-patterns skill to review a query with filters, sorting, and joins. Recommend index types and column order.
Best Practices
- Share the database engine and version before asking for syntax guidance.
- Include table sizes, filter columns, sort columns, and join keys when requesting index advice.
- Ask for tradeoffs when choosing between readability, portability, and performance.
Avoid
- Treating the examples as production-ready without adapting names, types, and constraints.
- Requesting index advice without sharing the query shape or expected cardinality.
- Using SELECT star in examples that need stable, reviewed column lists.
Frequently Asked Questions
Does this skill run SQL queries?
No. It provides reference patterns and explanations. It does not connect to a database.
Which SQL engines are covered?
The examples focus on common SQL concepts and include PostgreSQL-style indexing notes.
Can it help with performance reviews?
Yes. It can point to indexing, pagination, and anti-pattern checks for human review.
Can it replace a database expert?
No. It supports analysis but cannot inspect workload, data distribution, or production constraints.
Does it include window function examples?
Yes. It covers ranking, navigation functions, running totals, session detection, and deduplication.
Can Claude Code or Codex use it in repositories?
Yes. Claude Code and Codex can use the references while reviewing SQL files.
Developer Details
Author
0xDarkMatterLicense
MIT
Skillstore revision
r1
Version notice
The author did not declare a version.
Ref
c1fdca50ff516318f65fed0d7f9e82797c5171dc
Maintenance freshness
7/18/2026
Usage
26 downloads · 338 views
File structure
More from 0xDarkMatter
View all📦
python-async-patterns
85Build Reliable Async Python
Async Python code often fails due to blocking calls, unbounded tasks, and weak cleanup. This skill provides reusable asyncio patterns, examples, and references for robust concurrent services.
Coding & Development View
📦
python-fastapi-patterns
85Build FastAPI APIs with Reusable Patterns
FastAPI projects need consistent choices for validation, dependencies, middleware, and background work. This skill gives Claude, Codex, and Claude Code reusable patterns for practical Python API development.
Coding & Development View
📦
python-typing-patterns
85Add Python Type Safety Patterns
Python type annotations can be hard to apply consistently across real projects. This skill gives Claude, Codex, and Claude Code practical patterns for safer typed Python code.
Coding & Development View
📦
structural-search
85Search Code by AST Structure
Text searches miss semantic relationships and produce noisy matches. This skill uses ast-grep patterns to locate code structures and prepare focused refactors.
Coding & Development View
📦
data-processing
84Process JSON, YAML, and TOML Data
Structured configuration data can be hard to inspect across JSON, YAML, and TOML files. This skill guides jq and yq queries for extraction, filtering, conversion, and updates.
Data & Analytics View
Related Skills
View all📦
sql-optimization-patterns
78Optimize SQL Queries With Index Patterns
by wshobson
Slow SQL queries increase latency and database costs. This skill guides query plans, indexes, pagination, batching, and maintenance choices.
Data & Analytics View
📦
postgresql-table-design
78Design PostgreSQL Tables
by wshobson
PostgreSQL schemas can fail when data types, constraints, and indexes are chosen without workload context. This skill guides table design with PostgreSQL-specific rules for durable, performant, and maintainable schemas.
Data & Analytics View
📦
database-optimizer
78Optimize Database Performance and Scalability
by sickn33
Slow queries and weak database designs can raise latency, cost, and operational risk. This skill provides evidence-based guidance for queries, indexes, caching, scaling, migrations, and monitoring.
Data & Analytics View
📦
database-schema-designer
80Design Production Database Schemas
by softaworks
Teams need schemas that preserve data integrity and stay fast as products grow. This skill turns domain requirements into SQL or MongoDB designs with indexes, constraints, and migration guidance.
Data & Analytics View
📦
postgresql-optimization
80Optimize PostgreSQL Performance
by sickn33
Slow PostgreSQL systems need structured analysis before changes. This skill guides query tuning, index planning, configuration review, maintenance, and monitoring.
Data & Analytics View
📦
sql-queries-tool
79Generate SQL Queries for DBX Studio
by Dbxstudio
Database users need reliable SQL that matches their connection type and schema. This skill guides Claude, Codex, and Claude Code to inspect schemas, write read-only queries, and explain results clearly.
Data & Analytics View