database-best-practices

Guide PostgreSQL database design and GORM patterns for Go services.

1|Updated Jul 16, 2025
One-click install
npx skills add https://github.com/linskybing/platform-go --skill database-best-practices-linskybing
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: database-best-practices
Source: https://github.com/linskybing/platform-go/tree/main/.github/skills/database-best-practices
Command: npx skills add https://github.com/linskybing/platform-go --skill database-best-practices-linskybing

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

This Skill provides guidance on robust database design, ORM usage with GORM, query optimization, transactions, and migrations for PostgreSQL in platform-go.

Core Features & Use Cases

  • Schema design best practices and indexing guidance for Go services.
  • Safe migrations, versioning, and rollback considerations.
  • Performance-oriented query patterns and transactional workflows.

Quick Start

Run the migration-check.sh script located at .github/skills/database-best-practices/scripts/migration-check.sh to validate migrations and safety checks.

Frequently Asked Questions about database-best-practices

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

FAQPage Schema
What are the best practices for schema design and indexing in PostgreSQL using GORM?

Schema design best practices for PostgreSQL using GORM involve context-aware operations, optimized indexing strategies, and reliable error handling within your Go services to ensure robust data integrity.

How do I run safe database migrations with versioning for a Go service?

Run safe database migrations with versioning by executing the migration-check.sh script to validate migration safety checks and rollback considerations for your Go and GORM PostgreSQL stack.

How do GORM transactional workflows handle reliable error handling in Go?

GORM transactional workflows enforce reliable error handling in Go by applying context-aware operations that maintain data consistency during complex database queries and transactional updates.

Can I use this database migration guidance for any Go service or only specific platforms?

This database migration guidance applies specifically to platform-go services, enforcing safe migrations, versioning, and reliable error handling within a Go + GORM PostgreSQL stack.

What's the best way to optimize PostgreSQL query patterns for Go services?

The best way to optimize PostgreSQL query patterns is applying performance-oriented transactional workflows and indexing guidance tailored for Go services using GORM.

What limitations exist when managing PostgreSQL rollback considerations with GORM?

PostgreSQL rollback considerations with GORM require safe migration versioning and context-aware operations to prevent data loss, ensuring reliable error handling during database schema updates.