Skills
.Work. You
Rest

expert-postgres

Community

Design faster, safer PostgreSQL schemas.

Data & Analytics#query optimization#indexing#postgresql#plpgsql#jsonb#mvcc#explain analyze
Authorricardops34
Version1.0.0
Installs0

System Documentation

What problem does it solve?

It helps you design and optimize PostgreSQL databases when performance, concurrency, and advanced data modeling requirements make plain SQL insufficient.

Core Features & Use Cases

  • Advanced PostgreSQL modeling: Leverages PostgreSQL capabilities such as CTEs, Window Functions, Partial Indexes, and JSONB to model complex domains accurately.
  • Query and performance tuning: Uses EXPLAIN ANALYZE to pinpoint bottlenecks and guide indexing or query rewrites for better read/write efficiency.
  • Production-grade DBA guidance: Recommends correct concurrency considerations with MVCC and practical maintenance like VACUUM and ANALYZE, using PL/pgSQL only when persistence/performance demands it.

Quick Start

Ask an AI to review your PostgreSQL schema and queries for advanced modeling and performance improvements, including suggested indexes and MVCC-aware design changes.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: expert-postgres
Download link: https://github.com/ricardops34/rcg-crm/archive/main.zip#expert-postgres

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.