Name: postgres
Rating: 90.8 (1 reviews)
Author: planetscale

postgres

PostgreSQL best practices, query optimization, connection troubleshooting, and performance improvement. Load when working with Postgres databases.

1.43x

Quality

63%

Does it follow best practices?

Impact

93%

1.43x

Average score across 17 eval scenarios

Securityby

Passed

No known issues

Optimize this skill with Tessl

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

Evaluation results

87%

32%

Project Vantage: Initial Database Schema

Schema design conventions

Criteria

Without context

With context

Identity primary keys

100%

No UUID primary keys

100%

CHECK over ENUM

100%

TIMESTAMPTZ for timestamps

100%

created_at on all tables

100%

FK column indexes

100%

75%

Index naming convention

100%

Constraint naming convention

37%

Singular snake_case names

100%

NOT NULL coverage

100%

66%

Explicit FK delete behavior

100%

BIGINT for all IDs and FKs

100%

Retailhub Query Performance Review

SQL query anti-pattern fixes

Criteria

Without context

With context

SELECT * eliminated

100%

Correlated subquery → JOIN

100%

LIMIT added to unbounded query

100%

SARGable date filter

100%

N+1 batch query

100%

Cursor pagination

100%

UNION → UNION ALL

100%

EXISTS over IN subquery

100%

Eager loading for ORM

100%

Explanations present

100%

93%

53%

Fieldwork Analytics: PlanetScale Connection Architecture

PgBouncer connection pooling setup

Criteria

Without context

With context

OLTP port 6432

100%

DDL/admin port 5432

100%

Session features on direct

100%

SSL parameters complete

100%

Dedicated PgBouncer username

100%

default_pool_size in range

100%

max_user_connections formula

100%

max_connections formula

20%

30%

No CPU-cores formula

100%

Transaction pooling limitations noted

100%

Repository: planetscale/database-skills
Commit: b156f4c

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

Table of Contents

Project Vantage: Initial Database Schema Retailhub Query Performance Review Fieldwork Analytics: PlanetScale Connection Architecture

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.