platform-database

SQL database design, query optimization, and migration safety. Use when writing queries, designing schemas, or planning database migrations.

1.06x

Quality

56%

Does it follow best practices?

Impact

95%

1.06x

Average score across 3 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./skills/platform/platform-database/SKILL.md

Evaluation results

100%

Reporting Dashboard Performance Review

Query performance optimization

Criteria

Without context

With context

N+1 fix: JOIN or IN

100%

Explicit columns in getCustomerOrders

100%

Filter before aggregate

100%

No SELECT * in getProOrgStats

100%

Trailing wildcard or full-text search

100%

EXISTS over IN subquery

100%

No function on indexed column

100%

Explicit columns in getSignupsIn2024

100%

Adding Subscription Tiers to a Live Platform

Safe migration authoring

Criteria

Without context

With context

No edit to existing file

100%

Column added as nullable or with default

100%

Schema and data separated

100%

Backfill is batched

100%

NOT NULL constraint separate

100%

One change per migration file

30%

100%

Migration files numbered sequentially

100%

Execution order documented

100%

No accidental DROP/TRUNCATE

100%

86%

11%

Job Board Platform: Database Design and Data Access Layer

Schema design and indexing

Criteria

Without context

With context

Timestamps on all tables

37%

75%

Appropriate column types

100%

VARCHAR with length for bounded strings

100%

FK indexes present

83%

100%

Covering index for browse-jobs query

100%

Index for application feed query

100%

CONCURRENTLY used for index creation

UNION ALL for activity stream

100%

No SELECT * in production queries

100%

Short transactions

100%

Related mutations wrapped atomically

100%

Repository: ravnhq/ai-toolkit
Commit: 7b466be

Evaluated: 29 days ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Reporting Dashboard Performance Review Adding Subscription Tiers to a Live Platform Job Board Platform: Database Design and Data Access Layer

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.