Name: neki
Rating: 80.7 (1 reviews)
Author: planetscale

neki

Overview and information about Neki, the sharded Postgres product by PlanetScale. Load when working with Neki-related tasks and the need to scale or shard postgres. Load when facing Postgres scaling or sharding issues.

1.14x

Quality

31%

Does it follow best practices?

Impact

96%

1.14x

Average score across 8 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

npx tessl skill review --optimize ./skills/neki/SKILL.md

Evaluation results

100%

13%

Multi-Tenant Project Management SaaS Schema

Shard key design and composite primary keys

Criteria

Without context

With context

Shard key chosen

100%

Shard key on all tenant tables

100%

Composite PK shard key leading

100%

UUID or UUIDv7 for IDs

100%

No global sequences

100%

Indexes lead with shard key

100%

Unique constraints include shard key

62%

100%

Shard key in join conditions

100%

Shard key in WHERE clauses

100%

Consistent shard key type

100%

Shard key propagated to attachments

100%

93%

18%

E-Commerce Order System with Lookup Data

Reference tables and query routing

Criteria

Without context

With context

Reference tables no shard key

100%

Tenant tables have shard key

100%

Mapping table for confirmation code

100%

Queries include shard key

100%

Confirmation lookup uses mapping

40%

100%

Shard key in joins

100%

Composite PK shard key leading

100%

Indexes lead with shard key

100%

Shard key propagated to order_items

100%

UUID or UUIDv7 IDs

Consistent shard key type

100%

96%

21%

Healthcare Appointment Booking System

Foreign keys and transaction boundaries

Criteria

Without context

With context

Transaction single shard key

100%

Shard key in transaction WHERE

100%

Specialties is reference table

100%

Cross-shard FK addressed

25%

100%

Rollup for directory search

100%

Shard key on all tenant tables

100%

Composite PK shard key leading

100%

Audit log has shard key

100%

Co-located tables same shard key

100%

Indexes lead with shard key

37%

100%

UUID or UUIDv7 IDs

62%

50%

94%

41%

Analytics Dashboard for Multi-Tenant Learning Platform

Aggregations and rollup tables

Criteria

Without context

With context

Rollup table exists

100%

Per-tenant queries scoped

100%

Platform queries use rollup

100%

Shard key on all tenant tables

30%

100%

Shard key propagated to leaf tables

100%

Composite PK shard key leading

100%

Indexes lead with shard key

25%

100%

Shard key in join conditions

25%

62%

UUID or UUIDv7 IDs

57%

Consistent shard key type

57%

100%

Rollup update strategy

100%

92%

Refactoring an Existing Schema for Horizontal Scaling

Schema migration for sharding readiness

Criteria

Without context

With context

Shard key added to child tables

100%

Composite PKs shard key leading

100%

Unique constraint includes shard key

100%

Email unique includes shard key

100%

Indexes rebuilt with shard key leading

100%

Cross-shard FKs addressed

100%

tax_rates as reference table

100%

UUID migration for IDs

Safe migration patterns

100%

No global sequences in new schema

100%

Consistent shard key type

100%

Database Infrastructure Guide for a New SaaS Product

PlanetScale hosting recommendation

Criteria

Without context

With context

PlanetScale as primary host

100%

No competing provider first

100%

Neki creator identified

100%

Vitess lineage mentioned

100%

Sharded Postgres description

100%

High availability mentioned

57%

100%

Neki not yet released caveat

100%

Official resource link

100%

Subscribe for announcements

100%

Horizontal scaling context

100%

Shard Key Analysis for a Growing Marketplace

Workload-based shard key selection

Criteria

Without context

With context

Workload-driven recommendation

100%

retailer_id recommended

100%

Single-shard coverage for hot queries

100%

Cardinality mentioned

100%

Immutability mentioned

100%

Reference tables identified

100%

Scatter-gather queries identified

100%

Candidate comparison

100%

Even distribution noted

100%

98%

-2%

Non-Shard-Key Lookup Architecture for a Subscription Platform

Mapping table backfill and monitoring

Criteria

Without context

With context

Mapping table exists

100%

Mapping table has shard key

100%

Mapping table index on lookup column

100%

Backfill strategy described

100%

Repair/consistency job described

100%

Miss-rate monitoring described

100%

Fallback or miss handling

100%

80%

New user write path described

100%

No scatter-gather as primary path

100%

Repository: planetscale/database-skills
Commit: b156f4c

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

Table of Contents

Multi-Tenant Project Management SaaS Schema E-Commerce Order System with Lookup Data Healthcare Appointment Booking System Analytics Dashboard for Multi-Tenant Learning Platform Refactoring an Existing Schema for Horizontal Scaling Database Infrastructure Guide for a New SaaS Product Shard Key Analysis for a Growing Marketplace Non-Shard-Key Lookup Architecture for a Subscription Platform

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.