database

Audit PostgreSQL schemas and SQL patterns against best-practice rules.

4|Updated Feb 12, 2026
One-click install
npx skills add https://github.com/rbaumier/skills --skill database-rbaumier
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database
Source: https://github.com/rbaumier/skills/tree/main/database
Command: npx skills add https://github.com/rbaumier/skills --skill database-rbaumier

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill helps teams systematically review PostgreSQL schemas, queries, and operational practices against a comprehensive ruleset to surface defects and guidance.

Core Features & Use Cases

  • Schema design best practices, naming conventions, and data-type guidance for PostgreSQL.
  • Indexing, partitioning, migrations, and performance optimization patterns.
  • Security, access control, and ORM/repository-pattern considerations for robust apps.
  • Useful in code reviews, production remediation, and pre-deployment validation with actionable fixes.

Quick Start

Audit a given PostgreSQL schema and SQL snippets against the Skill rules to surface actionable fixes.

Frequently Asked Questions about database

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

FAQPage Schema
How do I audit PostgreSQL schema design for best practices?▼

You can audit PostgreSQL schema design by validating types, constraints, and naming conventions against a strict ruleset. This process surfaces defects in data modeling and provides actionable fixes for production-grade deployments.

What is the best way to review PostgreSQL indexes and migrations before deployment?▼

The best way to review PostgreSQL indexes and migrations is to evaluate SQL patterns against operational best-practice rules. This surfaces performance optimization patterns and potential defects during pre-deployment validation.

Can I check repository-pattern implementations against PostgreSQL security rules?▼

Yes, you can check repository-pattern implementations by auditing access control and SQL patterns. This validates security considerations and robust application practices across large databases.

Does this schema review process work for large production databases?▼

Yes, this schema review process works for large databases and production remediation. It audits operational procedures, indexing, and partitioning patterns to surface defects suitable for production-grade deployments.

How do I validate types and constraints in SQL code reviews?▼

To validate types and constraints in SQL code reviews, audit SQL snippets and schemas using embedded guidance rules. This surfaces actionable fixes for data-type guidance and naming conventions.