skills.rest
AribSudia
AribSudiaCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

arib-postgres

Optimize PostgreSQL performance with indexing, query plan analysis, and lock-aware migrations.

2|Updated Apr 19, 2026
Search Tags:#performance#indexing#database#postgresql#migrations#optimization#sql
One-click install
npx skills add https://github.com/AribSudia/claude-code-methodology --skill arib-postgres
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: arib-postgres
Source: https://github.com/AribSudia/claude-code-methodology/tree/main/.claude/skills/arib-postgres
Command: npx skills add https://github.com/AribSudia/claude-code-methodology --skill arib-postgres

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill addresses the common pitfalls in PostgreSQL database management, such as inefficient query patterns, locking issues during migrations, and inadequate indexing, which often lead to performance degradation and production outages.

Core Features & Use Cases

  • Performance Tuning: Provides actionable guidance on indexing strategies, query plan analysis, and resolving N+1 performance traps.
  • Migration Safety: Offers protocols for safe, lock-aware online schema migrations to prevent application downtime.
  • Multi-tenancy & Security: Implements Row-Level Security (RLS) patterns to ensure robust data isolation between tenants.
  • Use Case: Use this skill when you need to optimize a slow-running query or perform a high-stakes schema change on a live production database.

Quick Start

Use the arib-postgres skill to review the current database schema and suggest performance optimizations for the user table.

Frequently Asked Questions about arib-postgres

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow PostgreSQL query performance?▼

To optimize slow PostgreSQL query performance, apply structured query plan analysis, resolve N+1 traps, and implement targeted indexing strategies to reduce execution latency.

How do I perform safe online schema migrations in PostgreSQL without downtime?▼

Safe PostgreSQL online schema migrations require lock-aware protocols that prevent blocking table access, ensuring application uptime while executing high-stakes production database changes.

What is the best way to isolate data for multi-tenant PostgreSQL databases?▼

Multi-tenant PostgreSQL data isolation is best achieved by implementing Row-Level Security (RLS) patterns, ensuring robust separation and protection of tenant-specific data.

Why does my PostgreSQL migration cause locking issues on a live database?▼

PostgreSQL migration locking issues occur when schema changes block concurrent operations; applying lock-aware migration protocols prevents these production outages and maintains reliability.

When do I need to analyze PostgreSQL query plans?▼

You need to analyze PostgreSQL query plans when diagnosing inefficient query patterns, identifying missing indexes, or resolving N+1 performance traps causing database degradation.

Related Skills

Explore More Software Engineering Skills→
tankpkgtankpkg
1

@tank/relational-db-mastery

Optimize PostgreSQL and MySQL query performance with indexing and tuning strategies.

Official
Advanced
sigmadigitalzasigmadigitalza
1

database-review

Review database schemas, migration files, and query performance.

Official
Advanced
mahamaneharouna9-cpumahamaneharouna9-cpu

database-expert

Optimize database performance and schema design across PostgreSQL, MySQL, MongoDB, and SQLite.

Community
Advanced
HainrixzHainrixz
18

db-multitenancy

Audit PostgreSQL multi-tenant schemas for isolation and performance issues.

Community
Advanced