skills.rest
dhar174
dhar174COMMUNITY
Explore all skills by this author →
WebsiteGitHub

postgresql-code-review

Review PostgreSQL SQL code and schemas for design flaws and performance issues.

1|1|Updated Jun 4, 2024
Search Tags:#performance#security#postgresql#rls#code-review#schema-design#jsonb
One-click install
npx skills add https://github.com/dhar174/tiny_village --skill postgresql-code-review-dhar174
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: postgresql-code-review
Source: https://github.com/dhar174/tiny_village/tree/main/.github/skills/postgresql-code-review
Command: npx skills add https://github.com/dhar174/tiny_village --skill postgresql-code-review-dhar174

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

PostgreSQL-focused code review guidance to identify and fix database design, performance, and security issues early.

Core Features & Use Cases

  • Review JSONB usage, arrays, schema design, and security features (RLS) for PostgreSQL databases.
  • Provide actionable recommendations, anti-patterns, and performance improvements for code bases of varying sizes.
  • Use Case: A developer submits a SQL script for review; the Skill returns a prioritized list of issues and suggested fixes.

Quick Start

Submit your PostgreSQL script or schema for a comprehensive review and specify any performance or security goals.

Frequently Asked Questions about postgresql-code-review

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

FAQPage Schema
How do I review PostgreSQL schema design for performance and security issues?▼

To review PostgreSQL schema design, submit your SQL scripts to identify anti-patterns, enforce index strategies, validate constraints, and secure role configurations. This process returns a prioritized list of actionable design flaws and suggested fixes.

What is the best way to optimize JSONB and array usage in PostgreSQL?▼

Optimizing JSONB and array usage involves applying PostgreSQL-specific best practices to your code. A targeted code review identifies performance issues within your JSONB structures and arrays, providing actionable recommendations to improve database query efficiency.

How do I check my PostgreSQL database for Row Level Security (RLS) anti-patterns?▼

Checking for Row Level Security anti-patterns requires reviewing your stored procedures and schema designs for secure role and privilege configurations. The review process evaluates your RLS implementation to ensure proper access control and database security.

Can I use a code review to find PostgreSQL migration flaws before deployment?▼

Yes, you can use a PostgreSQL code review to find migration flaws before deployment. By submitting your SQL migrations, the review identifies design flaws and performance issues early, returning a prioritized list of issues and suggested fixes.

Does PostgreSQL code review work for stored procedures and extensions?▼

PostgreSQL code review works for stored procedures and extension usage by evaluating them against PostgreSQL-specific best practices. It identifies design flaws and performance issues across your database schemas, providing recommendations for secure configurations.

Related Skills

Explore More Software Engineering Skills→
avvaleavvale

aurora-tools-scripts

Manage PostgreSQL SQL migrations and stored procedures within the tools bounded context.

Official
Intermediate
Columbia-Cloudworks-LLCColumbia-Cloudworks-LLC
1

supabase-postgres-best-practices

Apply PostgreSQL best practices to Supabase migrations, indexing, partitioning, and RLS.

Official
Advanced
williamzujkowskiwilliamzujkowski
17

sql-database-management

Mitigate SQL security vulnerabilities across PostgreSQL, MySQL, and SQLite configurations.

Community
Intermediate
m16khbm16khb
1

codd

Analyze and optimize relational database schemas and SQL queries.

Community
Advanced