Design PostgreSQL schemas with constraints, indexes, partitioning, and row-level security.
npx skills add https://github.com/isiou/AI-Library-VLLM --skill postgresql-isiou
Please help me install this Agent Skill. Skill: postgresql Source: https://github.com/isiou/AI-Library-VLLM/tree/main/.gemini/skills/postgresql Command: npx skills add https://github.com/isiou/AI-Library-VLLM --skill postgresql-isiou
This Skill helps you design PostgreSQL schemas that are correct, scalable, and maintainable, so tables, constraints, indexes, and storage choices match real workload needs.
Use the postgresql skill to design a PostgreSQL schema for my application, including tables, keys, data types, indexes, and migration-safe constraints.
High-intent search queries and answers about installing and using this skill.
To design a PostgreSQL schema that scales cleanly, plan primary keys, foreign keys, constraints, and indexes to match real workload needs. Evaluate PostgreSQL-specific data types and apply indexing and partitioning strategies to enforce data integrity while maintaining query performance.
Table partitioning in PostgreSQL is needed when tables grow large enough that query performance degrades. Partitioning splits large tables into smaller, manageable pieces, improving query speed and simplifying maintenance for transactional or analytical workloads.
Migration-safe DDL changes for PostgreSQL constraints and indexes require careful planning to avoid locking tables. Select appropriate index types and apply constraints without blocking transactional workloads, ensuring schema evolution preserves data integrity.
PostgreSQL row-level security (RLS) works effectively for multi-tenant transactional databases by enforcing data access policies directly at the row level. RLS policies restrict data visibility based on user roles, maintaining query performance while securing tenant data.
The best way to choose PostgreSQL-specific data types for schema design is to match types like JSONB, arrays, ranges, and timestamps to your data access patterns. Selecting the correct types optimizes storage and query performance for transactional and analytical workloads.
The best way to design PostgreSQL schemas for data integrity and query performance is to apply constraints, indexing, and partitioning strategically. Use PostgreSQL-specific data types and key planning to match table modeling with real transactional or analytical workload needs.
musujDefine project terminology, entities, relationships, and data structures.
inbharataiDesign normalized relational database schemas with ERDs, indexes, constraints, and migration scripts.
phuonghxGuide database schema modeling, indexing, ORM selection, and query optimization.
pascallammersDesign normalized relational and NoSQL database schemas with indexes and migrations.
