Skills sql-query-builder
📦

sql-query-builder

v1.0.0 Content revision r1 Safe

Build SQL Queries From Plain Language

Teams often spend time turning data questions into reliable SQL. This skill converts plain language into SQL guidance with execution-plan review and optimization advice.

Supports: Claude Codex Code(CC)
🥈 80 Silver

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-query-builder" from https://skillstore.io/skills/zhangchenlai-dev-sql-query-builder.md and its manifest at https://skillstore.io/api/skills/zhangchenlai-dev-sql-query-builder/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.

Markdown detail GET /skills/zhangchenlai-dev-sql-query-builder.md Signed manifest GET /api/skills/zhangchenlai-dev-sql-query-builder/manifest Signed lockfile GET /api/skills/zhangchenlai-dev-sql-query-builder/lockfile

Test it

Using "sql-query-builder". Find monthly revenue by region from orders and customers.

Expected outcome:

The skill returns a grouped query approach, explains required joins, and notes indexes that may help date and region filters.

Using "sql-query-builder". Review a slow customer activity query before production use.

Expected outcome:

The skill highlights likely scan and join risks, suggests filter changes, and lists schema details needed for a safer final query.

Using "sql-query-builder". Create a PostgreSQL query for active subscriptions ending this month.

Expected outcome:

The skill drafts PostgreSQL-oriented SQL guidance, states assumptions about status fields, and recommends validation against real table definitions.

Security Audit

Safe
v5 • 7/8/2026 Open versioned report

The high-entropy static finding is a false positive. SKILL.md is readable Markdown with front matter and short SQL assistant documentation, not binary or encrypted content. No prompt injection, data exfiltration intent, or hidden execution behavior was found.

1
Files scanned
34
Lines analyzed
0
Review items
0
False positives ignored
No confirmed security findings were detected by the latest completed static and semantic audit. This does not prove the skill has no side effects.
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.

Open versioned report
Security Assessment

Copy report link

https://skillstore.io/skills/zhangchenlai-dev-sql-query-builder/audits/5?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown badge

[![Skillstore security assessment](https://skillstore.io/badges/skills/zhangchenlai-dev-sql-query-builder/security.svg)](https://skillstore.io/skills/zhangchenlai-dev-sql-query-builder?utm_source=security_passport_badge)

HTML badge

<a href="https://skillstore.io/skills/zhangchenlai-dev-sql-query-builder?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/zhangchenlai-dev-sql-query-builder/security.svg" alt="Skillstore security assessment" loading="lazy"></a>

Embed card

<iframe src="https://skillstore.io/embed/skills/zhangchenlai-dev-sql-query-builder.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

Hermes-Sedimentary. (2026). sql-query-builder security audit report (audit version 5) [Author version 1.0.0]. Skillstore. https://skillstore.io/skills/zhangchenlai-dev-sql-query-builder/audits/5

BibTeX citation

@techreport{hermes-sedimentary-zhangchenlai-dev-sql-query-builder-2026, author = {Hermes-Sedimentary}, title = {sql-query-builder security audit report (audit version 5)}, institution = {Skillstore}, year = {2026}, number = {5}, url = {https://skillstore.io/skills/zhangchenlai-dev-sql-query-builder/audits/5}, note = {Author version 1.0.0} }

CITATION.cff

cff-version: 1.2.0 message: "If you use this Skill, cite its author and this versioned security audit report." title: "sql-query-builder security audit report (audit version 5)" version: "1.0.0" type: report authors: - name: "Hermes-Sedimentary" date-released: "2026-07-08" url: "https://skillstore.io/skills/zhangchenlai-dev-sql-query-builder/audits/5" identifiers: - type: other value: "skillstore:zhangchenlai-dev-sql-query-builder:audit:5" description: "Skillstore immutable audit report identifier"

Skillstore Score

Why this score Evidence Confidence: Medium
55
Architecture
100
Maintainability
87
Content
67
Community
83
Spec Compliance

What You Can Build

Create Reporting Queries

Turn business questions into draft SQL for metrics, grouped summaries, and filtered reports.

Improve Slow Queries

Review an existing query and get practical ideas for plan analysis and optimization.

Prepare Database Tasks

Draft query approaches before asking a database owner to validate schema details and access rules.

Try These Prompts

Generate a Basic Query 
Create a SQL query for this request: [describe the data question]. Use these tables and columns: [schema details]. Explain any assumptions.
Adapt to a Database Dialect 
Build a [PostgreSQL/MySQL/SQLite/SQL Server] query for this request: [goal]. Use this schema: [schema]. Note dialect-specific choices.
Review an Existing Query 
Review this SQL query for correctness, performance risks, and missing filters: [paste query]. Use this schema context: [schema details].
Plan an Optimized Query 
Design an optimized query for this workload: [goal]. Include likely execution-plan concerns, index suggestions, and tradeoffs for large tables.

Best Practices

  • Provide table names, column names, relationships, and database dialect before asking for SQL.
  • Ask for assumptions and edge cases when queries affect reporting or billing.
  • Validate generated SQL on safe test data before using it in production.

Avoid

  • Do not ask for production-ready SQL without sharing schema details.
  • Do not run generated queries against sensitive data without review.
  • Do not rely on optimization advice without checking real execution plans.

Frequently Asked Questions

Can this skill connect to my database?
No live database connection is documented. It helps draft and review SQL based on the context you provide.
Which database systems does it support?
It can guide SQL for common databases when you specify the dialect. Exact syntax depends on the details you provide.
Can it optimize slow queries?
It can suggest likely optimization ideas and execution-plan concerns. You should confirm them with real database plans.
Does it replace a database administrator?
No. It is an AI assistant for drafting and review. Important changes still need expert validation.
Can I use it with Claude Code or Codex?
Yes. The skill metadata lists support for Claude, Codex, and Claude Code.
What should I include in my prompt?
Include the data goal, table names, column names, relationships, database dialect, and performance constraints.

Developer Details

License

MIT

Author version

v1.0.0

Skillstore revision

r1

Repository

https://github.com/zhangchenlai-dev/hermes-skill-store/tree/master/sql-query-builder

Ref

64ca8af0f54a325752f08bd54e52151061ea659a

Maintenance freshness

7/20/2026

Usage

4 downloads · 0 views

File structure

📄 SKILL.md