CtrlK
BlogDocsLog inGet started
Tessl Logo

sql-database-assistant

Use when the user asks to write SQL queries, optimize database performance, generate migrations, explore database schemas, or work with ORMs like Prisma, Drizzle, TypeORM, or SQLAlchemy.

64

Quality

76%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide

SecuritybySnyk

Passed

No findings from the security scan

Fix and improve this skill with Tessl

tessl review fix ./.gemini/skills/sql-database-assistant/SKILL.md

The canonical home for this skill is sql-database-assistant in alirezarezvani/claude-skills

SKILL.md
Quality
Evals
Security

Quality

Content

57%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

The body is a dense, actionable SQL cookbook with strong code examples, but it is over-long for SKILL.md, inlines reference material that should live in separate files, and—critically—references six bundle files that do not exist. Migration workflows also lack explicit validation feedback loops.

Suggestions

Create the missing bundle files (scripts/query_optimizer.py, migration_generator.py, schema_explorer.py and references/query_patterns.md, optimization_guide.md, orm_patterns.md) or remove the references and inline only what is needed.

Move the dialect-differences, transaction-isolation, and backup-recipe tables out of SKILL.md into reference files so the main skill stays a lean overview with one-level-deep pointers.

Add explicit validate→fix→retry checkpoints to the migration and backfill workflows (e.g., verify row counts and integrity after each batch, halt and fix on mismatch) to satisfy the database-operations feedback-loop expectation.

DimensionReasoningScore

Conciseness

Mostly concrete code and tables with little prose padding, but ~450 lines inline reference-grade material (dialect-differences table, transaction-isolation table, backup recipes for three engines, a 10-row anti-patterns table) that the body itself implies belongs in the referenced files.

3 / 5

Actionability

Abundant copy-paste-ready SQL/bash/Python/Prisma/TypeScript examples, but the three invoked scripts (query_optimizer.py, migration_generator.py, schema_explorer.py) do not exist in any scripts/ directory, so those commands are not actually runnable.

4 / 5

Workflow Clarity

Multi-step sequences are present (translation patterns, EXPLAIN workflow, expand-contract migration) but validation checkpoints are mostly missing or implicit; per the rubric, a database/migration skill lacking validate-fix-retry feedback loops is capped at 3.

3 / 5

Progressive Disclosure

Section structure is clean and references are clearly signaled one level deep ("> See references/..."), but no references/ or scripts/ bundle directories exist, so all six referenced files are broken, and bulk reference material is inlined rather than split out.

3 / 5

Total

13

/

20

Passed

Description

96%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A strong, trigger-oriented description that names concrete actions and natural user phrases while explicitly framing when to invoke it. The only soft spot is minor overlap with sibling database skills on migrations and schema exploration.

DimensionReasoningScore

Specificity

Lists multiple concrete actions — "write SQL queries, optimize database performance, generate migrations, explore database schemas, or work with ORMs" — covering the domain comprehensively rather than gesturing at it.

5 / 5

Completeness

Explicitly answers both what (the verb phrases) and when ("Use when the user asks to...") with concrete trigger phrases, satisfying the top anchor despite what/when being fused into one sentence.

5 / 5

Trigger Term Quality

Phrases are framed as user utterances ("Use when the user asks to...") and include natural terms plus named ORM brands (Prisma, Drizzle, TypeORM, SQLAlchemy), giving comprehensive trigger coverage.

5 / 5

Distinctiveness Conflict Risk

Clear SQL/ORM niche with distinct triggers, but "generate migrations" and "explore database schemas" overlap with sibling skills (database-designer, migration-architect) named in the body, creating minor conflict risk.

4 / 5

Total

19

/

20

Passed

Validation

93%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation15 / 16 Passed

Validation for skill structure

CriteriaDescriptionResult

referenced_paths_exist

Referenced path issues: 13 missing

Warning

Total

15

/

16

Passed

Repository
alirezarezvani/claude-skills
Reviewed

Table of Contents

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.