Provide architectural guidance and performance optimization for PostgreSQL 16+ databases.
npx skills add https://github.com/brenordv/claude-skill-set --skill postgres-brenordv
Please help me install this Agent Skill. Skill: postgres Source: https://github.com/brenordv/claude-skill-set/tree/main/skills/postgres Command: npx skills add https://github.com/brenordv/claude-skill-set --skill postgres-brenordv
This Skill addresses the complexity of managing production-grade PostgreSQL databases, helping you avoid common performance pitfalls, security vulnerabilities, and data integrity issues.
Ask the postgres skill to analyze the current schema and suggest missing indexes for the orders table.
High-intent search queries and answers about installing and using this skill.
To optimize slow PostgreSQL queries, use EXPLAIN ANALYZE to diagnose execution bottlenecks and apply efficient join patterns or missing indexes. This approach systematically identifies performance issues to improve query response times.
The best PostgreSQL indexing strategies for high-performance workloads include using B-tree for standard lookups, GIN for composite values, and HNSW for vector searches. Selecting the right index type ensures rapid data retrieval.
To perform zero-downtime migrations in PostgreSQL 16+, follow production-grade maintenance workflows that enforce best practices for schema changes. This ensures database availability and data integrity during updates.
You should use table partitioning in PostgreSQL when managing high-performance workloads that require faster data access and easier maintenance. Partitioning divides large tables into smaller, manageable pieces for optimized querying.
To implement Row-Level Security (RLS) in PostgreSQL, apply security best practices that restrict data access at the row level based on user roles. This ensures reliable data protection and enforces strict access controls.
roanbrasilDesign PostgreSQL schemas, indexes, and zero-downtime migrations.
samhvw8Guide MongoDB and PostgreSQL schema design, query optimization, migrations, and backups.
djankiesConfigure Prisma Client connection pools for PostgreSQL deployments.
taewook486Guide database management across PostgreSQL, Oracle, MongoDB, and Redis systems.
