# Postgresql > Performance and design guidelines for PostgreSQL database in RSSVibe, including connection pooling, JSONB columns, and query optimization. Use this skill when optimizing database performance. Use when this capability is needed. - Skill: `tomevault-io/postgresql` (Agent Skill, multi-file: 2 files) - Install (CLI): `npx skillmds@latest add tomevault-io/postgresql` - Raw SKILL.md: https://api.skillmd.com/api/skills/tomevault-io/postgresql/raw - Safety review: pending (external: skill-scanner PASS, skillspector PASS) - Works with: Claude Code, Claude.ai, OpenAI Codex - Category: Coding & Dev Tools - Author: tomevault-io (https://skillmd.com/u/tomevault-io) - Updated: 2026-09-17 - Page: https://skillmd.com/skills/tomevault-io/postgresql --- # PostgreSQL Database ## Performance & Design - MUST use connection pooling for efficient connection management - MUST use JSONB columns for semi-structured data (avoid creating many tables for flexible schemas) - MUST create indexes on frequently queried columns to improve read performance --- ## Query Optimization - SHOULD monitor query plans for expensive operations - SHOULD use partial indexes when filtering on specific conditions - SHOULD consider materialized views for complex aggregations --- > Converted and distributed by [TomeVault](https://tomevault.io/claim/jakoss) — claim your Tome and manage your conversions.