Does it check for Go source code modifications?

No, this skill is designed for schema-only PRs and will verify that no Go source files have been modified outside of the generated directory.

What migration tools does this skill support?

The skill is optimized for Postgres migrations using Goose annotations, checking for specific patterns like +goose Up and +goose Down.

What specific SQL requirements does it look for?

It checks for schema qualification, UUID primary keys, TIMESTAMPTZ types, soft delete columns, and appropriate foreign key ON DELETE behaviors.

Can it detect missing sqlc queries?

Yes, it enforces a standard set of queries for every entity, including Get, List (with pagination), Count, Create, Update, and SoftDelete.

How does it handle Proto ↔ SQL consistency?

It maps Protobuf field types (like google.protobuf.Timestamp) to SQL types (like TIMESTAMPTZ) to ensure the data layer correctly represents the API definitions.

Entity Store PR Auditor

Name: Entity Store PR Auditor
Author: viqueen

byviqueen

•

数据库管理

Automates the technical review of database entity stores, migrations, and SQL queries within backend pull requests.

This skill acts as a specialized agent to verify the integrity of data models in backend projects using Postgres, sqlc, and Protobuf. It systematically audits SQL migrations for schema-best practices, ensures sqlc queries follow strict naming and functional standards, and validates consistency between Protobuf definitions and the database layer. It is an essential tool for maintaining high standards in persistence layers by identifying missing CRUD operations, improper migrations, or type mismatches during the code review process.

主要功能

01Comprehensive sqlc query compliance checking for CRUD and naming

021 GitHub stars

03Structured audit reports with detailed PASS/FAIL status for each requirement

04Automated SQL migration validation for Postgres and Goose standards

05Consistency auditing between Protobuf definitions and SQL schemas

06Soft delete and audit column (created_at/updated_at) verification

使用场景

01Ensuring new microservice entities have complete and correct CRUD operations in sqlc

02Reviewing complex database migrations for schema qualification and naming consistency

03Verifying that Protobuf field changes are accurately reflected in SQL columns and query parameters

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add viqueen/claude-go-playground review-entity-store

For use in Claude.ai and ChatGPT

主要功能

01Comprehensive sqlc query compliance checking for CRUD and naming

021 GitHub stars

03Structured audit reports with detailed PASS/FAIL status for each requirement

04Automated SQL migration validation for Postgres and Goose standards

05Consistency auditing between Protobuf definitions and SQL schemas

06Soft delete and audit column (created_at/updated_at) verification

使用场景

01Ensuring new microservice entities have complete and correct CRUD operations in sqlc

02Reviewing complex database migrations for schema qualification and naming consistency

03Verifying that Protobuf field changes are accurately reflected in SQL columns and query parameters

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add viqueen/claude-go-playground review-entity-store

For use in Claude.ai and ChatGPT