skills.rest
Luohaothu
LuohaothuCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/Luohaothu/everything-codex --skill database-review-luohaothu
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
klu-devklu-dev
2

postgres-patterns

Provide PostgreSQL optimization patterns for query performance, schema design, indexing, and security.

Community
Intermediate
derekhu0002derekhu0002

postgres-patterns

Apply PostgreSQL patterns for query tuning, indexing, and security.

Community
Intermediate
Kushal9889Kushal9889

husky

Sets up Husky git hooks to automate code quality checks and testing before commits.

Community
Intermediate
gemini-cli-extensionsgemini-cli-extensions
42

cloud-sql-postgres-health

Audit Cloud SQL for PostgreSQL instance health and performance bottlenecks.

Official
Intermediate