postgres-code-reviewReviews PostgreSQL code for indexing strategies, JSONB operations, connection pooling, and transaction safety. Use when reviewing SQL queries, database schem...
Install via ClawdBot CLI:
clawdbot install anderskev/postgres-code-reviewGrade Fair — based on market validation, documentation quality, package completeness, maintenance status, and authenticity signals.
Calls external URL not in known-safe list
https://api.example.com/users/{user_id}Audited Apr 17, 2026 · audit v1.0
Generated Apr 20, 2026
Reviewing PostgreSQL queries for product searches and order history to ensure indexes on WHERE/JOIN columns like product_id and user_id, improving page load times and reducing database load during peak sales.
Analyzing JSONB operations for storing and querying user preferences or activity logs, ensuring proper GIN indexes and operators to support real-time personalization features without performance degradation.
Checking transaction safety and isolation levels for concurrent updates in banking applications, preventing deadlocks and ensuring data integrity during high-frequency transfers and account modifications.
Reviewing connection pooling and management in a multi-tenant SaaS environment to avoid leaks and timeouts, ensuring reliable database access for numerous clients with varying usage patterns.
Optimizing PostgreSQL schemas and queries for large-scale patient record analysis, focusing on composite indexes for complex JOINs and parameterized statements to secure sensitive health data.
Offers ongoing PostgreSQL code reviews as part of a monthly plan, helping clients maintain performance and security in their database operations, with revenue from tiered subscriptions based on database size and review frequency.
Provides targeted PostgreSQL code review services for specific projects or migrations, generating revenue through fixed-price audits or hourly consulting rates for immediate optimization needs.
Licenses the skill package to IDE or CI/CD tool vendors, embedding automated PostgreSQL reviews into development workflows, with revenue from licensing fees per user or enterprise agreements.
💬 Integration Tip
Integrate this skill into CI/CD pipelines to automatically review SQL commits, or use it during code reviews in IDEs to catch issues early without manual effort.
Scored Apr 19, 2026
Use the @steipete/oracle CLI to bundle a prompt plus the right files and get a second-model review (API or browser) for debugging, refactors, design checks, or cross-validation.
Local search/indexing CLI (BM25 + vectors + rerank) with MCP mode.
Use when designing database schemas, writing migrations, optimizing SQL queries, fixing N+1 problems, creating indexes, setting up PostgreSQL, configuring EF Core, implementing caching, partitioning tables, or any database performance question.
Connect to Supabase for database operations, vector search, and storage. Use for storing data, running SQL queries, similarity search with pgvector, and managing tables. Triggers on requests involving databases, vector stores, embeddings, or Supabase specifically.
Use SQLite correctly with proper concurrency, pragmas, and type handling.
Write correct MySQL queries avoiding common pitfalls with character sets, indexes, and locking.