🎯

postgres

🎯Skill

from planetscale/database-skills

What it does

Database-focused agent skills from PlanetScale covering MySQL/InnoDB schema, indexing, query tuning, PostgreSQL best practices, and the Neki sharded Postgres product.

Overview

Postgres is an official skill from PlanetScale's Database Skills collection that provides PostgreSQL best practices, query optimization, connection troubleshooting, and performance insights. It covers schema design, indexing, MVCC/VACUUM, WAL tuning, replication, monitoring, and PlanetScale-specific features like connection pooling and CLI insights.

Key Features

Schema Design Guidance - Provides best practices for PostgreSQL schema design, table structures, data types, and normalization patterns
Query Optimization - Covers indexing strategies, query planning, EXPLAIN analysis, and common performance anti-patterns
MVCC and VACUUM - Guides developers through PostgreSQL's multi-version concurrency control and vacuum processes for maintaining database health
PlanetScale Integration - Includes PlanetScale-specific features like connection pooling configuration and CLI-based performance insights
Companion Database Skills - Part of a collection that also includes MySQL, Vitess, and Neki (PlanetScale's sharded Postgres) skills

Who is this for?

This skill is designed for backend developers and database administrators working with PostgreSQL, particularly on PlanetScale's platform, who want AI-assisted guidance on database optimization and troubleshooting. It is ideal for teams managing production PostgreSQL databases who need consistent guidance on performance tuning, replication setup, and schema design decisions.

📦

Same repository

planetscale/database-skills(4 items)

postgres

Installation

Vibe Index InstallInstalls to .claude/skills/ - auto-recognized by Claude Code

npx vibeindex add planetscale/database-skills --skill postgres

skills.sh Install⚠ Installs to .agents/skills/ - may not be auto-recognized by Claude Code

npx skills add planetscale/database-skills --skill postgres

Manual InstallCopy SKILL.md content and save to the path below

~/.claude/skills/postgres/SKILL.md

SKILL.md

2,916Installs

369

Last UpdatedMar 11, 2026

View on GitHub Back to Skills

More from this repository3

🎯

mysql🎯Skill

Database-focused agent skills from PlanetScale covering MySQL/InnoDB schema, indexing, query tuning, PostgreSQL best practices, and the Neki sharded Postgres product.

🎯

vitess🎯Skill

Database-focused agent skills from PlanetScale covering MySQL/InnoDB schema, indexing, query tuning, PostgreSQL best practices, and the Neki sharded Postgres product.

🎯

neki🎯Skill

Database-focused agent skills from PlanetScale covering MySQL/InnoDB schema, indexing, query tuning, PostgreSQL best practices, and the Neki sharded Postgres product.