skills.rest
devopstales
devopstalesCOMMUNITY
Explore all skills by this author →
Website𝕏@_devopstalesGitHub

database-reviewer

Analyze PostgreSQL database performance and security with best practices.

1|Updated Apr 22, 2026
Search Tags:#performance#security#schema design#PostgreSQL#database optimization
One-click install
npx skills add https://github.com/devopstales/aiskillgrid --skill database-reviewer-devopstales
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-reviewer
Source: https://github.com/devopstales/aiskillgrid/tree/main/.agents/skills_back/database-reviewer
Command: npx skills add https://github.com/devopstales/aiskillgrid --skill database-reviewer-devopstales

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill addresses the complexities of PostgreSQL database management, including query optimization, schema design, security, and performance, providing proactive guidance for database specialists.

Core Features & Use Cases

  • Query Performance: Optimizes SQL queries, adds indexes, and prevents performance issues.
  • Schema Design: Assists in creating efficient schemas with proper data types and constraints.
  • Security & RLS: Implements Row Level Security and ensures least privilege access.
  • Connection Management: Configures pooling, timeouts, and limits for database connections.
  • Concurrency: Helps prevent deadlocks and optimizes locking strategies.
  • Monitoring: Sets up query analysis and performance tracking.
  • Use Case: Ideal for developers and DBAs working on PostgreSQL databases, especially when following best practices like those from Supabase.

Quick Start

Analyze the performance of your PostgreSQL database by running the command: db-reviewer analyze-performance

Frequently Asked Questions about database-reviewer

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

FAQPage Schema
How do I optimize PostgreSQL query performance and add the right indexes?▼

To optimize PostgreSQL query performance, this Skill analyzes your SQL queries, recommends appropriate indexes, and prevents common bottlenecks. It provides proactive guidance to refine execution plans and ensure efficient database operations.

What is the best way to design a PostgreSQL schema with proper constraints?▼

Designing a PostgreSQL schema requires creating efficient structures with proper data types and constraints. This Skill assists in defining tables and relationships that enforce data integrity while maintaining optimal database performance.

How do I implement Row Level Security in PostgreSQL for least privilege access?▼

Implementing Row Level Security in PostgreSQL ensures least privilege access by restricting data visibility per user. This Skill helps you configure RLS policies and secure your database using best practices like those from Supabase.

Can I configure PostgreSQL connection pooling and timeouts with this tool?▼

Yes, you can configure PostgreSQL connection management by setting up pooling, timeouts, and connection limits. This Skill provides guidance on optimizing these parameters to prevent connection exhaustion and improve database concurrency.

How do I prevent deadlocks and optimize locking strategies in PostgreSQL?▼

To prevent deadlocks and optimize locking strategies in PostgreSQL, this Skill helps you analyze transaction flows and implement proper concurrency controls. It provides targeted guidance for DBAs responsible for maintaining high-performing databases.

Related Skills

Explore More Software Engineering Skills→
pohlai88pohlai88

pg-sqill

Query PostgreSQL databases and explore table schemas using psql.

Community
Intermediate
Tnemo65Tnemo65

sql-pro

Analyze SQL execution plans and optimize slow queries across PostgreSQL, MySQL, SQL Server, and Oracle.

Community
Advanced
lciaccilciacci

supabase-python

Build FastAPI backends with Supabase authentication and typed PostgreSQL access.

Community
Intermediate
rnavarychrnavarych
14

role-database:database-monitoring

Configure monitoring and alert thresholds for PostgreSQL, MySQL, MongoDB, and Redis.

Community
Intermediate