database-review

Review PostgreSQL queries and schemas for performance and security.

24|5|Updated Feb 8, 2026

Search Tags:#performance #security #postgresql #query-optimization #db-design #sql-review

Ready to run

npx skills add https://github.com/Luohaothu/everything-codex --skill database-review-luohaothu

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-review
Source: https://github.com/Luohaothu/everything-codex/tree/main/skills/database-review
Command: npx skills add https://github.com/Luohaothu/everything-codex --skill database-review-luohaothu

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PostgreSQL database performance bottlenecks, unsafe schemas, and insecure configurations that slow development and risk data integrity.

Core Features & Use Cases

Comprehensive query review and optimization recommendations for SQL statements, indexes, and execution plans.
Schema design and normalization guidance to ensure data integrity and scalable performance.
Security hardening including RLS evaluation, permission minimization, and best-practice access controls.
Use Case: You suspect frequent slow queries after a schema change; this skill analyzes query plans and suggests index changes.

Quick Start

Run a targeted review on a failing query or migration script to receive optimization recommendations.

Frequently Asked Questions about database-review

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

FAQPage Schema

How do I optimize slow PostgreSQL queries after a schema change?▼

To optimize slow PostgreSQL queries, analyze execution plans and apply index changes or query tuning. This skill reviews SQL statements and suggests index modifications to resolve performance bottlenecks caused by schema modifications.

What is the best way to review PostgreSQL schema design for data integrity?▼

The best way to review PostgreSQL schema design is through normalization guidance and best-practice data type checks. This ensures data integrity and scalable performance across production databases.

How do I configure Row Level Security (RLS) and access controls in PostgreSQL?▼

Configuring Row Level Security (RLS) involves evaluating permissions and minimizing access controls. This skill provides security hardening recommendations to enforce best-practice access controls in PostgreSQL.

Does this tool review migration scripts and suggest PostgreSQL indexing guidance?▼

Yes, this tool reviews migration scripts to provide PostgreSQL indexing guidance. It implements checks for best-practice naming conventions and data types to ensure safe database migrations.

When should I perform a PostgreSQL query tuning review?▼

You should perform a PostgreSQL query tuning review when you suspect frequent slow queries or face performance bottlenecks. It analyzes query plans to suggest necessary index changes and optimization strategies.

What are the limitations of automated SQL review for production databases?▼

Automated SQL review for production databases focuses on query optimization, schema normalization, and RLS configuration. It provides recommendations based on best-practice constraints but requires manual implementation of suggested changes.