Optimize SQL Server T-SQL Queries
SQL Server work often requires correct queries, safe dynamic SQL, and performance-aware design. This skill gives Claude, Codex, and Claude Code focused T-SQL guidance for writing, debugging, and tuning database code.
Copy this request to your Agent. It includes the canonical Skill page and manifest.
Review the Skillstore skill "sql-expert" from https://skillstore.io/skills/hmohamed01-sql-expert.md and its manifest at https://skillstore.io/api/skills/hmohamed01-sql-expert/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.
Use these links when an AI agent, crawler, or script needs clean context instead of reading the full page.
Using "sql-expert". A report query filters dates with a function and runs slowly on a large orders table.
Expected outcome:
The response explains why the predicate is not SARGable, rewrites the date filter as a range, and suggests checking an index on the date column with included report fields.
Using "sql-expert". A stored procedure builds a table name from user input for a dynamic search feature.
Expected outcome:
The response recommends a whitelist of allowed table names, identifier escaping, parameterized predicates, and clear rejection of unknown values.
Using "sql-expert". A team needs pagination for a high-volume product catalog.
Expected outcome:
The response compares offset pagination with keyset pagination and recommends keyset pagination when stable sort keys are available.
The skill is documentation-only and contains T-SQL reference material, examples, and security best practices. All static findings are false positives caused by markdown code fences, SQL terminology, SQL Server metadata queries, and educational security examples. No prompt injection, executable code, network access, filesystem access, or malicious intent was found.
Share the versioned assessment report, neutral badge, embed card, and citations. Skillstore reports evidence without deciding whether this Skill is safe.
https://skillstore.io/skills/hmohamed01-sql-expert/audits/7?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report[](https://skillstore.io/skills/hmohamed01-sql-expert?utm_source=security_passport_badge)<a href="https://skillstore.io/skills/hmohamed01-sql-expert?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/hmohamed01-sql-expert/security.svg" alt="Skillstore security assessment" loading="lazy"></a><iframe src="https://skillstore.io/embed/skills/hmohamed01-sql-expert.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>hmohamed01. (2026). sql-expert security audit report (audit version 7) [Author version unspecified]. Skillstore. https://skillstore.io/skills/hmohamed01-sql-expert/audits/7@techreport{hmohamed01-hmohamed01-sql-expert-2026,
author = {hmohamed01},
title = {sql-expert security audit report (audit version 7)},
institution = {Skillstore},
year = {2026},
number = {7},
url = {https://skillstore.io/skills/hmohamed01-sql-expert/audits/7},
note = {Author version unspecified}
}cff-version: 1.2.0
message: "If you use this Skill, cite its author and this versioned security audit report."
title: "sql-expert security audit report (audit version 7)"
version: "unspecified"
type: report
authors:
- name: "hmohamed01"
date-released: "2026-07-09"
url: "https://skillstore.io/skills/hmohamed01-sql-expert/audits/7"
identifiers:
- type: other
value: "skillstore:hmohamed01-sql-expert:audit:7"
description: "Skillstore immutable audit report identifier"
Each author remains a separate installable skill. The recommended variant is ranked by Skillstore evidence.
Why this variant is first
autumnsgrove-sql-expert
2026-08-21
hmohamed01-sql-expert
2026-08-21
Create clear SQL Server queries for reporting, application features, and data cleanup tasks.
Review query patterns, indexes, and execution plan symptoms to find practical performance improvements.
Apply parameterized dynamic SQL, transaction handling, and permission patterns to reduce database risk.
Write a T-SQL query for SQL Server that returns orders from the last 30 days with customer name, order date, and total amount. Explain each join and filter.
Create a SQL Server query that ranks products by monthly sales within each category. Use window functions and explain how ties are handled.
Review this slow SQL Server query and suggest a rewrite, useful indexes, and execution plan warnings to check. Schema, row counts, and current indexes are below.
Design a stored procedure that supports optional filters and dynamic sorting without SQL injection. Include validation rules, parameterization, and transaction guidance.
Author
hmohamed01License
MIT
Skillstore revision
r1
Version notice
The author did not declare a version.
Ref
1ffa7643651792ccb4bd3b15d924d2c97edff755
Maintenance freshness
7/18/2026
Usage
10 downloads · 412 views
File structure
Build Reliable PowerShell Tools
PowerShell projects need consistent structure, safe parameters, and current module guidance. This skill helps create scripts, modules, and GUIs using practical PowerShell references.
Build Swift Apps with Claude Code
Swift projects require many tools across Xcode, SPM, simulators, testing, formatting, and signing. This skill gives Claude structured guidance and scripts for common iOS and macOS development workflows.
Create Guided Project Scaffolds
New projects often require many setup choices before useful work can begin. This skill guides those choices and creates starter files for common software stacks.
Optimize 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.
Optimize 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.
Review PostgreSQL Migrations and Queries
by CJHarmath
PostgreSQL migrations can pass tests while causing locks, slow scans, or index bloat. This skill gives Claude, Codex, and Claude Code practical patterns for safer schema and query review.
Optimize Database Performance
by 89jobrien
Slow queries and weak indexes can make applications costly and unreliable. This skill guides SQL tuning, index design, caching, and N+1 fixes.
Optimize SQL Query Performance
by CuriousLearner
Slow database queries can increase costs and make applications feel unreliable. This skill helps Claude, Codex, and Claude Code review queries, execution plans, and index choices.
Optimize Postgres with Supabase Practices
by sickn33
Postgres performance problems often come from missing indexes, weak RLS policies, and poor connection management. This skill gives Supabase-aligned rules for improving queries, schema design, and database operations.