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.