skills.rest
syanix
syanixCOMMUNITY
Explore all skills by this author →
GitHub

database-guidelines

Provide PostgreSQL schema design, indexing, and performance guidelines.

Updated Mar 14, 2026
Search Tags:#performance#indexing#schema design#database#postgresql#sql
One-click install
npx skills add https://github.com/syanix/agentic-sdlc --skill database-guidelines-syanix
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-guidelines
Source: https://github.com/syanix/agentic-sdlc/tree/main/templates/skills/database-guidelines/_base
Command: npx skills add https://github.com/syanix/agentic-sdlc --skill database-guidelines-syanix

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides comprehensive guidelines and best practices for designing robust, scalable, and performant database schemas and queries, specifically focusing on PostgreSQL.

Core Features & Use Cases

  • Schema Design: Enforces normalization rules, naming conventions, and optimal data type selection.
  • Indexing Strategy: Guides on choosing the right index types (B-tree, GIN, GiST, BRIN) and applying them effectively.
  • Performance Optimization: Offers patterns for connection management, read/write scaling, and efficient query writing.
  • Use Case: When designing a new e-commerce platform's database, use these guidelines to ensure tables are normalized, foreign keys are indexed, and TIMESTAMPTZ is used for all timestamps.

Quick Start

Consult the database guidelines for best practices on designing PostgreSQL schemas.

Frequently Asked Questions about database-guidelines

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

FAQPage Schema
What are the best practices for PostgreSQL schema design?▼

PostgreSQL indexing strategies involve selecting the right index types such as B-tree, GIN, GiST, and BRIN to match your query patterns, ensuring foreign keys are indexed, and applying them effectively for faster data retrieval.

When should I use JSONB columns in PostgreSQL?▼

You should use JSONB columns in PostgreSQL when you need flexible schema capabilities while maintaining query performance, as it allows for efficient document storage and retrieval within a relational database architecture.

How do I optimize PostgreSQL performance for read and write scaling?▼

PostgreSQL performance optimization for read and write scaling involves applying efficient query writing patterns, managing database connections properly, and utilizing partitioning strategies to distribute data efficiently.

What are the limitations of using table partitioning in PostgreSQL?▼

While PostgreSQL partitioning enhances performance for large datasets, its limitations include increased schema design complexity and potential overhead if partition keys are not aligned with your primary query patterns.

Related Skills

Explore More Software Engineering Skills→
imkdwimkdw
1

Backend Migrations

Automate Prisma migrations for PostgreSQL schema changes.

Community
Intermediate
JeffallanJeffallan
10.9k

database-optimizer

Diagnose slow queries and optimize indexes for PostgreSQL and MySQL.

Community
Advanced
GrupoUSGrupoUS
1

prisma-expert

Diagnose and optimize Prisma ORM schemas, migrations, and queries.

Community
Advanced
hainamchunghainamchung
54

database-architect

Plan scalable data architectures and select database technologies for relational, NoSQL, and time-series stores.

Community
Advanced