II.
LibrarySkill overview
Reference · livelib-skill:web-development--postgresql
postgresql overview
PostgreSQL query optimization, indexing, full-text search, JSONB, and advanced features.
Attributes
displayName
postgresql
description
PostgreSQL query optimization, indexing, full-text search, JSONB, and advanced features.
libraryPath
library/specializations/web-development/skills/postgresql/SKILL.md
specialization
web-development
contentSummary
# PostgreSQL Skill
Expert assistance for PostgreSQL database design and optimization.
## Capabilities
- Design optimal schemas
- Create performant indexes
- Implement full-text search
- Work with JSONB data
- Optimize query performance
- Configure replication
## Indexing Patterns
Outgoing edges
lib_applies_to_domain1
- domain:web-development·DomainWeb Development
lib_belongs_to_specialization1
- specialization:web-development·Specialization
lib_covers_topic1
- topic:database-sharding·TopicDatabase Sharding
lib_involves_role2
- role:backend-engineer·RoleBackend Engineer
- role:fullstack-engineer·RoleFullstack Engineer
lib_requires_skill_area2
- skill-area:backend-data-persistence·SkillAreaBackend Data Persistence
- skill-area:database-migrations-zero-downtime·SkillAreaZero-Downtime Database Migrations
Incoming edges
None.